Re: RE: anyone have any soundex scripts?
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).
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).
RE: RE: anyone have any soundex scripts?
Soundex essentially takes a single word and produces a value which can be
compared to a similar value, to determine if the words are logically
equivalent, mostly by paying attention to consonants.
PROD select soundex('Fairfield') from dual
2 /
F614
1* select soundex('Faerfield') from dual
PROD /
F614
PROD select soundex('Fairfied') from dual
2 /
F613
PROD select soundex('Freyfeld') from dual
2 /
F614
An enhanced algorithm would take into account false positives (like the one
above; I doubt any human being would think that Freyfeld and Fairfield
were the same person with a variant spelling) and false negatives which
occur very easily when you don't have the same number of words being
compared, or one word is missing or abbreviated, or an important consonant
is missing or misplaced. You really need address merge/purge software,
which exists out there, included complete packages and just APIs. Try a
search on that.
-Original Message-
Sent: Monday, June 09, 2003 11:05 AM
To: Multiple recipients of list ORACLE-L
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: Tierstein, Leslie
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).
RE: RE: anyone have any soundex scripts?
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
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: A. 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. B. 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 C. If the sequence contains 2 or more numbers, all are replace except the FIRST one. D. 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
RE: RE: anyone have any soundex scripts?
Store the soundex version of the word you are interested in, then create a unique index on that column. Consider a function-based index based on the soundex function. If each row potentially contains a variable number of words of interest, you could create a child table. The possibilities are endless. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 09, 2003 11:30 AM 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
RE: RE: anyone have any soundex scripts?
Try the Levenshtein Distance algorithm. If you scroll to the bottom of the page you will see a PL/SQL implementation. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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).
