Comparing List Of Names In Different Formats

I am constantly given the task of comparing to list of names that come from different sources. One source(SourceA) provides the names in a two Cols as first name and last name. Luckily Source A usually just has first and last name list but sometimes they have a third name or middle initial included and it could be in the first Col or the second no real pattern. The second source(SourceB) provides their list as a single Col and it has every given name for the person including suffixes and prefixes. A couple of examples of Source B names would be-"John Henry David" or "Dr. Billy Bob Adams Barone Beard IV".

I have spent countless hours and days probably weeks on some list as there are anywhere between 20-50,000 names per list I am sent. I am hoping there is a better solution to compare these names. As of right now the only thing I can do right now is manually trim the data from SourceB down to a format like "John David" and "Billy Beard" and then combining the Cols from Source A into the same format and then comparing them.