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).
RE: anyone have any soundex scripts?
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 - 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?
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).
Re: anyone have any soundex scripts?
You might consider an interMedia Text index on the column(s) of interest. The interMedia Fuzzy Search and scoring functionality (and others) may prove more flexible than Soundex. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: anyone have any soundex scripts? 06/09/2003 07:49 AM Please respond to 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. -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
FW: RE: anyone have any soundex scripts?
I guess a link would help. http://www.merriampark.com/ld.htm -Original Message- From: Jacques Kilchoer 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).