Hi all,

I need something stronger than LIKE or CONTAINS, but not so
comprehensive as the FORMSOF(Field, INFLECTIONAL).

I am looking to see which words from one list also exist in another.
However, this is related to reading comprehension. Therefore I need to
see "dog" and "dogs" as a match. However, I don't want to see "run"
and "ran" as a match.

Is there anything like FORMSOF(field, PLURAL). Or, any way to modify
the behafior of these commands?

Thanks in advance.

SOUNDEX (and/or DIFFERENCE) is something to consider, but I don't
think it will help you with plurals, unless you do something to
convert plurals to singular equivalents??

Mouse and Mice could match on SoundEx. But there are a lot of plural
forms that might not match correctly with SOUNDEX.

Here's another option to consider (managed code):
http://www.dba-sql-server.com/sql_se..._xp_regexp.htm


-Eric Isaacs