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

468 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
drolly10541167(None) 
brolly114510851brolly
dolly96125201d_olly
droll65415401droll_
drolls75312391drolls
drooly104911071drooly
trolly94012361trolly
colly104926772_colly
coolly114811392coolly
dally95324742d_ally
delly96023872d_elly
dhooly13457142dhooly
dilly94923782d_illy
doily95321032d_oily
doll56632492d_oll_
dolls66126922d_olls
dooly94821802d_ooly
doyly124514012d_oyly
drably123511612drably
drawly134910722drawly
drill64718262drill_
drills74414202drills
drily95816522dr_ily
drolled93810222drolled
droller84110282droller
drollery12314792drollery
drool65416102drool_
drools74412812drools
droopy12458242droopy
dropsy12497472dropsy
drosky14486162drosky
drossy10528472drossy
drowsy13487902drowsy
drumly1235702drumly
dryly12538452dr_yly
dually103210062dually
dully94921632d_ully
folly115022602_folly
frilly124111442frilly
golly95121102_golly
growly13499172growly
holly114824432_holly
jolly154517512_jolly
knolly13336132knolly
lolly85120662_lolly
molly105222492_molly
orally93113592orally
rally84725902_rally
roily86121112_roily
roll46331652_roll_
rolls55326232_rolls
troll54416532troll_
trolley10328752trolley
trolls64613942trolls
wholly15366572wholly
woolly12408512woolly
abolla8410193abolla
adroitly1243363adroitly
ally76935643__ally
anally9513503anally
apollo837183apollo
archly1437353archly
areally10411243areally
aridly105513703aridly
artily92814713artily
atoll57913923atoll_
atolls65511353atolls
aurally10310543aurally
bally105530103_bally
bedroll1055553bedroll_
bedrolls1144673bedrolls
belly104625493_belly
billy105525363_billy
boldly12399423_boldly
boll65634753_boll_
bolls75531313_bolls
brawly144312353brawly
brill74819953brill_
brillo84211003brillo
brills84916293brills
broadly1337153broadly
broil74918223broil_
broils84114173broils
bronzy20306713bronzy
broody124510083broody
broomy13449953broomy
brosy106115383bro_sy
brothy14519623brothy
browny144510043browny
bully105124813_bully
chally144314293chally
chilly144113223chilly
cholla113911023cholla
coaly105521593_coaly
colby124415063_colby
coldly12459953_coldly
coly96940533_co_ly
cooly105525423_cooly
corolla938623corolla
coyly135614893_coyly
crawly144610763crawly
criollo943953criollo
croaky15528483croaky
crony105918673cro_ny
crossly1277273crossly
croupy13458733croupy
crowdy15467173crowdy
cruelly1236563cruelly
cully105520463_cully
daftly1335443daftly
daily95922333d_aily
damply14337893damply
dangly114212263dangly
dankly14419463dankly
darkly145411073darkly
dayfly1633813dayfly
daylily1434983daylily
deadly113811473deadly
deafly13389123deafly
dearly104615323dearly
deeply1257013deeply
deftly1336533deftly
delay94820633d_elay
dell56938203d_ell_
dells66630943d_ells
deoxy1648883deo_xy
deploy1237583deploy
dewily1338343dewily
dhole95215363dho_le
dholes104914793dholes
diddly12389573diddly
dill55239973d_ill_
dills65530973d_ills
dimly114913483d_imly
dimply14339743dimply
dinkly144311083dinkly
dioecy1235543dioecy
diol57329133dio_l_
diols65521013dio_ls
direly10311563direly
dirtily1138583dirtily
dobby136013633d_obby
dobla84913643d_obla
doby106022163d_o_by
dodgy116611463d_odgy
dogey105719513d_ogey
doggy115214873d_oggy
dogy96126493d_o_gy
dol47150653d_o_l_
dolce85816683d_olce
dolci84912603d_olci
dole56550003d_o_le
doled75430913d_oled
doles67843753d_oles
dollar74110983d_ollar
dolled83518073d_olled
dollop9259363d_ollop
dolma86214173d_olma
dolor67617963d_olor
dols56943053d_o_ls
dolt56649423d_o_lt
dolts65626313d_olts
donsy96414683d_onsy
doodle83212853doodle
doody105517913d_oody
doolee73018953doolee
doolie73916833doolie
doomily1336133doomily
doomy116018263d_oomy
doozy186813713d_oozy
dopey116020353d_opey
dopily123510463dopily
dopy106224153d_o_py
dorky135518743d_orky
dormy115817473d_ormy
dorsally1246833dorsally
dorty96220813d_orty
dory85836233d_o_ry
dotty94516103d_otty
doty86128223d_o_ty
doubly12328963doubly
doula65717773d_oula
dourly103210433dourly
dowdy136112543d_owdy
downy125714553d_owny
dowry126312483d_owry
doxy156419953d_o_xy
doyley13487283doyley
dozily19329103dozily
dozy175920323d_o_zy
draffy16486633draffy
drafty13638933drafty
draggy12346823draggy
drail65020973drail_
drails74716953drails
drapey125010583drapey
drawl95516013drawl_
drawls105511393drawls
dray85428093dr__ay
dreamy12509993dreamy
dreary104611673dreary
drecky16486333drecky
dreggy12364633dreggy
dressy10518143dressy
dribbly15274953dribbly
drifty13418223drifty
drilled94711673drilled
driller84311883driller
drippy14445653drippy
drizzly19364553drizzly
drogue8938333drogue
droid74218543dro_id
droids84712583droids
droit65127123dro_it
droits74314313droits
drollest937353drollest
drolling103510763drolling
dromon939363dromon
drone65324983dro_ne
droned84616863droned
droner74717673droner
drones75023433drones
drongo836793drongo
drooled9369203drooled
droop85814823dro_op
droopily1443943droopily
droops95110963droops
drop75324403dro__p
droplet10312113droplet
drops85719503dro_ps
dropt86924433dro_pt
droshky1841973droshky
dross65418093dro_ss
drouk1039433dro_uk
drouks1137123drouks
drouth104410103drouth
drouthy14395173drouthy
drove95518063dro_ve
droved114611643droved
drover104614593drover
droves105116673droves
drown95515823dro_wn
drownd11478313drownd
drowns105612333drowns
drowse105010553drowse
drowsily1583723drowsily
druggy12344743druggy
dry76526033dr___y
drylot1037403drylot
ducally13257413ducally
duelli767003duelli
duello756783duello
dull56430443d_ull_
dulls64523743d_ulls
duly85323033d__uly
dumbly14399603dumbly
duolog835803duolog
duopoly1343683duopoly
durably13229053durably
dwell9519853dwell_
dwells10417713dwells
enroll61110073enroll_
enrolls7108093enrolls
erosely1038073erosely
evilly1236593evilly
felly114922803_felly
filly114424903_filly
foley115222303_foley
folky159214713_folky
foully1239013foully
frailly1337313frailly
freely12310953freely
frill84917563frill_
frills94414223frills
froggy1434493froggy
frolic1149203frolic
frosty124710633frosty
frothy15578373frothy
frouzy21395283frouzy
frowsy15498273frowsy
frowzy24485793frowzy
fully114820863_fully
gally95026173_gally
gilly94321633_gilly
girolle835793girolle
godly104913293_godly
goodly11419303goodly
googly11417883googly
gorily10612503gorily
grayly13287963grayly
greyly13316543greyly
grill64617893grill_
grille74315743grille
grills74314803grills
grimly12459933grimly
grisly104310583grisly
grody103412063gro_dy
groggy1234803groggy
groovy13375403groovy
grossly1175983grossly
groszy19395703groszy
grotty10389833grotty
grouty104710983grouty
growl96115823growl_
growls104711113growls
gully94020683_gully
gyrally1435583gyrally
hilly114422163_hilly
holey115626903_holey
holily123612953_holily
holla84918493_holla
hollo84822163_hollo
holy106333433_ho_ly
hooly115022223_hooly
hotly115815483_hotly
ideally1137793ideally
illy76925333__illy
irony85015903iro_ny
jelly154218253_jelly
jolty155713033_jolty
jowly186410903_jowly
jurally1736963jurally
kelly124617023_kelly
knoll9389603knoll_
knolls10367413knolls
krill94213643krill_
krills104211283krills
leally94012613leally
loll46128383_loll_
lolls512121733_lolls
lordly1038753lordly
lowly114113333_lowly
moldy115014653_moldy
moll66735703_moll_
molls75129783_molls
moly96031913_mo_ly
mooley11311633mooley
morally12411493morally
nelly84618813_nelly
nobly105314403_nobly
noily86120993_noily
oily77932253__oily
oldy85316843__oldy
olla44821173__olla
only75319723__only
orology11319463orology
ovally12278443ovally
pally105727123_pally
poll66332133_poll_
polls74627723_polls
poly96235153_po_ly
poorly1137893poorly
portly114713403portly
prill74117943prill_
prills84015613prills
primly13439623primly
priorly12335763priorly
prolan8414693prolan
prole74527793pro_le
proleg94612113proleg
proles84627203proles
prolix1538683prolix
prolixly2043103prolixly
prolog94212973prolog
pronely12310243pronely
propyl13358183propyl
prosily12611633prosily
prosy106319253pro_sy
protyl11308213protyl
proudly1336323proudly
prowl105615123prowl_
prowls115511083prowls
proxy175011013pro_xy
quoll14379493quoll_
quolls15327303quolls
rallye95110163_rallye
rawly115115833_rawly
really93315613really
redly94217193_redly
refly113914563_refly
relay84424673_relay
rely75428953_r_ely
reply104015853_reply
reroll6412683reroll_
rerolls739943rerolls
riley84420583_riley
rill45140903_rill_
rille55728733_rille
rills55032713_rills
roble75223023_roble
rocky144513853_rocky
roil46235293_roil_
roils54826793_roils
role45851823_ro_le
roles56747983_roles
rolf75134873_ro_lf
rolfs84817123_rolfs
rolled74220243_rolled
roller63919793_roller
rollway1344653_rollway
rooky126117623_rooky
roomy107118063_roomy
rooty86423023_rooty
ropey106021873_ropey
ropily113312443_ropily
ropy96323413_ro_py
rosily93914713_rosily
rosy76024873_ro_sy
rotl45029683_rotl_
rotls55620163_rotls
roupy106112713_roupy
rowdy125711533_rowdy
royally13157733_royally
ruly76323143_r_uly
rurally1038303rurally
sally85129713_sally
scroll8310163scroll_
scrolls938063scrolls
shelly124414473shelly
shoaly124010773shoaly
shrilly13318563shrilly
silly84527623_silly
slowly1237153slowly
smelly114110363smelly
solely93714213_solely
sonly85718053_sonly
sorely94618013sorely
stilly93714093stilly
stroll6311603stroll_
strolls739183strolls
sully84622903_sully
tally84526863_tally
telly84920823_telly
toll45535263_toll_
tolls54728433_tolls
tolyl84710093_tolyl
trebly1138973trebly
trigly103810943trigly
trilby1144973trilby
trill55122933trill_
trills64319853trills
trimly114410893trimly
triply114211023triply
trolled84312263trolled
troller73913173troller
trolleys11315693trolleys
trollop944793trollop
trollopy1343273trollopy
trophy1438283trophy
trotyl9236673trotyl
trouty95211793trouty
troy77429683tro__y
trull54012673trull_
trulls64110283trulls
truly84111553tr_uly
unroll61210073unroll_
unrolls797793unrolls
urology11217583urology
virally1339653virally
volley12419743_volley
wally114625093_wally
welly114620013_welly
willy115321913_willy
wooly114417673_wooly
worldly1433983worldly
wrongly1434553wrongly
wryly14356703wr_yly
yolky15529523_yolky

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164686.01618736.0
3Display Results4684680.1533058.8
 (SQL Overall)1786914686.30928323.2
 
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.