Re: similarity of names

From: Norbert Winkler <>
Date: Wed, 11 Mar 2009 14:59:25 +0100
Message-ID: <a6cb0mfk4w30.3bphbs6yc8zv$>

Am Mon, 9 Mar 2009 07:52:48 -0700 (PDT) schrieb

Thanks for advising to this, the "Levenshtein Distance" is IMHO the best solution for similarity, I did'nt know that it exists in Oracle.

And in I see it's the well known algorithm they iterate in PL/SQL. So I could give it a try to compare the speed of replace(replace(.. by a PL/SQL-cylce.

TRANSLATE() isn't a solution because I want to change German Umlaut --> AE (1 char into 2 chars)

Oracle9i Enterprise Edition Release 64Bit
Received on Wed Mar 11 2009 - 08:59:25 CDT

Original text of this message