I need to match the most likely combination of two queries where query1 has [LASTNAME, FIRSTNAME] and [last4ofSSN] query2 has [LASTNAME, FIRSTNAME, MI] and [FULLSSN].

Annoyingly last 4 of SSN can duplicate and names do not match exactly between the two queries.