Re: 'formsof (inflectional, "")'

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 09:15:12 -0400

I've already looked at all of the options (and others) John has suggested.

None of them are really satisfactory. The catalog dump will provide you with
a list of indexed words or tokens (character sequences). You can't back out
linguistically related words from this list. When you use
formsof(inflectional) or FreeText searches the word breakers will modify
your search to include all stems of the word and the word itself.
The cost of running lrtest inline it too expensive, and on top of that it
uses the same word breakers I was hoping to be able to use, so there will be
licensing issues here as well.

Using Word to provide the stemming services is likewise not an option
because of
1) the cost of invoking ole automation and launching Word to provide these
services is expensive.
2) related words are not really going to do the stemming you are looking for
. Nor are any of the other word functions. 

-- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"John Kane" <jt-kane@comcast.net> wrote in message
news:uuvs5vbmEHA.3172@TK2MSFTNGP10.phx.gbl...
> Matt,
> While I'd agree with Hilary in terms of using the wordbreakers directly,
if
> you have access to SQL Server 2005 (codename Yukon), you *might* be able
to
> do something with the new cmd line utilities - lrtest.exe and cidump.exe
> (extracts the contents of a full-text catalog). You may also want to
> investigate the MS Word VBA functions, such as RelatedWordList or other
> similar functions.
>
> Regards,
> John
>
>
>
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:#5vnImbmEHA.3432@TK2MSFTNGP14.phx.gbl...
> > No, there is no supported way of doing this. The unsupported ways, which
> > involved using the word breakers, are a violation of the licensing
> agreement
> > last time I checked.
> >
> > -- 
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> >
> > "SqlJunkies User" <User@-NOSPAM-SqlJunkies.com> wrote in message
> > news:%2302A6YbmEHA.2136@TK2MSFTNGP10.phx.gbl...
> > > I'm writing a full text search website and I'm including a fuzzy
search.
> > Is there a way to retrieve a "word listing" of what sql server is going
to
> > use when I use formsof inflectional.  So when the user types in invoice;
I
> > would get back invoice, invoicing, invoices etc; so I can highlight the
> > possible matches more easily.
> > >
> > > Thank you for any input.
> > >
> > > Matt.
> > >
> > > ---
> > > Posted using Wimdows.net NntpNews Component -
> > >
> > > Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup
engine
> > supports Post Alerts, Ratings, and Searching.
> >
> >
>
>

Relevant Pages

  • RE: Vook up help required
    ... "Ali Noor" wrote: ... "John C" wrote: ... You have ALL invoice numbers in column A, you have some value in column B, ... The coulmn 1 Invoice Numbers has to be macthed with All the Invice Numbers ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Vook up help required
    ... "John C" wrote: ... You have ALL invoice numbers in column A, you have some value in column B, ... The coulmn 1 Invoice Numbers has to be macthed with All the Invice Numbers ... column is equal to 1234 (or whatever cell reference you are using), ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Ignored words problem
    ... sp_MShelpcolumns returns info on the word breaker not ... the collation. ... "John Kane" wrote in message ... > "Hilary Cotter" wrote in message ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Vook up help required
    ... "John C" wrote: ... "Ali Noor" wrote: ... You have ALL invoice numbers in column A, you have some value in column B, ... The coulmn 1 Invoice Numbers has to be macthed with All the Invice Numbers ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Vook up help required
    ... that's not how your original question was posted. ... You have ALL invoice numbers in column A, you have some value in column B, ... The coulmn 1 Invoice Numbers has to be macthed with All the Invice Numbers ... "John C" wrote: ...
    (microsoft.public.excel.worksheet.functions)