This will be tricky to explain so I hope people understand. I need to find approximate matches between two sets of data.
For example I have a customer on one system called McCarthy and the details are entered by hand onto another system and could end up as McArthy, MacCarthy etc. How would it be possible to find all approximate matches to the original in the second data set???