From: | Jean Baro <jfbaro(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? |
Date: | 2021-11-11 14:20:19 |
Message-ID: | CA+fQeenDugbA0g0_-tXYDkiTH-6hOSTrnpN04zYjh+H0CdXMmg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello people,
Please, I am working on a PoC for Real-time Person Identification, and one
of the critical aspects of it is to support both minor misspelling and
phonetic variations of First, Middle, and Last name. Like HarinGton ==
HarrinBton or RaphEAl == RafAEl. It's working for longer names, but it's a
bit more imprecise for names like Lee and John. I am using Double Metaphone
through dmetaphone() and dmetaphone_alt() in PostgreSQL 13.3 (Supabase.io).
And although I appreciate Double Metaphone it returns a (too?) short string
as the phonetic representation compared to metaphone(string, length).
metaphone() has parameters to make the resulting phonetic representation
longer. I investigated dmetaphone() and couldn't find anything other than
the default function. Is there a way of making dmetaphone() and
dmetaphone_alt() return a longer phonetic representation similar to
metaphone()'s, but with a ALT variation?.
Any help would be much appreciated.
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Jean Baro | 2021-11-11 14:23:57 | Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? |
Previous Message | chris | 2021-11-11 14:05:03 | Re:Why in pgAdmin an active session is marked/highlighted in Red |