<p>Besides full-text indexing and using LIKE keyword, what are other tools to build search  functionality on top of MS SQL? This question is particularly for searching records, not files.</p>

[{'answer_id': 79563, 'author': 'jimg', 'author_id': 2621, 'author_profile': 'https://Stackoverflow.com/users/2621', 'pm_score': 2, 'selected': False, 'text': '<p>2008\'s <a href="http://technet.microsoft.com/en-us/library/cc721269.aspx" rel="nofollow noreferrer">full text search capabilities</a> have been improved - perhaps look there first..</p>\n'}, {'answer_id': 79573, 'author': 'Martin08', 'author_id': 8203, 'author_profile': 'https://Stackoverflow.com/users/8203', 'pm_score': 1, 'selected': False, 'text': '<p>I believe MS SQL 2005+ has the capability to search using regular expression. </p>\n\n<p>MSDN has an article about this <a href="http://msdn.microsoft.com/en-us/magazine/cc163473.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/magazine/cc163473.aspx</a>.</p>\n'}, {'answer_id': 79603, 'author': 'Richard McGuire', 'author_id': 5086, 'author_profile': 'https://Stackoverflow.com/users/5086', 'pm_score': 2, 'selected': False, 'text': '<p>In episode 11 of the SO podcast Jeff and Joel discussed full text searching of SQL Server, Joel\'s recommendation was <a href="http://incubator.apache.org/lucene.net/" rel="nofollow noreferrer">Lucene.NET</a>.  You can see their discussion in that episode\'s <a href="https://stackoverflow.fogbugz.com/default.asp?W12621" rel="nofollow noreferrer">transcript</a>, it is about a quarter of the way down the page.</p>\n'}, {'answer_id': 598070, 'author': 'Corey Trager', 'author_id': 9328, 'author_profile': 'https://Stackoverflow.com/users/9328', 'pm_score': 2, 'selected': True, 'text': '<p>I documented how I used Lucene.NET in my ASP.NET application BugTracker.NET here:</p>\n\n<p><a href="http://www.ifdefined.com/blog/post/2009/02/Full-Text-Search-in-ASPNET-using-LuceneNET.aspx" rel="nofollow noreferrer">http://www.ifdefined.com/blog/post/2009/02/Full-Text-Search-in-ASPNET-using-LuceneNET.aspx</a></p>\n'}]
['https://Stackoverflow.com/questions/79536', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/13594/']