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 forpane” 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.

31 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
pane6495027(None) 
ane37866941_ane
bane65250421bane
cane66653111cane
fane75343561fane
gane55145291gane
jane115031471jane
kane85133961kane
lane45153301lane
mane65051981mane
pace86345741pace
page76036091page
pale66054971pale
pan58466441pan_
paned85437171paned
panel76023601panel
panes76148651panes
pang75336281pang
panne76623631panne
pans65855701pans
pant66061241pant
pare66760821pare
pase65346861pase
pate65350451pate
pave96133891pave
pine67755671pine
plane74929071plane
pone65747511pone
sane45954331sane
vane75534681vane
wane76344711wane

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.0563190910.7
2DLD Change Limit13983310.23360012.9
3Display Results31310.0065166.7
 (SQL Overall)178691310.295605732.2