Hi,

Don't know if anyone has come across something like this before or not. Here goes. I have a long list of words in a column (e.g. Random, Randomize, Randomized, Randomise, Randomised). What I want to do is get to the root of the word and count them. The perfect answer would be Random* = 4.

I have though of creating a sequence from each word and checking it against all other words in the list for partial matches. For example the word random can be thought of as:

R*
Ra*
Ran*
Rand*
Rando*
Random*

The first five permutations are not actual words but vba won't recognize this. Aside from creating my own database of words, is there a way to check if the term is actually a word in the English dictionary online or not?

abousetta