String Comparator with Percentage?

Hey guys.

I'm having quite a mess with lots of data and some of them are almost the same things just in another word assambley

I was wondering if a function for an idea like :

Col A string : "Hey, here is alex"
Col B string : " Hey, alex is here "

2 Percentages to be displayed? Like all the words are there , meaning 100% word match, but the position of them is strange so would be like 80% ?
like =testequal(ColA string, ColB string) and the results would be (W : 100% , S :80%) (w from words, S from phrase?)

The most common string comparators are just character-by-character comparisons (see Levenshtein distance). I think the reason you are not getting responses is that you want artificial intelligence/language processing. That's a tall order for Excel/VBA.

It would certainly be possible to compare two strings to see what percentage of the words match, but as the strings get longer such a number becomes more meaningless. For example,

I had a cup of coffee instead of a full breakfast.
I had a full breakfast with a cup of coffee instead of juice.

High score on word matches but they have totally different meanings.

The best approach depends on what is the nature of the phrases you are going to compare.

Also, I am not seeing how you are calculating 80%.

Originally Posted by alexgoaga

..."Hey, here is alex" ... / ... " Hey, alex is here "
... 100% word match, but the position of them is strange so would be like 80% ?
... the results would be (W : 100% , S :80%) (w from words, S from phrase?)

... "S :80%" ... "S from phrase" ...
Not a phrase, but the position of words in a sentence/phrase, as yourself you wrote above ... and is not 80%, but 50% to 50% => 50% of words have the same position and 50% different: "Hey xxx is xxx".