Linq best match option

Question

i would like to know how i can find the best match word in the database using Linq

for example ->

user ask for "playtation" and linq returns "playstation, playstation 4, playstation 3"

Could you show us what code you are using, or even what you have tried? — alstonp, Aug 16 '14 at 20:11
check out full-text search in SQL Server http://msdn.microsoft.com/en-us/library/ms142571.aspx — Isantipov, Aug 16 '14 at 20:13
Duplicate of [how to recognize similar words with difference in spelling](http://stackoverflow.com/questions/3091257/how-to-recognize-similar-words-with-difference-in-spelling) — user1477388, Aug 16 '14 at 20:25
http://stackoverflow.com/questions/5299996/find-sql-records-containing-similar-strings — Tim Schmelter, Aug 16 '14 at 20:25

score -1 · Answer 1 · answered Aug 16 '14 at 21:17

-1

var query = from item in source
            where item.StartWith("playstation")
            return item;

foreach(var q in query)
      Console.WriteLine(q);

answered Aug 16 '14 at 21:17

Marek Woźniak

1,766
16
34

Linq best match option

1 Answers1