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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 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
escalate103932(None) 
escalade1144381escalade
escalated1247301escalated
escalates1148821escalates
escaladed1343422escaladed
escalader1243232escalader
escalades1244402escalades
escalator1145682escalator
escalope1244522escalope
escapade1343302escapade
excavate2045052excavate
osculate101010612osculate
reescalate12123882reescalate
scalade10359262_scalade
scalage103110532_scalage
scalare93311832_scalare
acylate12310533_acylate
alate55340323___alate
carate84734003__carate
dealate83617843_dealate
desolate9411993des_olate
ecarte84313503e_ca_rte
ecaudate1145313e_caudate
eclat7523603e_c_lat_
eclats8313033e_c_lats
egalite8311563e_galite
ejaculate18187163ejaculate
elate55335883e___late
emaciate1248753emaciate
emanate9312473e_manate
emasculate1445553emasculate
emulate9314123e_mulate
enclave1257533enc_lave
endplate1147083endplate
epilate9314283e_pilate
escaladers1342513escaladers
escalating1347083escalating
escalation1248873escalation
escalators1245303escalators
escalatory1544293escalatory
escallop1243193escallop
escalop1144783escal_op
escaloped1443983escaloped
escalopes1344773escalopes
escalops1244673escalops
escapable1544983escapable
escapades1442993escapades
escape103811663esc__ape
escapee113310463esca_pee
escarole1045743escarole
eschalot1346223eschalot_
eschalots1444133eschalots
escheat12410413escheat_
escheated1546273escheated
escheats1346253escheats
escolar946053escola_r
escolars1045343escolars
escuage1035113esc_uage
estate64719763es__tate
estimate10912003estimate
estivate111010003estivate
ethylate1446223ethylate
etiolate849523etiolate
euclase938933euc_lase
evacuate13217303evacuate
evaluate11287793e_valuate
excaudate1943423excaudate
excavated2243893excavated
excavates2144683excavates
exclave1945193exc_lave
exculpate2044833exculpate
isolate7313923is_olate
jaculate172311783jaculate
localite101411543localite
loculate101011403loculate
maculate122815623maculate
malate84624553__malate
mescaline1348943mescaline
oscillate1145473oscillate
osculated1298143osculated
osculates11109393osculates
oxalate1457623_oxalate
palate84226783__palate
peculate122414673peculate
percolate13411163percolate
reescalated14143343reescalated
reescalates13123613reescalates
resalute857413res_alute
rescale93215473rescal__e
reslate73520593res__late
saccate111311763_saccate
salute64418023_s_alute
savate9313783_s_avate
scalable121710233_scalable
scalades11258803_scalades
scalado10276473_scalado
scalages113010253_scalages
scalar83612433_scala_r
scalares103210983_scalares
scalars93711903_scalars
scale74629143_scal__e
scalene9310773_scalene
scutate9310323_scutate
secalose1046963secalose
separate10310783separate
slate55438283_s__late
solate64526073_s_olate
stylate10179773_stylate
sublate9315363_sublate
tesselate944183tesselate
ustulate868323ustulate
vesiculate1547223vesiculate
vicarate1378603vicarate

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621136.64022012.3
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.10925135.9
 
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.