public inbox for [email protected]help / color / mirror / Atom feed
Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? 4+ messages / 2 participants [nested] [flat]
* Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? @ 2021-11-11 14:23 Jean Baro <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Jean Baro @ 2021-11-11 14:23 UTC (permalink / raw) To: pgsql-novice 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? @ 2021-11-11 14:26 Jean Baro <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Jean Baro @ 2021-11-11 14:26 UTC (permalink / raw) To: [email protected] 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? @ 2021-11-11 16:11 Laurenz Albe <[email protected]> parent: Jean Baro <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Laurenz Albe @ 2021-11-11 16:11 UTC (permalink / raw) To: Jean Baro <[email protected]>; [email protected] On Thu, 2021-11-11 at 11:26 -0300, Jean Baro wrote: > 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?. These functions focus on phonetic similarity. There are no other variants of these functions, but perhaps pattern matching (which focuses on spelling, *not* phonetics) can help: CREATE EXTENSION pg_trgm; -- now you can use the "similar to" operator SELECT * FROM tab WHERE name % 'lorenz'; Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? @ 2021-11-14 01:06 Jean Baro <[email protected]> parent: Laurenz Albe <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Jean Baro @ 2021-11-14 01:06 UTC (permalink / raw) To: Laurenz Albe <[email protected]>; +Cc: [email protected] Thank you very much. Em qui., 11 de nov. de 2021 13:11, Laurenz Albe <[email protected]> escreveu: > On Thu, 2021-11-11 at 11:26 -0300, Jean Baro wrote: > > 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?. > > These functions focus on phonetic similarity. > > There are no other variants of these functions, but perhaps pattern > matching > (which focuses on spelling, *not* phonetics) can help: > > CREATE EXTENSION pg_trgm; > > -- now you can use the "similar to" operator > SELECT * FROM tab WHERE name % 'lorenz'; > > Yours, > Laurenz Albe > -- > Cybertec | https://www.cybertec-postgresql.com > > ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2021-11-14 01:06 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2021-11-11 14:23 Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? Jean Baro <[email protected]> 2021-11-11 14:26 Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? Jean Baro <[email protected]> 2021-11-11 16:11 ` Laurenz Albe <[email protected]> 2021-11-14 01:06 ` Jean Baro <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox