Detecting Duplicate Values In Single Cell From Multiple Values List?

[an_otter]

If the title isn't clear, here's what [little] I've got so far:

=IF(LOWER(A2)<>SUBSTITUTE(LOWER(A2),LOWER(H2),"",2),"Yes","No")

Which, of course, looks for the H2 ("carwash") value in A2, and if it finds it's been duplicated ("carwash go to the carwash", as an example) it'll Yay or Nay me. The issue is, though, is I need it to look for multiple values for this duplication, or better yet, any duplicated values.

Any ideas?

[olasa]

One option is to use =LEN(SUBSTITUTE(...)) and compare how much then length change.

[an_otter]

The list of values this will be pawing through will be far too abstract to come to a definitive list of substitutable words, sadly, and it's not that I'm looking for duplicates across the list, just within their own cells.