Enabling Fuzzy Search in C# .NET

[@anuraj.p]

Interestng. Two things I learned, 1) Soundex SQL statement 2) How to use DbFunction attribute. Thank you Hassan.

[@yunietpiloto4425]

Same here

[@mohammedelsuissey1745]

This video is saved to my library for years to come, plz don't remove it anytime soon

[@aweklin]

My co-developers need to see this. So helpful. Have seen it many times on Bing but haven't had a requirement in any of my project yet. Thanks for this hint. Hoping to see more of these hidden capabilities more often.

[@ahmadkelany]

I have been using SQL Server almost daily for the past several years.. It amazes me that there is much cool and useful things and hidden gems like this that I have never heard before! Thanks for the amazing content, please keep it up and show us more hidden treasures 💐💐

[@emmanueladebiyi2109]

Great video here Hassan! Short and highly informative

[@alegntayeyilma9564]

Great! as per your last comment, i checked the documentation for postgresql and it has the exact same function. Besides there is an additional function difference(text, text) return int that measures the similarity (not the difference) between two text.

[@minimalist_zero]

Second time i have learned from this channel, subscribed!

[@Dragonet17]

Very usefull topic. Simple and amazing solution. Thanks !

[@TheZigsDk]

First person I ever hit the bell for. Literal gold.

[@ahmedanwer1767]

It will be great if you make a series about hidden gems of SQL or in particular SQL Server

[@tedchirvasiu]

Haw yousefool, thenk u HoShawn!

[@minddropcast]

Very very good explanation. I liked!

[@microtech2448]

Seems good to have this function. Can you please demonstrate full text search as elastic search may do. Thank you for this video.

[@HassanHabib]

Will do!

[@carldaniel6510]

SOUNDEX can be useful, but it's a very crude "fuzzy search": It only looks at the first word of whatever is passed to it, and only the first few characters of that and gives good results only with English words. If you have a relatively short list of single words in English, it's not bad. For searching larger documents or multi-word phrases, it's almost useless. For better results, search for information on metaphone, double metaphone, metaphone 3, Levenshtein distance, Jaro-Winkler similarity, TfIdf ("term frequency, inverse document frequency) for starters.

[@FebriantoSetiawan]

add Damerau-Levenshtein

[@carlosalmeida2847]

@carldaniel6510 indeed, I was making some tests now with the SOUNDEX function (btw Hassan great tip totally unknown for me before watching the video), and indeed in my case is not working as I'm trying to match some codes and a lot of matches are found since the codes always starts with PP and then some 8 chars after that. I tried also work with the FuzzyString c# library that uses Levenshtein, Jaccard, Jaro-Winkler and others, but the problem is that the FuzzyString.ComparisonMetrics.ApproximatelyEquals cannot be directly translated to a linq to ef query. Anyone able to use some of those algos with EF*

[@JtendraShahani]

Awesome. I am new to .NET and C#. Can you please put such videos in a playlist. In case you already did that, then can you please share the link. Thank you so much. Your efforts are very helpful to me.

[@OlimjonovOtabek]

Soo understandable thank you teacher Hassan Habib

[@ThugLifeModafocah]

This is awesome... thank you. Your content is really good.

[@fieryscorpion]

Wow, just learned something new today!

[@talkathiriify]

Excellent. Thank you very much Hassan.

[@herberthsu1495]

so helpful 🙏 thanks for sharing this content

[@ahmedanwer1767]

Very informative 👏 and plz make more videos like this

[@CRBarchager]

Awesome video. Never knew about this feature!

[@ahmed.adel3]

Amazing as usual 👌

[@mohamadhelaly4979]

Thanx alooooooooot. You are awesome bro

[@IBNEKAYESH]

Really is that exist? I never knew this keyword before. [Subscribed]

[@CodeMonarch]

Superb, thanks for sharing.

[@shawn301287]

Crazy!! Thank You again mate..

[@SyrousW]

Very useful.👍

[@yeasinarafat2290]

Didn't know about the cool stuff!

[@AskFiqri]

Lovely. Thanks for this.

[@panagakis79]

Great tip Hassan thank you! Can Soundex be applied with other languages?

[@HassanHabib]

If these languages can leverage ef or have their own mechanism

[@mykhailokonontsev3132]

Great video, thanks

[@sommmen]

Any notes on performance and indexes and such?

[@orafasistemas]

Nice!!!.... thank you!

[@FebriantoSetiawan]

Elasticsearch is way more scalable and popular

[@AthensDotNet]

Thank you

[@akshay_zz]

Subscribed.

[@tea_otomo]

Love the idea ... still it's a capability of Sql Server, not C# .NET, ... for us folks who work with other DBs sadly useless :/

[@HassanHabib]

Yeah I had to mention that at the end - there might be other alternatives out there. Big question on performance and reliability.

[@ahmadkelany]

Is there a function like SOUNDX that works with Arabic data? I tried using SOUNDX with Arabic names data but it doesn't work.. Is there an alternative approach?

[@HassanHabib]

Hum, that's a good question. SOUNDEX relies on vowels which may or may not exist in other language. Certainly not in Arabic. Some guy a while back wrote something to map vowels - check this out: www.codeproject.com/articles/26880/arabic-soundex

[@ahmadkelany]

@@HassanHabib Thanks very much, I will check it out.

[@yaKaiZen]

🙏

[@tidianediallo6199]

great!

[@KubilayBayraktar]

Good one. But the thing is, it is not working for sentences.

[@SergeyGorin]

The video title is deceiving, since it's about an SQL Server function, not about a .Net feature

[@Kingside88]

Great explanation, bad title. its not in C# but more in Entity Framework in combination with SQL Server.

[@mbpoblet]

The title is quite misleading... this is about SQL Server and Entity Framework, not about C#...

[@محمدأحمد-ه5ه5ن]

Thank you