Proper Nouns

Hi All,
We are using a FORMSOF(INFLECTIONAL) query and trying to establish why we
get results returned for a search on "Luke" but no results for "Lukes"?
Whereas "Rebuke" and "Rebukes" returns the same number of results.
Is there a dictionary or similar that we can add to to ensure that plural
forms of proper nouns are treated as any other plural?
Thanks all, and regards,
Fin_D
Fin_D,
Could you post the full output of -- SELECT @.@.version -- as this is very
helpful in troubleshooting SQL FTS issues. Specifically, the OS Platform
(Win2K, WinXP, or Win2003) provides the wordbreaker dll that affect the
results from such as SQL FTS query. On Windows Server 2003 (Win2003), for
the proper noun / name "Luke" will return:
IWordFormSink::PutAltWord: cwc 4, 'Luke'
IWordFormSink::PutWord: cwc 6, 'Luke's'
but not Lukes as the proper name Luke is not the same as Lukes, i.e.. Luke
!= Lukes.
As for a dictionary of proper names, there are several that are on the
Internet (for example, "Quick Lookup - Dictionary and Reference Tool" -
http://www.trancreative.com/quicklookup.aspx?page=dicts), that you can
download and import into a SQL table to further refine your search's input.
However, a quick search via Google
(http://www.google.com/search?&q=dict...+luke+%2Blukes) turns up few
results for "Lukes" vs. "Luke's".
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Fin D" <findarato@.hotmail.com> wrote in message
news:86038C53-58F6-443A-9CF4-B3873EBEADF1@.microsoft.com...
> Hi All,
> We are using a FORMSOF(INFLECTIONAL) query and trying to establish why we
> get results returned for a search on "Luke" but no results for "Lukes"?
> Whereas "Rebuke" and "Rebukes" returns the same number of results.
> Is there a dictionary or similar that we can add to to ensure that plural
> forms of proper nouns are treated as any other plural?
> Thanks all, and regards,
> --
> Fin_D
|||John,
Thanks, we have enough information from your post. Much appreciated
Fin_D.
"John Kane" wrote:

> Fin_D,
> Could you post the full output of -- SELECT @.@.version -- as this is very
> helpful in troubleshooting SQL FTS issues. Specifically, the OS Platform
> (Win2K, WinXP, or Win2003) provides the wordbreaker dll that affect the
> results from such as SQL FTS query. On Windows Server 2003 (Win2003), for
> the proper noun / name "Luke" will return:
> IWordFormSink::PutAltWord: cwc 4, 'Luke'
> IWordFormSink::PutWord: cwc 6, 'Luke's'
> but not Lukes as the proper name Luke is not the same as Lukes, i.e.. Luke
> != Lukes.
> As for a dictionary of proper names, there are several that are on the
> Internet (for example, "Quick Lookup - Dictionary and Reference Tool" -
> http://www.trancreative.com/quicklookup.aspx?page=dicts), that you can
> download and import into a SQL table to further refine your search's input.
> However, a quick search via Google
> (http://www.google.com/search?&q=dict...+luke+%2Blukes) turns up few
> results for "Lukes" vs. "Luke's".
> Regards,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Fin D" <findarato@.hotmail.com> wrote in message
> news:86038C53-58F6-443A-9CF4-B3873EBEADF1@.microsoft.com...
>
>