I'm looking to take the functionality of LIKE pattern matching, i.e.
SELECT fieldname FROM table WHERE field LIKE '%foo%'
and return identical hits using full-text search. Unfortunately, full-text search in SQL Server does not allow the use of leading wildcards, so I'm looking for alternatives.
Has anyone used Lucene (http://lucene.apache.org/java/docs/index.html
) or any other full-text search applications with SQL Server?