Stack Overflow
Stack Overflow

Questions tagged [noise-words]

10 questions
5
votes
2 answers

Query SQl Server 2005 Full Text Search noise/stop words

Is it possible to get the list of Full Text Search noise/stop words from SQL Server 2005 by querying the database? I am aware that the noise words are in a text file ~/FTData/noiseEng.txt but this file is not accessible to our application. I've look…
Damien McGivern
  • 3,954
  • 3
  • 27
  • 21
4
votes
2 answers

How to handle noise words (NN) in Full text search

We are using Full-text search to check postcodes and addresses, we have found that NNx, where x is a number, is considered a noise word. We know the issue but can't think of a clean solution, besides checking if the search word contains NN and then…
Kyle Burns
  • 157
  • 2
  • 15
2
votes
1 answer

ANTLR on a noisy data stream

I'm very new in the ANTLR world and I'm trying to figure out how can I use this parsing tool to interpret a set of "noisy" string. What I would like to achieve is the following. let's take for example this phrase : It's 10PM and the Lazy CAT is…
BlackLabrador
  • 201
  • 5
  • 13
2
votes
1 answer

sql server compatibility full text stoplists and noise words

if I am running sql server 2008 in compatibility level 90 (sql 2005) does it use the stoplist in the resource database or does it use ftdata\ENU.txt files??? also if I make my own stoplist in 2008 (using compatibility 100) can I ignore the system…
Paul
2
votes
4 answers

sys.dm_fts_parser sql full text

We having a really hard time to figure out two similar strings given to sys.dm_fts_parser gives different results select * from sys.dm_fts_parser('"0 CAD"', 0, null, 0) seems to think that "0 CAD" is one token (returns 2 token) select * from…
Haroon
  • 1,052
  • 13
  • 28
1
vote
0 answers

ContainsTable: noise/stop word giving no results

Suppose you have the following queries (using PT language): declare @textoPesquisa as nvarchar(200) = 'haiti and florida and à' if(@textoPesquisa is null or @textoPesquisa='') set @textoPesquisa = '*' select * from Noticias n left join…
Luis Abreu
  • 4,008
  • 9
  • 34
  • 63
1
vote
1 answer

ANTLR on a noisy data stream Part 2

Following a very interesing discussion with Bart Kiers on parsing a noisy datastream with ANTLR, I'm ending up with another problem... The aim is still the same : only extracting useful information with the following grammar, VERB :…
BlackLabrador
  • 201
  • 5
  • 13
0
votes
1 answer

containstable ignores noise word 'of' while searching

I am searching in the DB table with containstable. I am searching with text 'center of gravity', but it doesn't return result. If I search with only 'center' or 'gravity', then it returns the result. How can to overcome this situation? select * from…
kkakadiya
  • 61
  • 8
0
votes
0 answers

Sql Server Full text Search - How to remove 'for' from stop list or noise list

In sql server my search text is like 'for her' 'for kids' but this is ignored by the search, is there a way to remove 'for' from the noise list
Arun Prasad E S
  • 9,489
  • 8
  • 74
  • 87
0
votes
1 answer

"Noise word" in indexing services

Can anyone please tell me, what exactly noise word means in indexing services? I am working on windows server indexing services and getting lots of issues. Some questions on it: …
Prashant Khadatkar
  • 200
  • 1
  • 3
  • 18