Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / July 2004

Tip: Looking for answers? Try searching our database.

FORMSOF(INFLECTIONAL,"god")="dog", ... "golf"="flog" !

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Eric - 11 Jun 2004 12:41 GMT
Hi

In the advanced full-text query of Transact-SQL searching,
linguistic generation terms exist to give inflectional
forms of nouns amd verbs
eg    WHERE CONTAINS(' FORMSOF (INFLECTIONAL, skate) ' )
This matches values that contain words such
as "skate," "skates," "skated," and "skating."

Sorry about cross-posting,
but I think it's the same T-SQL engine beneath all
Windows & IIS - Indexing Service
    http://tinyurl.com/yrqv6
SPS
    http://tinyurl.com/2g8yw
Exchange
    http://tinyurl.com/259wb
SQL Server
    http://tinyurl.com/33p2q

I seem to remember reading that it does
inflections of verbs
inflections of nouns
but inputting nouns won't generally find related verbs,
and looking for nouns won't find verbs.
Is that true ?

However, I have noticed that it will jump from
"golf" to "flog"
and
"dog" to "god"
so perhaps it also does anagrammatic forms ?
Is this 'behaviour by design' ?

Has anyone else noticed other strange examples ?

Thanks !

Eric
John Kane - 11 Jun 2004 16:15 GMT
Eric,
Yes, you are correct the same basic MS Search Technology is used in all
three of the Microsoft products you've referenced. However, there can be
significant difference in the actual versions as well as the functionality
supported via each product. As your questions seems to relate only to the
SQL Server version of "full-text query of Transact-SQL searching" the best
place to discuss this is in the fulltext newsgroup, however, I've cc'ed the
other newsgroups, for any additional input from those products...

Could you post the full output of the following SQL script as this is very
helpful (especially the OS platform info) in troubleshooting and
understanding your environment.

use <your_database_name>
go
SELECT @@language
SELECT @@version
EXEC sp_help_fulltext_catalogs
EXEC sp_help_fulltext_tables
EXEC sp_help_fulltext_columns
EXEC sp_help <your_FT-enabled_table_name_here>
sp_configure 'default full-text language'
go

Q. "... but inputting nouns won't generally find related verbs, and looking
for nouns won't find verbs. Is that true ?"
A. Generally,this is true, but I'd need more info, specifically the language
of your text as well as the column's "Language for Word Breaker" setting to
be sure. The above SQL script will provide that info.

Q. "so perhaps it also does anagrammatic forms ?" & "Is this 'behavior by
design' ?"
A. I've not specifically tested these words in a SQL Server 2000 on Win2K or
Win2003, but depending upon the OS platform, you may see different results
as these platforms each have different wordbreaker dll's - Win2K's
infosoft.dll vs. Win2003's langwrbk.dll. Is this by design? That would
depend upon the OS Platform supplied US_English wordbreaker's default
behavior for these words.

Q. "Has anyone else noticed other strange examples ?"
A. Yes, especially with FORMSOF(INFLECTIONAL) of certain words - proper
nouns such as "hydrocylone" or "sealant" in one case and in another case the
word "best" generated Error Msg 7619: "A clause of the query contained only
ignored words" with 'formsof (inflectional, best)', even though "best" or
"better" are not consider US_English noise words as well as "liked" and
"made" with FORMSOF(INFLECTIONAL).

FYI, Microsoft is aware of this issue and has acknowledged it as a "DOC bug"
sometime ago and hopefully it will be documented in a KB article or in
future releases of either the BOL or in the future releases of SQL Server
2005 (Yukon). However, I don't know the current status of this at this time.

Regards,
John

> Hi
>
[quoted text clipped - 15 lines]
> SQL Server
> http://tinyurl.com/33p2q - Searching for Any Form of a Specific Word
(Generation Term) - SQL Server

> I seem to remember reading that it does
> inflections of verbs
[quoted text clipped - 15 lines]
>
> Eric
- 26 Jul 2004 13:16 GMT
Hi John

Thanks for your response.

I'm using Index server.

For the record, it seems that it is just
reversed words and not all anagrams that are found.

eg 'pots' returns hits on 'stop' but not 'post'

It is going to be easy enough to exclude the reversed word
in the SQL command.

Eric
>-----Original Message-----
>Eric,
[quoted text clipped - 32 lines]
>Win2003, but depending upon the OS platform, you may see different results
>as these platforms each have different wordbreaker dll's -
Win2K's
>infosoft.dll vs. Win2003's langwrbk.dll. Is this by design? That would
>depend upon the OS Platform supplied US_English wordbreaker's default
[quoted text clipped - 58 lines]
>
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.