3 ms·
Surprised there's no mention of pg_trgm for trigram-based fuzzy match. I guess for English names, Soundex is fairly good. https://www.postgresql.org/docs/curr
by z77dj3kl 6y ago
Surprised there's no mention of pg_trgm for trigram-based fuzzy match.
I guess for English names, Soundex is fairly good.
https://www.postgresql.org/docs/current/pgtrgm.html https://www.postgresql.org/docs/current/pgtrgm.html
- dfsegoat 6y agopg_trgm is definitely what the doctor ordered when you get into more complex cases -- for us, that is pharmaceutical product names [1]. pg_trgm has really helped us with fuzzy matching on complex, multiword chemical names. https://en.wikipedia.org/wiki/International_nonproprietary_name https://en.wikipedia.org/wiki/International_nonproprietary_n...
- ilitirit 6y agoYeah, I basically used pg_trgm to completely replace an old, non-supported version of ElasticSearch at a previous company. We basically needed to match on similar team names (e.g. Bayern München vs Bayern Munich as a simple example) and it turns out Postgres could handle all the matching requirements with ease.
- merb 6y agois it? > At present, the soundex, metaphone, dmetaphone, and dmetaphone_alt functions do not work well with multibyte encodings (such as UTF-8). I#m not sure but most postgres databases use utf-8