ASP.NET Building Search, looking at Lucene.NET -

I'm looking for a search that has this basic search function

• Quick text Spell checker with search and maybe "Did you mean ..."
• Mask.

  So I'm looking at Lucene.net. Or just general full text indexing

  My database size is approximately 8000 companies records. Just thinking that HASTLE's are worth NAK LIGHT or I will just create a spell checker and mask search at the top of the usual SQL indexed search.

  We use Lucene within our ecommerce platform and we are 100% satisfied with it. Before we used to use a search functionality which simply used to query the database and this solution proved unacceptable for many reasons:

  1. It is not so fast, so we Can not imagine the kind of functionality of "Google Instant Search" (which we implemented after migrating into a Lucene based solution)

  2. Once the user becomes more complex (such as applying / filtering multiple search criteria), it becomes quite difficult to keep the response time relatively small (and the size of SQL and The complexity was raised very high).

  3. We have our own (or re-existing) ranking algorithms so that what the user can actually do with the search result "mail".

     I am not saying that database-based approach is always bad for such things (most likely it is just a bad design).

     Besides, I always keep this famous phrase in mind: "Never underestimate the importance of fasting importance". You may have 8k records yet but you are not sure how your system will evolve over time. In a year, your customers will demand more advanced functionality than just free-text search + Your database will increase to millions of records before you think about designing your search infrastructure because otherwise you have to type it out completely.

     PS Here is an example of using the spell checker for Lucene.