persian-words-relation-datasource

All Persian Words With Relation

• a comprehensive and structured knowledge base of the apparent and semantic relationship of all Persian words
• more than 50,000 persian words
• more than 86,000 relationship between words
• compute similarity string between words with multiple algorithms

requirement:

SQL Server 2016 and above versions

RelationTypeID 1:Synonyms 2:Opposite

They have also been compared with several related word similarity algorithms https://github.com/tdebatty/java-string-similarity

SELECT        
      Word.PersianWord,
      Word_1.PersianWord AS Word2,
      case 
      when WordRelation.RelationTypeID=1 then 'Synonyms'
      when WordRelation.RelationTypeID=2 then 'Opposite'
      END AS RelationType,
      WordRelation.JaroWinklerSimilarityString,
      WordRelation.JaccardSimilarityString,
      WordRelation.LongestCommonSubsequenceDistanceString,
      WordRelation.LevenshteinSimilarityString
FROM  WordRelation INNER JOIN
      Word ON WordRelation.WordID1 = Word.WordID INNER JOIN
      ord AS Word_1 ON WordRelation.WordID2 = Word_1.WordID

Result:

donate

Bitcoin (BTC): bc1qvuufkhq2hp0exj0ntlqxtjw8u39jp88eyg2kxl

Ethereum (ETH): 0x4F15156F555b5033e679706782f0B1e61Fc8d304