README.md

February 27, 2019 · View on GitHub

fuzzywuzzy

Synopsis

Fuzzywuzzy ratio for postgres.

Description

Fuzzy string matching like a boss. It uses Levenshtein Distance to calculate the differences between sequences in a simple-to-use package

Usage

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

Support

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

Author

[hooopo]

Copyright (c) 2019 hooopo.