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 “dieseled” 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.

120 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
dieseled103552(None) 
desexed1636182d_esexed
develed123611932d_eveled
diesel74410402diesel__
dieselized2143482dieselized
diesels8429142diesel_s
hirseled12106252hirseled
tinseled935762tinseled
aisled74516183ai_s_led
beveled133811133_beveled
chiseled1435883chiseled
creeled104012013cre_eled
creneled11326893creneled
deeded94615543d_e_eded
deemed104713063d_e_emed
deepened1235663deepened
defiled124013103d_efiled
defueled1374513defueled
deled75326543d___eled
deleted93314913d_eleted
desalted1038313d_esalted
deselect1147523d_eselect
deserted101012203d_eserted
deserved13108133d_eserved
desexes1537833d_esexes
desired9311983d_esired
deviled124112183d_eviled
diademed1344153diademed
dialed84716453di__aled
dialled9510133di_alled
diapered1238003diapered
dibbled133510843di_bbled
dickered16117533dickered
diddled114212053di_ddled
diereses938693diereses
dieseling1146143dieseling
dieselize1943973dieselize
dieselizes2043943dieselizes
dieses75218693dies__es
diester83013683dies_ter
dieted83115493di__eted
differed1635523differed
digested11208163diges_ted
dilled84122223di__lled
dimpled132810303di_mpled
dindled104412723di_ndled
dirled84514903di__rled
disabled1248713disabled
disced104914653di_s_ced
discoed11312483di_scoed
diseased103011713diseased
dished114318713di_s_hed
dishelmed1645093dishelmed
disheveled1842863disheveled
disked125015763di_s_ked
dispelled13117573dispelled
dissaved1337313dissaved
disseated11711083disseated
dissected13108663dissected
dissed85220183di_s_sed
disseised1147863disseised
disseized2046323disseized
dissembled1644413dissembled
dissented1199723dissented
disserted11109813disserted
disserved14107003disserved
dissever12107653dissever
dissolved1445593dissolved
disused93211033di_sused
dithered13189293dithered
divested13268213dives_ted
dizened18267333di_zened
dogsled1035193dogs_led
doweled12269773d_oweled
dressed93511873dres_sed
driveled1374973driveled
dueled84813663d__ueled
duelled9359753due_lled
dwelled12337593dwe_lled
dyeweed1543203dyewe_ed
easeled8159863_easeled
hanseled1237713hanseled
heeled104018413_he_eled
hirselled1344693hirselled
hirsled11118113hirs_led
houseled1237283houseled
isled64615993_i_s_led
jeweled1845333_jeweled
keeled114414273_ke_eled
kneeled12328073kne_eled
leveled114010383_leveled
libeled10249413li_beled
linseed838203linse_ed
misled94719313mi_s_led
mispled12310463mi_spled
morseled1147193morseled
nestled8349913_nestled
nickeled15115513nickeled
oilseed835783oilse_ed
peeled94119713_pe_eled
pestled102711453_pestled
reeled74725533_re_eled
resealed92713973_resealed
reseed74823293_rese_ed
resewed113011823_resewed
resiled84621983_resiled
resoled84119283_resoled
reveled113917753_reveled
seeled73922093_se_eled
speeled103712453spe_eled
steeled83513223ste_eled
tasseled935603tasseled
teaseled9186803teaseled
tinselled1044423tinselled
vesseled1243833vesseled
viseed105310983vi_se_ed
weaseled12175153weaseled
wedeled1237783_wedeled
wheeled14318463whe_eled
wrestled12296763wrestled

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 Limit1461621206.86021306.4
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.32924381.4
 
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.