By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,396 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

FORMSOF Predicate: Need Plural, not Inflectional

P: n/a
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.
Sep 10 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Sep 11 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.