RE: anyone have any soundex scripts?

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 09 Jun 2003 06:30:10 -0700
Message-ID: <F001.005AD76F.20030609060501@fatcity.com>

Have you checked out the Oracle SOUNDEX() function?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] -----Original Message-----
Sent: Monday, June 09, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L

I was on a project a few years ago where we used a soundex algorithm to determine and eliminte duplicate data.

For example we would have:

301 Fairfield Lane
301 Faerfield Lane

Notice the typo? The soundex algorithm caught it. Unfortunately I forgot to grab a copy before I left. Everytime I do a google search on soundex I get a theory website explaining the math behind it.

anyone have one written? or know where I can find one? It is incredibly useful.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------