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
select name, ratio(name, '人棉锦纶') as ratio from products order by 2 desc limit 3; name | ratio ----------+------- 人棉锦纶 | 100 人棉锦纶 | 100 人棉 | 67
Copyright and License
Copyright (c) 2019 hooopo.