Options for simple but essential search in .net Server application -

Options for simple but essential search in .net Server application -

i have .net server based application, needs able total text 'fuzzy' search of single db column only. underlying db engine sql server 2008 r2.

the info column write once (never modified), , expected under 'load' there 10 new strings beingness added per minute.

the strings capped @ 1000 characters. in western languages, planned add together others in future.

the consuming client pass search term (most space separated keywords) server, homecoming list of matching records client.

the 'complicated' part of misspellings , similar words need catered for.

it feels if rolling own using doublemetaphone work, require development effort.

so i'm wondering if people think of existing search 'apps' out there may suitable? (lucene.net example). or if overkill such little search requirement.

i utilize sql server full-text search. it's powerful, adjustable, supports linguistic features of different languages , on.

i think should start this: http://msdn.microsoft.com/en-us/library/ms142571(v=sql.105).aspx

very general steps apply application be:

install full-text search component sql server installation.

create , adjust full-text index in database.

define search query necessary predicates.

integrate application!

.net search fuzzy-search