[Pdx-pm] Encoding for fuzzy matching

[Michael Rasmussen]

Roderick A. Anderson wrote:
> I have a database that I need to weed duplicate entrys out of based on
> their street address.  I will have them CASS certified but there will
> cases where one might have a Suite, Apt, etc. and the other not but they
> are for the same person.

Wouldn't:

   123 Main Street, Apt. 15
   Anyplace, ST USA  #####-####

be different from

    123 Main Street
    Anyplace, ST USA #####-####

in a fully CASS certified address list?  The Zip+4 would differ.

Or is the point of your question that you're working toward CASS and resolving
these issues is part of the work?

-- 
   Michael Rasmussen, Portland, Ore, USA
  Be Appropriate && Follow Your Curiosity
        http://www.patch.com/words/