Hi there, I have a small project where individuals need to submit a survey reply. However, I want to chase people that just copy & paste their replies into the survey or just slightly modify them.
Therefore, I would like to uncover the "similarity %" of text in various rows.
Example:
cell a1: The dog has a long tail.
cell a2: The dog has quite a long tail.
cell a3: The cat has grey eyes.
Affirmation 1 and 2 are very similar although not identical. What suggestions do you have for me to uncover these, as they are not identical but sill too similar to be considered different?
I have a list with around 1000 responses and, I would like to uncover those that are very similar to others.
Thanks for your thoughts on this.
Titus
Bookmarks