something better than pgtrgm?

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: something better than pgtrgm?
Date: 2012-10-09 12:10:26
Message-ID: CAHnozTjPBFuGf0_=xR2EBK4iEzhRsudKFgZy3ZqxS3DAbFPRSA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I need a *language unaware* text comparison algorithm, so i found pgtrgm.
But i am not so content with it, because the similarities it finds are:

- biased to favor text that is the same in the first character
- much dependent on similar length of the strings

Are there any other options?

(i want to use it for *"did you mean ...?"* for approx 6-10 character codes
or 8-20 letter words of mixed languages)

Cheers,

WBL
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2012-10-09 12:18:09 Re: something better than pgtrgm?
Previous Message Виктор Егоров 2012-10-09 10:31:32 Re: CTE materializing sets?