RE: RE: anyone have any soundex scripts?

rgaffuri,
Ok let get down to the algorithm of SOUNDEX. As I reminisce, this is what SOUNDEX does:

1. It keeps the FIRST letter in the chain of characters and REMOVES all vocals that follows: a, e, h, i, o, u, w and y.
2. It assigns the numbers to remaining letters as follow: 1 = b, f, p, v 2 = c, g, j, k, q, s, x, z 3 = d, t 4 = t 5 = m, n 6 = r
3. If the sequence contains 2 or more numbers, all are replace except the FIRST one.
4. It returns the first 4 bits, padded with zero (s).

NOTE:

1. Soundex is case in-sensitive
2. The first 5 consoles are used to find the value returned for comparing.

This is what I know about this algorithm and probably what Oracle used to write SOUNDEX...

Does this helps you ?

Regis         

-----Original Message-----
Sent: Monday, June 09, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L

one that is already written to find duplicates.

like I stated earlier. you have to write quite a bit of logic into the SOUNDEX function to make it tell the difference between

301 Fof Lane
301 Faf Lane
>
> From: "Seefelt, Beth" <[EMAIL PROTECTED]>
> Date: 2003/06/09 Mon AM 11:04:53 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RE: anyone have any soundex scripts?
>
>
> What advanced functionality are you looking for?
>
> -----Original Message-----
> Sent: Monday, June 09, 2003 10:29 AM
> To: Multiple recipients of list ORACLE-L
>
>
> yes, Im familiar with that function. but you have to write a soundex
> algorithm in order to get advanced functionality. I wouldnt even know
> where to start with something like that.
>
> Im hoping there is one on the web some where.
> >
> > From: "Seefelt, Beth" <[EMAIL PROTECTED]>
> > Date: 2003/06/09 Mon AM 09:59:43 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: anyone have any soundex scripts?
> >
> >
> > 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
> > ---------------------------------------------------------------------
> > 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: <[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
> ---------------------------------------------------------------------
> 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: <[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).
*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error, 
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Regis Biassala
  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).