Full-text INFLECTIONAL not corresponding people/person

Posted on 2004-04-07
Last Modified: 2006-11-17
I have a full-text indexed table and am able to pull a query using INFLECTIONAL that successfully pairs up louse/lice, mouse/mice. woman,women.  It's not finding person/people, however.  I imagine there's a dictionary lookup table within SQL server where it is simply missing this relationship.  I'm wondering if anyone knows where that table is or how I can find out.

Question by:mwidholm
  • 5
  • 3

Expert Comment

ID: 10778692
A suggestion would be to use profiler to see where it is..

if there is not a query to a dictionary somewhere than I would look for an xml file under the mssql/data/ directory containing words and data for full text searches

Author Comment

ID: 10784449
Thanks jayrod.  I had never used profiler before, so I went in and it seems that where it's referencing the dictionary must be happening in the stored procedure, "sp_fulltext_data" and that's all the detail it's giving me.  Are these stored procedures viewable by sa?  I'm a dbo and I don't see it, but I can ask my boss to take a look.  He's very busy right now, so gaining access to stuff has been a pain.  

I had already looked under mssql/data, but the only xml files I found were 1kb.

Thanks for your help.

Expert Comment

ID: 10784803
I couldn't find it either.. so not sure where to look from here.. I'll keep lookin tho

Author Comment

ID: 10785037
Well, I found "sp_fulltext_getdata" under the extended stored procedures in the master database.  However, I guess we can't see the code on those extended stored procedures and I'm back at square one.  I've been kind of poking at the system tables in the master now to see if any of them seem dictionary-esque.  I'm starting to feel like I'm reverse-engineering to fix a bug, which is probably incredibly impractical.  I'm so curious now though...
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.


Accepted Solution

jayrod earned 500 total points
ID: 10785083
I kind of guessed they may be extended stored procedures... so ya.. kind of hard to fix it or change it

Author Comment

ID: 10785672
I'm new here and don't entirely understand the point system.  While we didn't come to a solution, I appreciate your help tremendously and would like to give you the points- is that ok by the rules?

Expert Comment

ID: 10785701
not sure.. you can ask for a refund of points after a certain amount of time if there aren't any answeres.

I'd leave it open for a while maybe let some others have a chance at giving some helpful information.

Come back in a few days and if no one has either posted some feedback or hints then you can close the question by assigning points or a refund.

either way it's all good :)

Expert Comment

ID: 11053137
Hope you're still subscribed.. I finally found it. The thesaurus used for full text inflectional querying is found in:

c:\program files\microsoft sql server\ftdata\sqlserver\config

the thesaurus is in an xml file there. This is also where all of the noise words are stored.  As of service pack 2 the thesaurus option was implemented but disabled.

I found this data from sql Server 2k unleashed.

hope that helps ya..

although I just looked in that directory and I couldn't make heads or tails of the xml file. :P

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to base a filter depending on fields contents? 15 49
TSQL previous 5 25
Sql Query Datatype 2 19
ms sql last 8 weeks as columns 5 28
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now