I have a datatable in sql server 2005 containing words in spanish. Given a char array, I would like to find all the words which contains those characters, no mather in wich order they appear. For example, "avi" shoul match "avion" and also "iva". Is it possible?
Thanks for your attention.