similarity of two text in power bi (fuzzy lookup or cosine similarity) based on text column

[Anonymous]

 have a table , which has two columns id and text. This is what data i have:

id   text
765   hi how are you
876   John made $57.
743  apple is my favourite fruit.
435   mango is not my favorite fruit.
892.  this is my favourite movie

I have input column as slicer,in which i can choose any one id.for eg: 743

-765
-876
-**743**
-435
-892

I need the output, in which it would show the id ,text, similarity score of the selected id from slicer with all the other ids:

id   text                              score
743  apple is my favourite fruit.        1
765   hi how are you                   0.93
876   John made $57.                    0.80
435   mango is not my favorite fruit.    0.70
892.  this is my favourite movie         0.54

[Anonymous]

based on number of words in text matching.

[Anonymous]

its not a formulae, but a measure of how two strings are similar.

[v-yanjiang-msft]

Hi @Anonymous ,

According to your description, I think the main problem is to calculate the score. Is the value of score you provided correct after calculating? I'm not very clear about the logic of similarity, would you like to give an example about how you get 0.93 when the id is 765.

Best Regards,
Community Support Team _ kalyj