sql function to compare 2 strings for possible matches

Need sql function to compare 2 strings of names to determine if they match. See the examples below. The below set is a Match Str1 Str2 John Doe John Doe John, Doe John Doe John Doe John, Doe John Doe Doe John John L Doe John Doe Doe John John L Doe Doe L. John John L Doe Doe L. John John L. Doe Jr. Doe L John John L. Doe Jr. Doe L John John L. Doe Doe John John Lee Doe Doe Lee John John L Doe Doe Lee John John Doe John Doe Sarah Doe and John Doe John Doe Sarah Doe & John Doe Doe John R John R Doe Doe John R John Ray Doe Doe John Ray John R Doe The below set is NOT a match Jay Taft John Doe Doe L John John R. Doe Sarah R Doe John R Doe Sarah R Doe John R Doe