Sorting Through Tables with Mismatched Names

I think I am off the track a bit, I have the following example (notice the similarity in spelling of the names but I can't get any fuzzy functions to work as I need):

And I want to see the following results:

Thank you all.