XPost: comp.programming, comp.databases   
   From: blp@cs.stanford.edu   
      
   "Paul E. Black"  writes:   
      
   > nowhere@home.com wrote:   
   > > We need to 'filter' real-time transactions that can contain names and   
   > > addresses against a blacklist of names and address held in a database.   
   > >   
   > > Is there a good 'standard' way of doing this given that there may be   
   > > spelling or format differences between the original and the blacklist?   
   >   
   > Matching names (people's names, as well as street or city names) might   
   > be done with a hueristic like double metaphone   
   >     http://www.nist.gov/dads/HTML/doubleMetaphone.html   
   > or soundex   
   >     http://www.nist.gov/dads/HTML/soundex.html   
      
   It's amusing that you suggest Soundex for this purpose, seeing   
   how well it has worked out for keeping terrorists off airplanes.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)