My task consists to find all record with the same address. Here is the biggest problem because, while city and zip code are entered with a drop down list, and so there are no possibilities to got differences, the address is entered manually in an input text.
Some examples:
main avenue, 21
or , worst case: abbreviations:main avanue 21
liberty street, 23
So, it depends how the users inserts the address, but the differences can be minimal and refer to the same address. So how can i compare the differences with a bit a tollerance??liberty st. 23
I hope that someone can help me.
Thanks and sorry for my bad english