My case is
Input is "abdknmgbm".
The record in database that i want to query out is "abkdnmgmb"
The input and database record is quite similar.
String length is same, only some arrangement of character are not same.
In the above case, dk and kd ; bm and mb.
How i write query for this string searching?
Help and Thanks.

Recommended Answers

Read this thread for some more information.

Jump to Post

Are you using MSSQL too ?

Jump to Post

All 6 Replies

Tq... But i am using with c#.

In addition, i cannot use SOUNDEX. Because my record is not the english vocabulary.

Have a look at the full-text search capabilities of MS SQL Server.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.