- 1. Search a database with SOUNDEX
- / Databases /
- ... PROCEDURE [usp_GenerateSearchbySoundexQuery] ( @p_SearchString VARCHAR(max), @p_TableSchema VARCHAR(max) ) AS /***************************************************************************************************************** ** ...
- Created on 11 October 2012
- 2. T-SQL example of Case-Sensitive Soundex
- / Transact-SQL /
- What? This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular ...
- Created on 10 October 2012
- 3. Improve Default Joomla Search
- / Joomla /
- ... priority to articles where the search term is in the article title. In the stages thereafter, I'm going to simply enhance the relevance factor: Soundex: Built-in function to list matches that sound ...
- Created on 07 May 2013
- 4. Search a database for a string (MySQL, T-SQL)
- / Databases /
- ... You can put a distinct on it (not forgetting the collate). This example is expanded in a further article called "Search a database with soundex": /* USING A CURSOR */ DECLARE @SqlToExecute nvarchar(max); DECLARE ...
- Created on 08 October 2012
- 5. PHP & MySQL Search Engine
- / Personal Home Page /
- ... Note: for some systems you can do a levenshtein on two words soundex value and compare these. // Be warned that it does go off track though in terms of relevance... Sources: iamcal.com Nadeau ...
- Created on 09 March 2011