I have 5 mapping tables that I am using as part of a Fuzzy style matching algorithm. I first checks Telephone number to match the name of the agency and then Name, then address etc
The apply map function is very dense and I don't think the coding is best practice.