public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jean Baro <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: [email protected]
Subject: Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer?
Date: Sat, 13 Nov 2021 22:06:24 -0300
Message-ID: <CA+fQeekJPf+yu9+FoCfjuJGYfC2ZftNRp-Cf=zKtwLTdV3vyuw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CA+fQee=8y_BB17sHg8YKyrYLe+vdBhKd2JHZjwn6b_bv2uxnjQ@mail.gmail.com>
<[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
>
>
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer?
In-Reply-To: <CA+fQeekJPf+yu9+FoCfjuJGYfC2ZftNRp-Cf=zKtwLTdV3vyuw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox