Index and Match Employee ID

Hi,

I have a master key with the list of employees full name in (last name, first name Middle) format and their corresponding ID's.

I also have a list with employee first and last name only that I use to retrieve their employee ID's.

The problem is their first and last name don't necessary match the word for word of their first and last name. It doesn't include any middle names.

Is there a way to look up these ID's if they closely resemble the master key?

I've attached the excel workbook with sample employee details.

Is it possible to merge the last name and first name and compare word for word and if it contains at most 90% of the letters then return the employee ID?