views:

243

answers:

4

I need to compare 2 strings and calculate their similarity, to filter down a list of the most similar strings.

Eg. searching for "dog" would return

  1. dog
  2. doggone
  3. bog
  4. fog
  5. foggy

Eg. searching for "crack" would return

  1. crack
  2. wisecrack
  3. rack
  4. jack
  5. quack

I have come across:

Do you know of any more string similarity algorithms?

+1  A: 

The Levenshtein distance is the algorithm I would recommend. It calculates the minimum number of operations you must do to change 1 string into another. The fewer changes means the strings are more similar...

Levenshtein distance is very erratic.

Searching for "dog" gives me:

  1. dog
  2. bog
  3. ago
  4. big
  5. echo
Peter
Levenshtein distance and all its permutations (such as Dam-Lev) work horribly, even QuickSilver outdoes it in the most basic of comparisons. See http://stackoverflow.com/questions/3338889/how-to-find-similar-results-and-sort-by-similarity
Jenko
@Jenko: You say Levenshtein distance works "horribly", but you don't give any criteria for deciding what's good or bad. Considering Levenshtein distance is pretty much the archetypal "string similarity algorithm", you should make your question more specific.
j_random_hacker
@j_random_hacker: Edited your post to show you why. I linked you to the question that contained the same results, why you didn't read that I don't understand.
Jenko
@Jenko: (1) It's not my post. (2) "Erratic" is not a meaningful criterion. I get that you're not happy with the results, but you need to explain precisely what types of similarity you're looking for. And BTW, you would normally set an upper bound on the Lev distance so that only answers 1-3 would be returned in your example.
j_random_hacker
+1  A: 

You could do this:

Foreach string in haystack Do
    offset := -1;
    matchedCharacters := 0;
    Foreach char in needle Do
        offset := PositionInString(string, char, offset+1);
        If offset = -1 Then
            Break;
        End;
        matchedCharacters := matchedCharacters + 1;
    End;
    If matchedCharacters > 0 Then
       // (partial) match found
    End;
End;

With matchedCharacters you can determine the “degree” of the match. If it is equal to the length of needle, all characters in needle are also in string. If you also store the offset of the first matched character, you can also sort the result by the “density” of the matched characters by subtracting the offset of the first matched character from the offset of the last matched character offset; the lower the difference, the more dense the match.

Gumbo
Looks good, but what sort of algorithm is this?
Jenko
@Jenko: What do you mean? The search is linear, so each string in the list of strings is tested.
Gumbo
+2  A: 

It seems you are needing some kind of fuzzy matching. Here is java implementation of some set of similarity metrics http://www.dcs.shef.ac.uk/~sam/stringmetrics.html. Here is more detailed explanation of string metrics http://www.cs.cmu.edu/~wcohen/postscript/ijcai-ws-2003.pdf it depends on how fuzzy and how fast your implementation must be.

Mojo Risin
+1  A: 

If the focus is on performance, I would implement an algorithm based on a trie structure
(works well to find words in a text, or to help correct a word, but in your case you can find quickly all words containing a given word or all but one letter, for instance).

Please follow first the wikipedia link above.Tries is the fastest words sorting method (n words, search s, O(n) to create the trie, O(1) to search s (or if you prefer, if a is the average length, O(an) for the trie and O(s) for the search)).

A fast and easy implementation (to be optimized) of your problem (similar words) consists of

  • Make the trie with the list of words, having all letters indexed front and back (see example below)
  • To search s, iterate from s[0] to find the word in the trie, then s[1] etc...
  • In the trie, if the number of letters found is len(s)-k the word is displayed, where k is the tolerance (1 letter missing, 2...).
  • The algorithm may be extended to the words in the list (see below)

Example, with the words car, vars.

Building the trie (big letter means a word end here, while another may continue). The > is post-index (go forward) and < is pre-index (go backward). In another example we may have to indicate also the starting letter, it is not presented here for clarity.
The < and > in C++ for instance would be Mystruct *previous,*next, meaning from a > c < r, you can go directly from a to c, and reversely, also from a to R.

  1.  c < a < R
  2.  a > c < R
  3.    > v < r < S
  4.  R > a > c
  5.        > v < S
  6.  v < a < r < S
  7.  S > r > a > v

Looking strictly for car the trie gives you access from 1., and you find car (you would have found also everything starting with car, but also anything with car inside - it is not in the example - but vicar for instance would have been found from c > i > v < a < R).

To search while allowing 1-letter wrong/missing tolerance, you iterate from each letter of s, and, count the number of consecutive - or by skipping 1 letter - letters you get from s in the trie.

looking for car,

  • c: searching the trie for c < a and c < r (missing letter in s). To accept a wrong letter in a word w, try to jump at each iteration the wrong letter to see if ar is behind, this is O(w). With two letters, O(w²) etc... but another level of index could be added to the trie to take into account the jump over letters - making the trie complex, and greedy regarding memory.
  • a, then r: same as above, but searching backwards as well

This is just to provide an idea about the principle - the example above may have some glitches (I'll check again tomorrow).

ring0