jason2li
Member
I am trying to write a search script for my company's website.  I know how to search using the basics, like:
	
	
	
	
	
	
	
	
	
		
			
			
			
			
			
		
	
	
	
		
	
	
		
	
and such, but I would like to implement some sort of "did-you-mean" feature, similar to Google.
So, if a user misspells something, it will return to them the best possible match.
I have written a VB.NET script that can do this for me, but it's not as fast as I'd like. Is there something within SQL that can handle this? Or do I need to build up a "misspelling" table in the database and continuously add to that?
Thanks in advance!
	
		
			
		
		
	
				
			
			
				VB.NET:
			
		
		
		SELECT * FROM myTable WHERE myColumn LIKE '%what%ever%';So, if a user misspells something, it will return to them the best possible match.
I have written a VB.NET script that can do this for me, but it's not as fast as I'd like. Is there something within SQL that can handle this? Or do I need to build up a "misspelling" table in the database and continuously add to that?
Thanks in advance!
 
	 
 
		 
 
		