Fuzzywuzzy ratio for postgres.
Fuzzy string matching like a boss. It uses Levenshtein Distance to calculate the differences between sequences in a simple-to-use package
pgxn install fuzzywuzzy
create extesion fuzzywuzzy;
select name, ratio(name, '人棉锦纶') as ratio from products order by 2 desc limit 3;
name | ratio
----------+-------
人棉锦纶 | 100
人棉锦纶 | 100
人棉 | 67
https://github.com/hooopo/pg-fuzzywuzzy
[hooopo]
Copyright (c) 2019 hooopo.