Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 28 Aug 2003 @ 11:16:48 GMT


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 


Subj:   SOUNDEX
 
From:   David Clough

Following on from the recent considerations regarding Prefix matching, I've been looking at doing some Customer Name matching.

I've had a look at using SOUNDEX against a 'crunched' input name (I did the crunching, by the way, stripping out non-alphabetic characters).

To my surprise, I'm getting names having the same Soundex value but the actual crunched names themselves are completely different, other than the first letter.

Has anybody used Soundex in a way that successfully matches very similar names?

Dave Clough
Database Designer
Database Design Group



     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016