I have a list of 500K different type of Addresses and Have also List of specific Point names in BD. You want to find out these Point names according to the addresses. But there is a problem, Many Point names are not spelled correctly in the addresses;
like - Wrong Spelled Point Names in a different addresses: Narayangonj, Norayanganj, Nuraiyagonj Right Spelled Point Name in my list: Narayanganj
How should I code it? - If the words of the name of the Point names name match closely or similarly, then it will pick up the estimated or appropriate Point names according to the addresses.