Communication is over rated when you work with Klingons....

True, but others reading through a forum might be looking for ideas on how to tackle problems like this.

I would use Fuzzy Matching in SSIS. Throw everything to temp table. Remove your direct matches and then fuzzy matching the rest. Sorry can't give more...