<p>What is the best full text search alternative to Microsoft SQL?  (which works with MS SQL)</p>

<p>I'm looking for something similar to <a href="http://lucene.apache.org/java/docs/index.html" rel="nofollow noreferrer">Lucene</a> and <a href="http://incubator.apache.org/lucene.net/" rel="nofollow noreferrer">Lucene.NET</a> but without the .NET and Java requirements. I would also like to find a solution that is usable in commercial applications.</p>

[{'answer_id': 38826, 'author': 'aku', 'author_id': 1196, 'author_profile': 'https://Stackoverflow.com/users/1196', 'pm_score': 2, 'selected': False, 'text': '<p><a href="http://www.sphinxsearch.com" rel="nofollow noreferrer">Sphinx</a> is one of the best solutions. It\'s written in C++ and has amazing performance.</p>\n'}, {'answer_id': 38836, 'author': 'Till', 'author_id': 2859, 'author_profile': 'https://Stackoverflow.com/users/2859', 'pm_score': 0, 'selected': False, 'text': '<p>I second Sphinx, but <a href="http://lucene.apache.org/" rel="nofollow noreferrer">Lucene</a> is also not so bad despite the Java. :) If you are not dealing with too much data spread out etc., then also look into MySQL\'s <a href="http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html" rel="nofollow noreferrer">FULLTEXT</a>. We are using it to search across a 20 GB database.</p>\n'}, {'answer_id': 38844, 'author': 'Jim McKeeth', 'author_id': 255, 'author_profile': 'https://Stackoverflow.com/users/255', 'pm_score': 1, 'selected': False, 'text': '<p><a href="http://www.dtsearch.com/" rel="nofollow noreferrer">DT Search</a> is hands down the best search tool I have used.  They have a number of solutions available.  Their Engine will run on Native Win32, Linux or .NET.  It will index pretty much every kind of document you might have (Excel, PDF, Word, etc.)  I did some benchmarks comparisons a while ago and it was the easiest to use and had the best performance.  </p>\n'}, {'answer_id': 49780, 'author': 'Alan', 'author_id': 2958, 'author_profile': 'https://Stackoverflow.com/users/2958', 'pm_score': 3, 'selected': True, 'text': '<p>Take a look at <a href="http://clucene.wiki.sourceforge.net/" rel="nofollow noreferrer">CLucene</a> - It\'s a well maintained C++ port of java Lucene. It\'s currently licenced under LGPL and we use it in our commercial application.</p>\n\n<p>Performance is incredible, however you do have to get your head around some of the strange API conventions.</p>\n'}, {'answer_id': 149435, 'author': 'Mauricio Scheffer', 'author_id': 21239, 'author_profile': 'https://Stackoverflow.com/users/21239', 'pm_score': 1, 'selected': False, 'text': '<p><a href="http://lucene.apache.org/solr/" rel="nofollow noreferrer">Solr</a> is based on Lucene, but accessible via HTTP, so it can be used from any platform.</p>\n'}]
['https://Stackoverflow.com/questions/38822', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/3153/']