fuzzywuzzy

Synopsis

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

https://github.com/hooopo/pg-fuzzywuzzy

[hooopo]