Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer?

Поиск
Список
Период
Сортировка
От Jean Baro
Тема Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer?
Дата
Msg-id CA+fQeekSmv=k=bgKtY6UXnW8x+fS-7TgQVADoPpE0AcK+UtNnw@mail.gmail.com
обсуждение исходный текст
Ответ на Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer?  (Jean Baro <jfbaro@gmail.com>)
Список pgsql-general
Sorry, please remove this question, I sent it to the wrong mailing list.

On Thu, Nov 11, 2021 at 11:20 AM Jean Baro <jfbaro@gmail.com> wrote:

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Jean Baro
Дата:
Сообщение: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer?
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Why in pgAdmin an active session is marked/highlighted in Red