Hi,
First you may have to fine tune data with Fuzzy grouping (if you are using SSIS).
You ma refer to nice article available at :
SSIS-Fuzzy lookup for cleaning dirty data[
^]
Once your data is fine tuned, you can easily take the distinct data from your column/ table.
Thanks,
Baliram Suryawanshi