Perhaps this reading would be useful here:

http://databases.about.com/od/specificproducts/a/normalization.htm

2nd normal form is what you need to solve the problem.

All the name variations must be removed to a separate table.