Integration of Lucene.Net and SQL Server 2005?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hi,

I am looking for an alternative to the SQL Server Fulltext Engine
since it is just not fast enough and does not offer the sorting I
require. Also, my customer wants a "did you mean google" when "gogle"
was entered feature. From what I have seen all that is possible with
Lucene.Net.

I am planning to export a table of about 3 Million keywords to
Lucene.Net and of course I have to implement a way to keep that index
up to date (a latency of one hour is allowed). Also, I would still
like to initiate searching through stored procs. Ideally a table-value
function with CLR integration would get a list of matching ID's from
Lucene.

I wanted to check if maybe someone has used such approach or heard
about something similar, or if there are general restrictions that
make the success of this approach unlikely.

TIA for any comments,

Regards
DC

.