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

Tip: Looking for answers? Try searching our database.

Retrieving words found in text

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Burt_B - 30 Jun 2008 19:12 GMT
Hi,

Is there a way to get a list (programmatically) of the words that SQL Server
expands a user’s search word to for inflectional search?

Example:
1.    User searches “run”
2.    Inflectional search finds a document with the word “ran” (different tense)
3.    I want to display the word that was actual found, i.e. “ran”

Is it possible to have SQL Server tell me that “run” expands to “ran”, etc?  

Also, but of less importance, is it possible to have SQL Server tell me what
word was found in a document?

Example:
Text being searched over: “The quick brown fox…”
Search query: “quick OR slow”
Is there a way to have SQL Server tell me that “quick” was found in a given
text record?

I haven’t been able to find anything about this on the internet.  Thanks a
bunch!
Hilary Cotter - 30 Jun 2008 20:30 GMT
Not in SQL 7, 2000, or 2005. In SQL Server 2008 there is the
sys.dm_fts_parser which will show you how words are stemmed.

> Hi,
>
[quoted text clipped - 24 lines]
> I haven’t been able to find anything about this on the internet.  Thanks a
> bunch!
 
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.