• Since you are on SQL 2012, I wonder if something in the new Data Quality Services stack can do what you need. No idea about that personally.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service