Pattern Matching or Sound Alike

  • Thread starter Thread starter BC
  • Start date Start date
B

BC

Hello All,
I am looking for a function or algorithm to pattern match
addresses.
We have a large listing of addresses. Due to clients not
knowing what their correct street number is or liberally
interpreting it('12345th Street South' could be entered
as '12345 S Street') we have duplicate data. Is there a
way to prevent this by doing a evaluation of the address
using the Before Update preperty?
Even better, is there a address checking utility or
function that references the USPS database?

Thanks in advance.

Brian Clark
 
Thanks Wayne,
I have some wonderful code for the soundex type
algorithms.
Unfortunately they do not work with numbers, only western
style names.

Thanks again,

Brian Clark
 
There are code routines that will convert numbers into their word forms
(i.e. 1200 into one thousand two hundred), if you did this first, will
Soundex work?
 
Back
Top