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

226 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
devilled133674(None) 
deviled124112181devi_led
anvilled1236482anvilled
bedevilled1742342bedevilled
bevelled14327792bevelled
cavilled1436732cavilled
defiled124013102defi_led
devalued1335012devalued
develed123611932dev_eled
deviated13311042deviated
devised123712562devi_sed
devolved16325512devolved
dilled84122222d__illed
drilled94711672d_rilled
eviller1056672_eviller
levelled12327442levelled
perilled11410112perilled
rebilled11318052rebilled
refilled12278672refilled
revelled123712732revelled
reviled114417922revi_led
anviled1138953anvi_led
bedeviled1673443bedevi_led
begalled1236023begalled
belled94626183be__lled
beveled133811123bev_eled
beveller13387663beveller
billed94224903__billed
brailled1147193brailled
caviled1348723cavi_led
caviller1337063caviller
ceiled94114953ce_i_led
celled94420323ce__lled
chilled133310933_chilled
deaired9411533deai_red
debited113311623debi_ted
decided124312423deci_ded
decile94619213deci_le_
deciles104417723deci_les
declined123910883declined
decupled1494983decupled
defied115016383defi__ed
defilade13124433defilade
defiladed15143473defiladed
defile105216663defi_le_
defiler113911883defi_ler
defiles114016843defi_les
defined123813823defi_ned
defueled1374513defueled
defuelled1443123defuelled
dehisced1583683dehisced
deiced104214483de_i_ced
deified123112413de_ified
deigned1037503de_igned
deled75326543de___led
delimed11310723deli_med
delisted10310563delisted
delved114112753de__lved
demised113613683demi_sed
demitted12288773demitted
denied84318633deni__ed
denimed1159233deni_med
dentiled1039743dentiled
depicted1437743depicted
depilated1339653depilated
derailed102410403derailed
derided102914253deri_ded
derived123912763deri_ved
desalted1038313desalted
designed1136943designed
desilver12286503desilver
desired9311983desi_red
desisted1039783desisted
detailed10319873detailed
deticked1635693deticked
devalue1136013devalue_
devalues1235853devalues
deveined1336673deveined
developed16124313developed
devested13239133devested
deviate11312713deviate_
deviates12312733deviates
device124512163devi_ce_
devices133212583devi_ces
devil94714733devi_l__
deviling1311812853deviling
devilish1546373devilish
devilkin1642953devilkin
devilling1436703devilling
devilment1547713devilment
devilries1345253devilries
devilry1433973devi_lry
devils104412813devi_l_s
deviltry1542983deviltry
devilwood17121783devilwood
devise104215753devi_se_
devisee113812713devi_see
devisees12358283devisees
deviser114212393devi_ser
devises114116763devi_ses
devoiced15276063devoiced
devolve14316063devolve_
devolves15286263devolves
devoted124111093dev_oted
devoured1335723devoured
dewooled1333833dewooled
dezinced2183903dezinced
dialed84716453d__ialed
dialled9510133d_ialled
dirled84514903d__irled
distilled1147173distilled
divided13378593divi_ded
divined12329693divi_ned
divulged1442963divulged
divulsed1343883divulsed
doiled84817293d_oi_led
dolled83518073d__olled
dowelled1356343dowelled
driller84311883d_riller
driveled1374973driveled
drivelled1443983drivelled
drolled93810223d_rolled
duelled9359753d_uelled
dulled84719423d__ulled
dwelled12337593d_welled
enisled82510223_enisled
evicted1337243_evicted
eviler94811893_evi_ler
evillest1146353_evillest
evilly1236593_evill_y
evinced1335403_evinced
evited104013143_evi_ted
evolved14305583_evolved
evulsed1133963_evulsed
exiled144712463_exi_led
felled103720303fe__lled
filled104922263__filled
frilled113911603_frilled
gavelled13387363gavelled
gelled84718893ge__lled
gilled84521633__gilled
grilled94012833_grilled
heiled104415613he_i_led
helled104024703he__lled
hilled104022223__hilled
hovelled15146843hovelled
jelled144916063je__lled
jewelled1934333jewelled
killed113918773__killed
kvelled15276063_kvelled
leveled114010383lev_eled
leveller11317593leveller
levied104111433levi__ed
medalled1246893medalled
melled95023023me__lled
metalled1148983metalled
milled94326173__milled
nilled73919453__nilled
pedalled1246933pedalled
pedicled1436463pedicled
pencilled1445643pencilled
periled10316323peri_led
petalled1138703petalled
petioled1137993petioled
pilled94222753__pilled
prebilled1445063prebilled
prefilled1535513prefilled
prilled104713003_prilled
quilled17329283_quilled
ravelled12419783ravelled
rebelled113110323rebelled
recalled11310803recalled
redialed10310793redialed
redialled1145883redialled
redrilled1145353redrilled
refelled122810163refelled
refiled114318653refi_led
refilmed14235813refilmed
regilded1135543regilded
reoiled84316853reoi_led
repelled113111583repelled
repolled11359623repolled
rerolled93010053rerolled
resiled84621983resi_led
retiled84420513reti_led
retitled9339553retitled
revalued1237023revalued
revealed123211213revealed
reveille1145333reveille_
reveilles1245203reveilles
reveled113917753rev_eled
reveller112912183reveller
reviewed1534823reviewed
revile94921613revi_le_
reviler104314973revi_ler
reviles104421353revi_les
revised113815483revi_sed
revived144211653revi_ved
revolted12319863revolted
revolved15328103revolved
revulsed1235443revulsed
rilled74525653__rilled
rivalled1236093rivalled
sepalled1156903sepalled
shilled113313623_shilled
shrilled1246863shrilled
skilled123110863_skilled
spilled103613623_spilled
stilled83314783_stilled
swilled113611833_swilled
thrilled1235493thrilled
tilled74722953__tilled
trilled84116313_trilled
twilled11398033_twilled
unbilled1188693unbilled
unfilled1298383unfilled
unmilled1197853unmilled
untilled9710563untilled
unwilled1277823unwilled
veiled103714543ve_i_led
vialed105112593__vialed
vialled1156843__vialled
weeviled1533143weevi_led
welled103820213we__lled
willed104722453__willed
yelled104116253ye__lled

Search took 10 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 Limit1461622269.32615672.5
3Display Results2262260.0802825.0
 (SQL Overall)1786912269.82918180.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.