public inbox for [email protected]
help / color / mirror / Atom feedPhonetic 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]>
2021-11-11 16:11 ` Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? Laurenz Albe <[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 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 ` Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? 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-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 ` Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? Laurenz Albe <[email protected]>
@ 2021-11-14 01:06 ` Jean Baro <[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