Re: 'formsof (inflectional, "")'

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Kane (jt-kane_at_comcast.net)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 09:52:34 -0700

Matt,
Hilary, keep in mind what Matt asked for - "Is there a way to retrieve a
"word listing" of what sql server is going to use when I use formsof
inflectional", and while I did offer suggestions beyond your reply of "No,
there is no supported way of doing this" and I did not offer any "
unsupported ways" and while the methods I offered may or may not perform
well, they are at least positive & supported (for SQL 2005) methods for
achieving Matt's request.

Cidump does offer a "word listing", and lrtest does provide a means to
getting the "formsof inflectional" words and Matt should be the best judge
of whether or not lrtest would be performant enough for him as it does offer
the functionality that he has requested, IMHO.

Best regards,
John

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:ONpvG1lmEHA.1152@TK2MSFTNGP11.phx.gbl...
> 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: Monitoring windows directories
    ... Matt, if you can program in .Net, use FileSystemWatcher component to ... capture new or modified events. ... > update a table in the SQL server which will hold properties for each file. ... > The reason for this is because the files hold references to each other and I ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Operating system error 10038., An operation was attempted on something that is not a socket.
    ... Dejan Sarka, SQL Server MVP ... Solid Quality Learning ... "Matt" wrote in message ... > Operating system error 10038., An operation was attempted on something ...
    (microsoft.public.sqlserver.server)
  • Re: Audit a Table
    ... I think there may be a second vendor which can do this as well, ... Wayne Snyder, MCDBA, SQL Server MVP ... community of SQL Server professionals. ... "matt" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: Port security question
    ... Matt writes: ... I'm setting up a VPN now. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Prev by Date: ...
    (comp.databases.ms-sqlserver)