Ho to Compare two almost similar String

Question

Below is two columns from two table which is almost identical . How can i compare these strings so i get 

Status as True.

Answer 1

Hi, I hope below link will resolve the string compare https://www.w3resource.com/mysql/string-functions/mysql-strcmp-function.php#:~:text=MySQL%20strcmp()%20function%20is,is%20smaller%20the%20first%20one.&text=First%20string%20for%20comparison.&text=Second%20string%20for%20comparison.

Answer 2

In your example status is always false; when should it be true and how would you define "similar" here?

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 3

Hi olaf, All are similar. It is coming as False in my query

Answer 4

There is Microsoft supplied database that implements several great CLR functions including RegEX and string comparison algorithms, but I forgot the name of it right now and could not find doing Google Searches, can someone please refresh my memory?

I was able to find this

https://igormicev.com/regex-in-sql-server-for-searching-texts/

but this is not what I was searching for.

Also found this one

https://www.sqlsharp.com/features/

which is quite interesting and may help (not the one I was searching for).

Also found this interesting approach https://www.red-gate.com/simple-talk/sql/t-sql-programming/fuzzy-searches-sql-server/

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

My TechNet articles

Answer 5

Ok, several more searches and I figured out the name of the MS supplied DB mdq and found this article

https://www.decisivedata.net/blog/cleaning-messy-data-sql-part-1-fuzzy-matching-names

but so far I didn't find the link to download the database itself yet.

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

My TechNet articles

Answer 6

hi

can show insert statements of above data storage columns

Thanks and Regards

Laxmidhar sahoo

Answer 7

Hi Saritask,

If you can provide when it is true and when it is false, it is helpful to solve the problem.
You can consider writing a function to judge the similarity. The following example may be helpful to you

CREATE FUNCTION strcompare 
(@StrColumnA AS VARCHAR(255) , 
@StrColumnB AS VARCHAR(255)) 
RETURNS INT 
AS 
BEGIN 
DECLARE @Result INT 
DECLARE @lenA INT 
DECLARE @lenB INT 
DECLARE @lenSameA INT 
DECLARE @lenSameB INT 
SET @lenA=LEN(@StrColumnA) 
SET @lenB=LEN(@StrColumnB) 
--Calculate the number of characters in A that exist in B
SELECT @lenSameA=COUNT(*) 
FROM test 
WHERE @StrColumnB LIKE '%'+StrColumnA+'%' 
--Count the number of characters in B that exist in A
SELECT @lenSameB=COUNT(*) 
FROM test
WHERE @StrColumnA LIKE '%'+StrColumnB+'%' 
SET @Result=(@lenSameA+@lenSameB)*100/(@lenA+@lenB) 
RETURN @Result 
END

 

Best Regards, 
Echo 

------------------------------

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 8

Hi olaf, All are similar. It is coming as False in my query

And how does your query look like?

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 9

Hi Saritask,
Has your problem been solved? If it is solved, please mark the point that you 
think is correct as an answer. This can help others who encounter similar problems.

Best Regards
Echo

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]