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

506 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
drooled936920(None) 
drolled93810221drolled
drooped11368431drooped
broiled103811422broiled
brooded113510932brooded
brooked143610032brooked
broomed124111052broomed
cooled95224592_cooled
crooked143910952crooked
crooned103813352crooned
dewooled1333832dewooled
doiled84817292d_oiled
doled75430912d__oled
dolled83518072d_olled
doodled10369462doodled
doolee73018952d_oolee
doomed104113292d_oomed
drawled12368342drawled
drilled94711672drilled
droller84110282droller
droned84616862dr_oned
drool65416102drool__
droolier936072droolier
drools74412812drool_s
drooly104911072drool_y
droplet10312112droplet
dropped13329292dropped
drouked1335542drouked
droved114611642dr_oved
drowned12419902drowned
drowsed12448752drowsed
fooled104317822_fooled
groomed11379502groomed
grooved12347252grooved
growled12278172growled
pooled94619812_pooled
proofed13138722proofed
prowled13309912prowled
roiled74320052_roiled
rolled74220242_rolled
roofed105214742_roofed
rooked114918142_rooked
roomed95218542_roomed
roosed75621602_roosed
rooted75424002_rooted
rootled83410532_rootled
shooled115212662shooled
snooled84513942snooled
spooled104613522spooled
stooled84313892stooled
tooled74918902_tooled
trolled84312262trolled
trooped104010722trooped
vroomed13366432vroomed
wooled103715502_wooled
arbored103811603arbored
areole61017283areole_
areoles71016953areoles
argled85314553ar_gled
ariled75620323ar_iled
armored102610473armored
aroused84914353aroused
arrowed1148133arrowed
aureoled945743aureoled
bedroomed1543653bedroomed
befooled1434803befooled
blooded11379803blooded
bloomed12439433bloomed
blooped12398543blooped
boiled95020953_boiled
bolled94722653_bolled
boobed114514873_boobed
boodled113410933boodled
booed85127273_boo_ed
booked135319503_booked
boomed115318133_boomed
booted94822733_booted
boozed184813833_boozed
bowled125018143_bowled
brailed103914013brailed
brawled133910123brawled
bridled113611143bridled
broiler92911753broiler
bronzed19308213bronzed
brood84620243broo__d
brooder103811623brooder
brooklet1456403brooklet
browed125216403br_owed
browned134710973browned
browsed134511243browsed
cajoled17428283cajoled
caroled103717693caroled
carolled1138833carolled
carpooled1445073carpooled
coaled95022713_coaled
coiled95123943_coiled
coled85540763__coled
cooed84534343_coo_ed
cooeed95917863_cooeed
cooked135921363_cooked
cooler84824713_cooler
cooped114821613_cooped
cowled125218393_cowled
craaled10339423craaled
cradled113410813cradled
crawled133710403crawled
creeled104012013creeled
creole8913733creole_
creoles9913323creoles
croaked143710543croaked
crocked164014443crocked
crooker134111093crooker
crooner93714043crooner
cropped143812073cropped
crossed105313903crossed
crowded14418803crowded
crowed124717313cr_owed
crowned133912443crowned
dabbled133712073dabbled
daddled113810743daddled
dadoed9449903dado_ed
daggled11329463daggled
dandled103313543dandled
dangled104013153dangled
dappled1336393dappled
dariole8711163dariole_
darioles9710703darioles
darkled13378723darkled
dartled9409853dartled
dawdled13376723dawdled
dazzled1735033dazzled
deboned113411633deboned
decoded123212393decoded
decoyed14358343decoyed
defiled124013103defiled
deled75326543d__eled
demoded123611123demoded
demoed103713443demo_ed
demoted114313543demoted
denoted93512763denoted
deponed113712873deponed
deposed113412033deposed
derailed102410403derailed
detoxed1636103detoxed
develed123611933develed
deviled124112183deviled
devolved16325513devolved
devoted124111093devoted
dhole95215363d_hole_
dholes104914793d_holes
dhoolies1246963dhoolies
dhooly13457143dhool_y
dialed84716453d_ialed
dialled9510133dialled
dibbled133510843dibbled
diddled114212053diddled
dilled84122223d_illed
dimpled132810303dimpled
dindled104412723dindled
dipole91112853dipole_
dipoles101013753dipoles
dirled84514903d_irled
disrooted1147623disrooted
doated84118183d_oated
docked145018333d_ocked
dodged107514693d_odged
doffed14428503d_offed
dogged106017703d_ogged
dogleg936323d_ogleg
dogsled1035193dogsled
doited85016633d_oited
dole56550003d__ole_
doles67843753d__oles
dollied93811143d_ollied
domed95423263d__omed
donned85015743d_onned
doodad936423d_oodad
doodle83212853doodle_
doodler93310153doodler
doodles93614163doodles
doolees83711613d_oolees
doolie73916833d_oolie
doolies83920713d_oolies
dooly94821803d_ool_y
doozer163910463d_oozer
doped95326713d__oped
dosed76626913d__osed
dossed84516633d_ossed
doted75227073d__oted
dotted84717523d_otted
doubled11289953doubled
doused84821163d_oused
dowed104632613d__owed
doweled12269773doweled
downed115314783d_owned
dowsed115015013d_owsed
doyley13487283d_oyley
dozed165619353d__ozed
drabbed13428723drabbed
drabbled14367053drabbled
drafted12439033drafted
dragged11379563dragged
draggled1254673draggled
dragooned1242963dragooned
drained93713253drained
drammed13378073drammed
draped105314363dr_aped
dratted9358593dratted
drawler11338593drawler
drayed115911393dr_ayed
dreaded103612023dreaded
dreamed114310633dreamed
dredged11346893dredged
dreed75222843dr__eed
dressed93511873dressed
dribbed13326753dribbed
dribbled14376593dribbled
driblet103712243driblet
dried75321383dr__ied
drifted12367953drifted
driller84311883driller
dripped13408083dripped
driveled1374973driveled
drizzled18284573drizzled
drogue8938333drogue_
drogues9398393drogues
droid74218543dr_o_id
droll65415403dr_ol_l
drollery12314793drollery
drollest937353drollest
drolls75312393dr_olls
drolly105411673dr_olly
dromond1135473dromond
drone65324983dr_one_
droner74717673dr_oner
drones75023433dr_ones
drooliest1036343drooliest
drooling102610423drooling
droop85814823droo__p
droopier1145573droopier
droops95110963droo_ps
droopy12458243droo_py
drophead1544613drophead
droplets1136063droplets
dropper12329873dropper
dropsied1234973dropsied
drosses84513823drosses
drove95518063dr_ove_
drover104614593dr_over
droves105116673dr_oves
drownd11478313dr_ownd
drownded14334433drownded
drowner11369803drowner
drowse105010553drowse_
drowses114610233drowses
drubbed13406983drubbed
drudged11277613drudged
drugged11367183drugged
drumbled14266033drumbled
drummed13306323drummed
dueled84813663d_ueled
duelled9359753duelled
dulled84719423d_ulled
dwelled12337593dwelled
enrolled967973enrolled
enrooted977433enrooted
eroded84313593er_oded
flooded12307933flooded
floored11268683floored
foaled104515963_foaled
foiled104618403_foiled
footed104418623_footed
footled113610763footled
foozled20346893foozled
fouled104315973_fouled
fowled133914103_fowled
frilled113911603frilled
frivoled1534043frivoled
frocked17439333frocked
frogged13408493frogged
froglet11310063froglet
fronded12388863fronded
fronted114011273fronted
frosted113211883frosted
frothed14288783frothed
frowned14348833frowned
gadrooned1243403gadrooned
gaoled84814503_gaoled
gloomed11337413gloomed
goaled85014363_goaled
goofed114911383_goofed
goosed86817033_goosed
grilled94012833grilled
groaned9259973groaned
groined92710813groined
grokked1233673grokked
groomer10399873groomer
groove10438873groove_
groover11358543groover
grooves11368803grooves
groped107515063gr_oped
grossed93812263grossed
grouped11419193grouped
groused94712843groused
grouted94111503grouted
groved114413703gr_oved
groveled13345453groveled
growler11318973growler
grueled937133grueled
holed95634133__holed
hooded114616743_hooded
hoofed134614893_hoofed
hooked145320553_hooked
hooped125518183_hooped
hooted104422663_hooted
hooved134713123_hooved
howled134014973_howled
ironed74916013ir_oned
jowled174210803_jowled
knolled12296573knolled
kraaled12254983kraaled
lolled74315823_lolled
looed64626133_loo_ed
looked114717073_looked
loomed94616763_loomed
looped95217173_looped
loosed75520893_loosed
looted74421113_looted
marooned1138563marooned
mobled113213183_mobled
moiled94318863_moiled
mooed85123983_moo_ed
mooley11311633_mooley
mooned94216643_mooned
moored93814173_moored
mooted94120373_mooted
noodled9339923noodled
noosed75018023_noosed
ogled75915963__ogled
oiled64429473__oiled
oohed94214213__oohed
oozed154214263__oozed
oriole6814293oriole_
orioles7412993orioles
paroled104217633paroled
peopled1238513peopled
poled84934843__poled
polled94022003_polled
pooed85226243_poo_ed
poohed123912523_poohed
pooler83819843_pooler
pooped113915943_pooped
precooled1446363precooled
prilled104713003prilled
probed114114823pr_obed
problem1335983problem
proceed12310553proceed
prodded1257733prodded
profiled14338523profiled
progged12409803progged
prole74527793pr_ole_
proleg94612113pr_oleg
proles84627203pr_oles
prologed12189213prologed
promoed12310083promoed
promoted13310543promoted
pronged113912393pronged
proofer12149103proofer
proponed132412043proponed
proposed132011083proposed
propped113311963propped
prosed94921103pr_osed
proved125016033pr_oved
provoked1875053provoked
prowler123310013prowler
railed74727543_railed
reeled74725533_reeled
reoiled84316853reoiled
repled93319783_repled
rerolled93010063rerolled
reroofed1235883reroofed
resoled84119283resoled
retooled938473retooled
rifled104115003_rifled
riled65833253_r_iled
rilled74525653_rilled
rioted73416373_rioted
roamed95215093_roamed
roared75015393_roared
robbed113415193_robbed
robed85323733_r_obed
roble75223023_roble_
robles85321693_robles
rocked135022323_rocked
rodded93713703_rodded
rogued84711473_rogued
role45851823_r_ole_
roles56747983_r_oles
rolfed104510523_rolfed
roller63919793_roller
romped114513653_romped
rood56733003_roo__d
roofer94415283_roofer
roomer84718633_roomer
roose56127093_roose_
rooser63921883_rooser
rooses65526243_rooses
roosted83211893_roosted
rooter64926033_rooter
rootle63214453_rootle_
rootles73215633_rootles
rootlet73015733_rootlet
roped84630813_r_oped
rosed65930353_r_osed
rotted74524433_rotted
rouged86717323_rouged
rouped95717353_rouped
roused75426453_roused
routed75624333_routed
roved95323553_r_oved
rowed94034323_r_owed
roweled11269863_roweled
ruled65822523_r_uled
schooled1447053schooled
scooped124611753scooped
scooted103612283scooted
scowled13398193scowled
scrolled1137063scrolled
scrooped1356413scrooped
shoaled113810973shoaled
shooed103916083shoo_ed
skoaled12226063skoaled
snooded94110363snooded
snooked123711493snooked
snooped103711813snooped
snooted84213283snooted
snoozed173410133snoozed
snoozled18344493snoozled
soiled73822473_soiled
soled65835173__soled
soloed74515743_soloed
sooted73922593_sooted
souled75419823_souled
spoiled104811353spoiled
spoofed13399103spoofed
spooked144510473spooked
spooler93711383spooler
spooned103412443spooned
spoored104411293spoored
stoled74521593_stoled
stooged94310733stooged
stooked124312303stooked
stooped103813833stooped
strolled937823strolled
swooned11368593swooned
swooped13418753swooped
tholed105113873_tholed
toiled74420323_toiled
toled65934923__toled
tolled73819033_tolled
tooler63818613_tooler
tooted74620123_tooted
tootled83511043tootled
trailed83415673trailed
trawled113411523trawled
trebled1038483trebled
trifled113711963trifled
trilled84116313trilled
triolet73219523triolet
tripled104113833tripled
troaked12438253troaked
trocked144312243trocked
troked114114583tr_oked
troller73913173troller
trolley10328753trolley
trollied935903trollied
tromped124210293tromped
trooper94210363trooper
trothed114010973trothed
trotted83711283trotted
troubled1134983troubled
trouped103910983trouped
trowed104714653tr_owed
troweled12106113troweled
uncooled112710633uncooled
unoiled82415483unoiled
unrolled9610413unrolled
unroofed12106773unroofed
unrooted9810513unrooted
uprooted1186393uprooted
varoomed1445293varoomed
voled95323723__voled
whoofed17374513whoofed
whooped16326933whooped
whorled14366903whorled
wooded114213683_wooded
wooed94419873_woo_ed
woofed134511203_woofed
woolen93111373_woolen
wooler93615873_wooler
woolled1136643woolled
wronged12397673wronged
yodled11389653_yodled
yowled133811093_yowled
zoomed183610363_zoomed
zooned164011083_zooned

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 Filter1786911340270.406440125.6
2DLD Change Limit1340275066.83019623.3
3Display Results5065060.1862720.4
 (SQL Overall)1786915067.42224075.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.