Finding Partial Name Matches in One Column [Closed]

Report
-
I have a list of names (~20,000) in column A, with address info in columns B-D.

Names are stored "LAST, FIRST M" and all exact matches have already been combined. However, some names exist as follows:
Smith, John M
Smith, John
Smith, John Michael

Is there any way I can speed up de-dupe-ing this list? Possibly conditional text that finds partial matches within the same column (or in the cell below).

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!