Re: Where can I find a list of word breakers?

Single character words are treated as noise by default so something like
j@xxxxxxx would first be broken into "j foo com" (since @ and . are both
breaking characters), of these only foo and com would be indexed.

So only foo com was indexed but when you query for j@xxxxxxx you should
still find a match since query and index time noiseword behaviour should be
the same.

Can you reproduce it? If so I can take a look and try to explain it.


--
Dave Poole
SQL Server Fulltext Team

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.



"Jim Sneeringer" <JimSneeringer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6C685B68-03E0-46C6-B244-99533E2F9DC8@xxxxxxxxxxxxxxxx
> After further testing, I think @ is a word breaker. Apparently something
> else
> in my first test caused me to think it wasn't.
>
> Maybe it has to do with noise words. The search that filed was for an
> e-mail
> address with only one letter (the letter "j") in front of the @. When I
> put
> some other e-mail addresses in and searched for them, it found them just
> fine.
>
> Could it be that noise words must be removed from the query, or the result
> is not found. In other words, did SQL possibly ignore teh "j" in the
> database, but not ignore the "j" in the query?
>
> Or maybe there is some other anomoly that caused that e-mail address not
> to
> be found.


.

Relevant Pages

  • Re: Ignored words problem
    ... both freetext and freetexttable can also generate error "A ... clause of the query contained only ignored words". ... >> avoid it either via removing noise words from the specific language ... >> 9952 This is sample text data for Scootney Books, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Ignored words problem
    ... I agree that the "A clause of the query contained only ignored ... been a pain ever since SQL 7.0 Beta3 was shipped in 1998 and once SQL Server ... sp_configure 'transform noise words' - so you can turn off this check in SQL ... database and searching on 'book' will not return rows that contain 'books': ...
    (microsoft.public.sqlserver.fulltext)
  • Re: noise words, @@ERROR, and stop and resume indexing
    ... double quotes unless it resolves to nothing in which case ... It's not the noise words I have a problem with, ... to make the UDF infallible but as good as I think I've got ... if this query causes an ignored-word error ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Where can I find a list of word breakers?
    ... exec sp_configure 'transtransform noise words', ... Searching for j@xxxxxxx will only hit documents which have foo ... SQL Server Fulltext Team ... Both the query and the database text ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Help on Ignored Words in Full Text Query
    ... via either client-side or server-side solutions. ... SearchPage.htm for server-side and client-side solution ... of removing the noise words before issuing a SQL FTS query. ...
    (microsoft.public.sqlserver.fulltext)
Loading