Welcome!   Search Scrabble┬« Dictionary using DLD   Statistics   Compare any two Strings using DLD   Reference   Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search forgamp” with Change Limit: [1] [2]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

21 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
gamp9883321(None) 
amp77541021_amp
camp106336441camp
damp96228841damp
gam67060061gam_
gama77035511gama
gamb96331821gamb
game76644311game
gamps105323711gamps
gams76648881gams
gamy105427531gamy
gap67055611ga_p
gasp76227331gasp
gawp107618621gawp
gimp96124041gimp
gramp106218321gramp
lamp86233821lamp
ramp85933991ramp
samp85733581samp
tamp86133001tamp
vamp115521541vamp

Search took 1 second overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691139830.0602978183.3
2DLD Change Limit13983210.25355268.8
3Display Results21210.0037000.0
 (SQL Overall)178691210.316565477.8