Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Inflectional forms

 
   Database Help (Home) -> Full Text RSS
Next:  GoSub Errors  
Author Message
ruben

External


Since: Dec 30, 2008
Posts: 1



(Msg. 1) Posted: Tue Dec 30, 2008 6:26 pm
Post subject: Inflectional forms
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)

Hi,

I´m working on my university senior project about a Search Engine and I
´m using SQL08 Full-Text.
I´m trying to get all the inflectional forms for all words for an
improvement.
Using this:

SELECT * FROM sys.dm_fts_parser(N'FORMSOF(INFLECTIONAL, "foot")',
1033, null, 1);

I get all the forms, but I need to know the word "foot" and this is a
dynamic function.
Is there any way to know the TABLE where are stored all the
inflectional words?

Thanks.

Ruben.

 >> Stay informed about: Inflectional forms 
Back to top
Login to vote
Hilary Cotter

External


Since: Jan 16, 2008
Posts: 143



(Msg. 2) Posted: Wed Dec 31, 2008 4:31 am
Post subject: RE: Inflectional forms [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I take it you mean how does sql fts know how to stem words, so foot returns
foot and feet.

Basically these are hard coded in the word breakers and you can't dig into
the dll to find the stems. Most of the stemming is done according to language
rules. Have a look at morphems to understand the technology behind it.

"ruben" wrote:

> Hi,
>
> I´m working on my university senior project about a Search Engine and I
> ´m using SQL08 Full-Text.
> I´m trying to get all the inflectional forms for all words for an
> improvement.
> Using this:
>
> SELECT * FROM sys.dm_fts_parser(N'FORMSOF(INFLECTIONAL, "foot")',
> 1033, null, 1);
>
> I get all the forms, but I need to know the word "foot" and this is a
> dynamic function.
> Is there any way to know the TABLE where are stored all the
> inflectional words?
>
> Thanks.
>
> Ruben.
>

 >> Stay informed about: Inflectional forms 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
'FORMSOF (INFLECTIONAL,.....Full text search..help - Hello I want to write stored procedure,which will use FormsOF Inflectional, BUT I am getting error,actually I dont know how to pass parameter in the Inflectional query. here it goes.... USE [charlotte] GO /****** Object: StoredProcedure..

Returning word forms? - Microsoft SQL Server 2000 - 8.00.818 (Intel X86) <font color=purple> ; May 31 2003 16:08:15 </font> <font color=purple> ; Copyright (c) 1988-2003 Microsoft Corporation</font> <font color=purple> ; S...

funny search results with 'contains' clause - hi, it is really funny how ft search works: it seems to depend highly on what could be indexed, but it still doesn't follow a determined order. consider the following queries: select name from person where contains(name, 'hammer') select name from..

Insert Into Without Log - Hi, Can I create an Insert Into Query without sql server registration log? Thx.

SQL 2K : custom word breaker ? - Hi, Is it possible to create a custom word breaker for SQLServer fulltext.... I use french word breaker, but for some specific tables, it's not exactly what I want... Seems such a dream will be feasible in SQL 2K5. Please anyone who knows, tell me the....
   Database Help (Home) -> Full Text All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]