Similar name checker

[Lauren279]

I am after a function to be able to find in a list of names for a similar name already in the list or maybe there is a typo in the name

For example
List of names (in column A)
1. James earl jones
2. Jack black
3. John smoth
4. Harrison ford
5. John smith
6. Earl jones james
7. Jock black
8. Smith John
9. Sarah Jessica Parker
10. Jane Parker

(In column B) Check function
1. True (because of 1 and 6, same name just in different positions)
2. True (because of 2 and 7, name similar but typo)
3. True (because of 3, 5 and 8, name in different position in text string and typo)
4. False (nothing in the list is the same)
5. True (see 3)
6. True (see 1)
7. True (see 2)
8. True (see 3)
9. False (even though 10 says Parker there is no Jane in 9 so it isn’t matching)
10. False (see 9 however vice versa)

Side note: I don’t need the (brackets) as part of the function it is just to show the result of why true or false I just need the true false result, the brackets is to explain why they are showing up as true or false within the example

Also if it helps the text will be in all in capitals (upper) , not lower case or proper

Thank you in advance for any help - also I am unable to download or have any add-in’s for the function and if it makes a difference, needs to be for windows 10

 

[sleek12]

Fuzzy lookup

 

[Lauren279]

Fuzzy lookup

Thank you, I am however unable to download any add-ins, is there something else I can use