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 for “evade” with Change Limit: [1] [2] [3]

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

55 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
evade93818(None) 
evaded1137061evaded
evader1036811evader
evades1039021evades
bade75140882_bade
blade85923332blade
cade76443912_cade
clade85821012clade
decade104216162decade
ease45042332e_ase
eave75733582e_ave
eaved95924502eaved
egad64215412egad_
egads74610922egads
eide55832242e_ide
elate55335882elate
elide64922642elide
elude64517622elude
emyde1136382emyde
enate54428152enate
epode85114092epode
erase54925492erase
erode64520992erode
etape74413702etape
etude63612302etude
evaders1136932evaders
eve66331162ev__e
evite85317682evite
evoke12478852evoke
exude134010292exude
fade85736342_fade
glade75121962glade
grade75126092grade
hade85440192_hade
hexade17438902hexade
invade10157852invade
irade65618152irade
jade125325442_jade
lade56345982_lade
made75440242_made
ovate84214392ovate
pervade1337022pervade
pesade9311102pesade
remade94316982remade
sade55544472_sade
shade95125582shade
spade84423322spade
stade64825302stade
trade65026042trade
tsade64311122tsade
vale74937342_vale
vane75534692_vane
vase75629652_vase
vide85432762_vide
wade85237062_wade

Search took 2 seconds 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 Filter178691538000.300595636.7
2DLD Change Limit53800551.48336277.8
3Display Results55550.0163437.5
 (SQL Overall)178691551.79999328.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.