Re: similarity of names
Date: Wed, 11 Mar 2009 14:59:25 +0100
Am Mon, 9 Mar 2009 07:52:48 -0700 (PDT) schrieb fransh_at_hotmail.com:
Thanks for advising to this, the "Levenshtein Distance" is IMHO the best solution for similarity, I did'nt know that it exists in Oracle.
http://www.oracle.com/technology/books/pdfs/expert%20oracle%20pl_sql%20ch%201.pdf 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)
-- Norbert Oracle9i Enterprise Edition Release 188.8.131.52.0 64BitReceived on Wed Mar 11 2009 - 08:59:25 CDT