I am investigating the best way to analyse some very messy employer name data (Free Text Field in an application). Each employer might have 100's of different variations when it comes to spelling, abbreviations and even language.
What is the best and most accurate way to solve this issue and what tool will work the best? I am currently using Base SAS, but I don't think this has the capability to do what I require.