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 / April 2008

Tip: Looking for answers? Try searching our database.

International English FTS would be very desirable...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brian - 31 Mar 2008 06:32 GMT
Many of my customers have sites in both the US and UK or Australia/New
Zealand.
Thus, when one location searches for "colour", it would be really nice if
they also found things with "color".
That could be handled with a Thesaurus entry.

But some things would be better handled with an extended definition of the
INFLECTIONAL functionality.
For example, a search on "dream" finding both "dreamed" and "dreamt" would
be good.
And if that was done, then you wouldn't need thesaurus entries between
"dreamed" and "dreamt".

Is it possible to extend the INFLECTIONAL rules this way?
Hilary Cotter - 02 Apr 2008 01:08 GMT
This is best handled with custom word breakers. Note the international
English word breakers evidently know about *tion =*xion and other British
Spellings.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Many of my customers have sites in both the US and UK or Australia/New
> Zealand.
[quoted text clipped - 10 lines]
>
> Is it possible to extend the INFLECTIONAL rules this way?
Brian - 05 Apr 2008 06:03 GMT
> This is best handled with custom word breakers. Note the international
> English word breakers evidently know about *tion =*xion and other British
> Spellings.

Are you saying that if I use International English word breakers that it
will stem both *tion and *xion?
Would it stem both colour and color to the same set of words?

Are there third-party Word Breakers / Stemmers available that might do such
things?

Or would I need to write it myself?

Thanks for the clarification,

   Brian
Hilary Cotter - 08 Apr 2008 13:10 GMT
This is an answer I got on the question on the difference between US and UK
(International English) from one of the main search developers several years
ago.

Neither XXXX or I are aware of any significant differences between the two.
I think there may be some ISE/IZE differences in the lexicons.

Microsoft purchased the original word breaker product from InfoSoft so they
may not be aware of all the idiosyncrasies of it.

What I think this means is that if you search on exercize (UK English) it
knows to stem it as exercizing, exercized, as opposed to doing matching with
exercise.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>> This is best handled with custom word breakers. Note the international
>> English word breakers evidently know about *tion =*xion and other British
[quoted text clipped - 12 lines]
>
>    Brian
 
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



©2009 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.