Noise Words in Search Argument  -- HHHEELLLPP!!!

Posted on 2011-10-10
Last Modified: 2012-05-12
I am experiementing with SQL Server 2005 Full Text Search.  The user key in an Organization Name and I'm searching a column.

My problem is the noise words which are eliminated from the index are not eliminated from the search string or criteria - so what the point!!!

For example (using AdventureWorks)
  Select Comments from Production.ProductReview
  where Contains(Comments, ' "worth" AND "heavy"  AND "the"');

This returns no rows (with a noise word warning).  If I have to eliminate the noise words from the user input, then I don't see the point of them!!  They would be usefull if SQL Server eliminated them from the search strings also.

Now if you use a string and the noise words are ONLY at the beginning or the end, it seems to be OK:
  Select Comments from Production.ProductReview
  where Contains(Comments, ' "the the learning curve the, the" ');

This returns a row with a noise word warning.

I'm confused because I thought the purpose of the noise words was to create a better "fuzzy search".  But it seems I have to scan the input string and remove them manually?

Am I missing something?

Thanks in advance!!!
Question by:hefterr
    LVL 75

    Accepted Solution

    >>But it seems I have to scan the input string and remove them manually?<<
    Yes or ignore the error.

    >>Am I missing something?<<
    Not really.
    LVL 1

    Author Comment

    Hi acperkins,
    I discoved for my search needed, the best you can di is either use :

     Select Comments from Production.ProductReview
      where Contains(Comments, ' "the the learning curve the, the" ');

    In this case the precedeing and trailing noise words are ignored in the input (OK).

    Or use
    SELECT Title
    FROM Production.productionReview
    WHERE FREETEXT (Comments,  "the the learning curve the, the");

    In this case a more "fuzzy" search takes place.  An exact match is not needed.

    LVL 1

    Author Closing Comment


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now