VBA

The threshold is a percentage of the number of words that they must have in common. It is based on the total number of words in the first tweet. This threshold value is fixed at 0.7 for this assignment. This means that at least 70% of the words must be the same. So, if the first tweet has 100 words, at least 70 of those words must be in common with the second tweet for isDup to be True. If it is less than 70 words like 56 or 34 then the tweet is not deemed a duplicate. Note: the threshold is passed in as a parameter and should not be hardcoded in VBA as 0.7