RE: anyone have any soundex scripts?

From: Seefelt, Beth <Beth.Seefelt_at_TetleyUSA.com>
Date: Mon, 09 Jun 2003 06:16:51 -0700
Message-ID: <F001.005AD741.20030609055942@fatcity.com>

There is a SOUNDEX sql function. Check tahiti.oracle.com for info.

HTH. -----Original Message-----
Sent: Monday, June 09, 2003 8: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: Seefelt, Beth
INET: [EMAIL PROTECTED]

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