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

513 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
drolled9381022(None) 
dolled83518071d_olled
drilled94711671drilled
droller84110281droller
drooled9369201drooled
rolled74220241_rolled
trolled84312261trolled
bolled94722652_bolled
broiled103811422broiled
carolled1138832carolled
dialled9510132dialled
dilled84122222d_illed
doiled84817292d_oiled
doled75430912d_o_led
dollied93811142d_ollied
doodled10369462doodled
drawled12368342drawled
driller84311882driller
droll65415402droll__
drollery12314792drollery
drollest937352drollest
drolls75312392droll_s
drolly105411672droll_y
droned84616862dro_ned
drooped11368432drooped
droplet10312112droplet
dropped13329282dropped
drouked1335542drouked
droved114611642dro_ved
drowned12419902drowned
drowsed12448742drowsed
duelled9359752duelled
dulled84719422d_ulled
dwelled12337592dwelled
enrolled967962enrolled
frilled113911602frilled
grilled94012832grilled
growled12278172growled
knolled12296572knolled
lolled74315822_lolled
polled94022002_polled
prilled104713002prilled
prowled13309912prowled
rerolled93010052rerolled
rilled74525652_rilled
roiled74320052_roiled
rolfed104510522_rolfed
roller63919792_roller
scrolled1137052scrolled
strolled937812strolled
tolled73819032_tolled
trilled84116312trilled
troller73913172troller
trolley10328752trolley
trollied935892trollied
unrolled9610412unrolled
woolled1136642woolled
argled85314553ar_gled
ariled75620323ar_iled
aroused84914343aroused
balled94926893_balled
belled94626183_belled
billed94224903_billed
boiled95020953_boiled
bolted94617803_bolted
boodled113410933boodled
bowled125018143_bowled
brailed103914013brailed
brailled1147193brailled
brawled133910123brawled
bridled113611143bridled
broiler92911753broiler
brollies1039533brollies
brolly114510853broll_y
bronzed19308213bronzed
brooded113510933brooded
brooked143610033brooked
broomed124111053broomed
browed125216393bro_wed
browned134710973browned
browsed134511233browsed
bulled94626493_bulled
called94126733_called
caroled103717693caro_led
caroller1039203caroller
celled94420323_celled
chilled133310933chilled
coaled95022713_coaled
coiled95123943_coiled
coled85540763_co_led
collet84030363_collet
collied103316673_collied
cooled95224593_cooled
cowled125218393_cowled
craaled10339423craaled
cradled113410813cradled
crawled133710403crawled
creeled104012013creeled
croaked143710533croaked
crocked164014433crocked
crooked143910943crooked
crooned103813343crooned
cropped143812063cropped
crossed105313893crossed
crowded14418793crowded
crowed124717303cro_wed
crowned133912433crowned
cruller968753cruller
culled94022473_culled
dabbled133712073dabbled
daddled113810743daddled
daggled11329463daggled
dalles74222063d_alles
dallied93713613dallied
dandled103313543dandled
dangled104013153dangled
dappled1336393dappled
darkled13378723darkled
dartled9409853dartled
dawdled13376723dawdled
dazzled1735033dazzled
defiled124013103defiled
deled75326543d__eled
delved114112753d_elved
derailed102410403derailed
develed123611933develed
deviled124112183deviled
devilled1336743devilled
devolved16325513devolved
dewooled1333833dewooled
dhole95215363dho_le_
dholes104914793dho_les
dialed84716453d_ialed
diallel845683diallel
dialler848813dialler
dibbled133510843dibbled
diddled114212053diddled
dimpled132810303dimpled
dindled104412723dindled
dirled84514903d_irled
doated84118183d_oated
docked145018333d_ocked
dodged107514693d_odged
doffed14428503d_offed
dogged106017703d_ogged
dogleg936323d_ogleg
dogsled1035193dogsled
doited85016633d_oited
dolce85816683d_olce_
dole56550003d_o_le_
doles67843753d_o_les
doll56632493d_oll__
dollar74110983d_ollar
dollies83620983d_ollies
dollop9259363d_ollop
dolloped1234983d_olloped
dolls66126923d_oll_s
dolly96125203d_oll_y
dolmen93911373d_olmen
domed95423263d_o_med
donned85015743d_onned
doodle83212853doodle_
doodler93310153doodler
doodles93614163doodles
doolee73018953d_oolee
doolees83711613doolees
doolie73916833doolie_
doolies83920713doolies
doomed104113293d_oomed
doped95326713d_o_ped
dosed76626913d_o_sed
dossed84516633d_ossed
doted75227073d_o_ted
dotted84717523d_otted
doubled11289953doubled
doused84821163d_oused
dowed104632613d_o_wed
doweled12269773doweled
dowelled1356343dowelled
downed115314783d_owned
dowsed115015013d_owsed
doyley13487283d_oyley
dozed165619353d_o_zed
drabbed13428723drabbed
drabbled14367053drabbled
drafted12439033drafted
dragged11379563dragged
draggled1254673draggled
drained93713253drained
drammed13378073drammed
draped105314363dr_aped
dratted9358593dratted
drawler11338593drawler
drayed115911393dr_ayed
dreaded103612023dreaded
dreamed114310633dreamed
dredged11346893dredged
dreed75222843dr__eed
dressed93511873dressed
dribbed13326753dribbed
dribbled14376593dribbled
driblet103712243driblet
dried75321383dr__ied
drifted12367953drifted
drill64718263drill__
drillers9429723drillers
drills74414203drill_s
dripped13408083dripped
driveled1374973driveled
drivelled1443983drivelled
drizzled18284573drizzled
drogue8938333drogue_
drogues9398393drogues
droid74218543dro__id
drolling103510763drolling
drollness1043623drollness
dromond1135473dromond
drone65324983dro_ne_
droner74717673dro_ner
drones75023433dro_nes
drool65416103drool__
droolier936073droolier
drools74412813drool_s
drooly104911073drool_y
drophead1544613drophead
droplets1136063droplets
dropper12329873dropper
dropsied1234963dropsied
drosses84513823drosses
drove95518063dro_ve_
drover104614593dro_ver
droves105116673dro_ves
drownd11478313dro_wnd
drownded14334433drownded
drowner11369803drowner
drowse105010553drowse_
drowses114610233drowses
drubbed13406983drubbed
drudged11277613drudged
drugged11367183drugged
drumbled14266033drumbled
drummed13306323drummed
dryland1254303dryland
drywalled1741833drywalled
dueled84813663d_ueled
dueller8329833dueller
duller74017703d_uller
dweller11297273dweller
enrollee878343enrollee
enroller867183enroller
eroded84313583ero_ded
evolved14305583evolved
extolled1654303extolled
felled103720303_felled
filled104922263_filled
foaled104515963_foaled
foiled104618403_foiled
folded114212793_folded
folles93820473_folles
fooled104317823_fooled
footled113610763footled
foozled20346893foozled
fouled104315973_fouled
fowled133914103_fowled
friller104111743friller
frivolled1642383frivolled
frocked17439333frocked
frogged13408493frogged
froglet11310063froglet
fronded12388863fronded
fronted114011273fronted
frosted113211873frosted
frothed14288783frothed
frowned14348833frowned
fuelled11369193fuelled
fulled103820653_fulled
galled84622863_galled
gaoled84814503gao_led
gelled84718893_gelled
gilled84521633_gilled
girolle835793girolle_
girolles935523girolles
goaled85014363_goaled
golfed11569763_golfed
grille74315743grille_
griller84513353griller
grilles83715023grilles
groaned9259973groaned
groined92710813groined
grokked1233673grokked
groomed11379503groomed
grooved12347253grooved
groped107515053gro_ped
grossed93812253grossed
grouped11419193grouped
groused94712833groused
grouted94111503grouted
groved114413703gro_ved
groveled13345453groveled
grovelled1454183grovelled
growler11318973growler
grueled937133grueled
gruelled1034893gruelled
gulled84521373_gulled
helled104024703_helled
hilled104022223_hilled
holed95634133_ho_led
holked144913663_holked
hollaed11359853_hollaed
holler93520613_holler
holloed113812753_holloed
howled134014973_howled
hulled103920013_hulled
ironed74916013iro_ned
jelled144916063_jelled
jollied15349273_jollied
jolted143510633_jolted
jowled174210803_jowled
killed113918773_killed
knelled12338993knelled
knoller11285913knoller
kraaled12254983kraaled
kruller1145153kruller
kvelled15276063kvelled
lalled74218753_lalled
logrolled1142533logrolled
loller63315283_loller
lulled74516443_lulled
malled94626113_malled
melled95023023_melled
milled94326173_milled
mobled113213183_mobled
moiled94318863_moiled
molded104414083_molded
molted94217473_molted
mulled94721553_mulled
muralled1136423muralled
nilled73919453_nilled
noodled9339923noodled
nulled74318273_nulled
ogled75915963__ogled
oiled64429473__oiled
outrolled1037433outrolled
palled94625163_palled
paroled104217633paro_led
patrolled1245713patrolled
peopled1238503peopled
perilled11410113perilled
pilled94222753_pilled
poled84934843_po_led
pollee83623273_pollee
pollen83416453_pollen
poller83921853_poller
pollex153711163_pollex
pooled94619813_pooled
probed114114823pro_bed
problem1335983problem
proceed12310553proceed
prodded1257733prodded
profiled14338523profiled
progged12409803progged
prole74527793pro_le_
proleg94612113pro_leg
proles84627203pro_les
prologed12189213prologed
promoed12310083promoed
pronged113912393pronged
proofed13138723proofed
propelled1456913propelled
propped113311953propped
prosed94921093pro_sed
proved125016033pro_ved
prowler123310013prowler
pulled94322193_pulled
quelled17279273quelled
quilled17329283quilled
railed74727543_railed
rallied83514083_rallied
redrilled1145353redrilled
reeled74725533_reeled
relied74926233_relied
reoiled84316853reoiled
repled93319783_repled
repolled11359623repolled
reroller8258753reroller
rifled104115003_rifled
riled65833253_r_iled
rille55728733_rille_
rilles64725503_rilles
rillet64828853_rillet
roamed95215093_roamed
roared75015393_roared
robbed113415193_robbed
robed85323733_ro_bed
roble75223023_roble_
robles85321693_robles
rocked135022323_rocked
rodded93713703_rodded
rogued84711473_rogued
role45851823_ro_le_
roles56747983_ro_les
rolfer94412273_rolfer
roll46331653_roll__
rollers73117473_rollers
rolls55326233_roll_s
romped114513653_romped
roofed105214743_roofed
rooked114918143_rooked
roomed95218543_roomed
roosed75621593_roosed
rooted75424003_rooted
rootled83410533rootled
roped84630803_ro_ped
rosed65930343_ro_sed
rotted74524433_rotted
rouged86717323_rouged
rouped95717353_rouped
roused75426443_roused
routed75624333_routed
roved95323553_ro_ved
rowed94034323_ro_wed
roweled11269863_roweled
rowelled1236633_rowelled
ruled65822523_r_uled
scolded11358863scolded
scowled13398193scowled
sculled102911693sculled
shelled113815083shelled
shilled113313623shilled
shoaled113810973shoaled
shooled115212663shooled
shrilled1246863shrilled
skilled123110863skilled
skoaled12226063skoaled
skulled12317403skulled
smelled103511853smelled
snelled83313043snelled
snooled84513943snooled
soiled73822473_soiled
soled65835173_so_led
soloed74515743_soloed
solved105312933_solved
souled75419823_souled
spalled103113133spalled
spelled103714733spelled
spilled103613623spilled
spoiled104811353spoiled
spooled104613523spooled
stalled83515683stalled
stilled83314783stilled
stoled74521593sto_led
stollen747583stollen
stooled84313893stooled
stroller848173stroller
swelled113211693swelled
swilled113611833swilled
swollen1034263swollen
tholed105113873tho_led
thralled1245803thralled
thrilled1235493thrilled
tilled74722953_tilled
toiled74420323_toiled
toled65934923_to_led
toller63819443_toller
tooled74918903_tooled
tootled83511043tootled
trailed83415673trailed
trawled113411523trawled
trebled1038483trebled
trifled113711963trifled
triller74215893triller
tripled104113833tripled
troaked12438253troaked
trocked144312243trocked
troked114114583tro_ked
troland837543troland
troll54416533troll__
trollers83211213trollers
trolleyed1342473trolleyed
trolleys11315693trolleys
trollies8310233trollies
trollop944793trollop
trolls64613943troll_s
trolly94012363troll_y
tromped124210293tromped
trooped104010723trooped
trothed114010973trothed
trotted83711283trotted
troubled1134983troubled
trouped103910983trouped
trowed104714653tro_wed
troweled12106113troweled
trowelled1344443trowelled
twilled11398033twilled
undrilled1146663undrilled
unoiled82415483unoiled
unpolled1168943unpolled
vialled1156843vialled
voled95323723_vo_led
volley12419743_volley
vroomed13366433vroomed
walled104021293_walled
welled103820213_welled
whorled14366903whorled
willed104722453_willed
wolfed13428013_wolfed
wooled103715503_wooled
woollen1034723woollen
wronged12397673wronged
yelled104116253_yelled
yodled11389653_yodled
yolked14367153_yolked
yowled133811093_yowled

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.403443402.0
2DLD Change Limit1340275136.92319359.7
3Display Results5135130.1862758.1
 (SQL Overall)1786915137.51223787.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.