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

381 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
dhooly1345714(None) 
dooly94821801d_ooly
drooly104911071drooly
hooly115022221_hooly
choosy14459102choosy
cooly105525422_cooly
dhole95215362dh_ole
dhoora1035652dhoora
dhooti1035662dhooti
doily95321032d_oily
dolly96125202d_olly
doody105517912d_oody
doomy116018262d_oomy
doozy186813712d_oozy
doyly124514012d_oyly
drolly105411672drolly
drool65416102drool_
drools74412812drools
droopy12458242droopy
duopoly1343682duopoly
holly114824432_holly
holy106333432_h_oly
hoody124919722_hoody
hooey114926602_hooey
hooky155220262_hooky
hooty115022442_hooty
hotly115815482_hotly
phooey14379232phooey
shoaly124010772shoaly
shoofly1634352shoofly
shool84523152shool_
shools94919012shools
wholly15366572wholly
wooly114417672_wooly
ahold94714253ah_old
ahoy101919183ah_o_y
aloofly1343623aloofly
bhoot104322103bhoo_t
bhoots11459913bhoots
bloody124710173bloody
blooey115110793blooey
bloomy134510113bloomy
booby125319513_booby
boody115420403_boody
boogy114518323_boogy
boomy125421823_boomy
booty106125913_booty
boozy194917063_boozy
brolly114510853brolly
broody124510083broody
broomy13449953broomy
chally144314293chally
chicly16429203chicly
chilly144113223chilly
chokey184811713chokey
choky175711223ch_oky
chola104718033ch_ola
cholla113911023cholla
cholo105217973ch_olo
cholos114716853cholos
chook146015043choo_k
chooks155312793chooks
choose115116143choose
choosey15459233choosey
choppy18376293choppy
chromy16309903chromy
coaly105521593_coaly
colly104926773_colly
coly96940533__coly
cooey105828223_cooey
cooky145321363_cooky
cool66940493_cool_
coolly114811393coolly
cools75632633_cools
coyly135614893_coyly
daftly1335443daftly
dahoon1039053dahoo_n
dahoons1137753dahoons
daily95922333d_aily
dally95324743d_ally
damply14337893damply
dangly114212263dangly
dankly14419463dankly
darkly145411073darkly
dayfly1633813dayfly
deadly113811473deadly
deafly13389123deafly
dearly104615323dearly
decoy115716313deco_y
deeply1257013deeply
deftly1336533deftly
delly96023873d_elly
deoxy1648883d_eoxy
deploy1237583deploy
desoxy1744623desoxy
dewily1338343dewily
dewool1047403dewool_
dewools1145593dewools
dhal86719283dh_al_
dhals95415443dh_als
dhobi1136973dh_obi
dhobis1236113dhobis
dholes104914793dholes
dhoolies1246963dhoolies
dhooras1135943dhooras
dhootie1136473dhootie
dhootis1135683dhootis
dhoti9310123dh_oti
dhotis1038973dhotis
dhow116614003dh_o_w
dhows125911223dh_ows
diddly12389573diddly
dilly94923783d_illy
dimly114913483d_imly
dimply14339743dimply
dinkly144311083dinkly
diobol936883diobol_
diobols1036543diobols
dioecy1235543dioecy
diol57329133d_iol_
diols65521013d_iols
dipody1336363dipody
dipole91112853dipole
direly10311563direly
dobby136013633d_obby
dobla84913643d_obla
doby106022163d__oby
dodgy116611463d_odgy
dogey105719513d_ogey
doggy115214873d_oggy
dogy96126493d__ogy
dol47150653d__ol_
dole56550003d__ole
doll56632493d__oll
dolls66126923d_olls
dolor67617963d_olor
dols56943053d__ols
dolt56649423d__olt
donsy96414683d_onsy
doodle83212853doodle
doolee73018953d_oolee
doolie73916833d_oolie
doom76430073d_oo_m
doomily1336133doomily
dooms85321343d_ooms
door56928513d_oo_r
doors65022133d_oors
dopey116020353d_opey
dopily123510463dopily
dopy106224153d__opy
dorky135518743d_orky
dormy115817473d_ormy
dorty96220813d_orty
dory85836233d__ory
dotty94516103d_otty
doty86128223d__oty
doubly12328963doubly
doula65717773d_oula
dourly103210433dourly
dowdy136112543d_owdy
downy125714553d_owny
dowry126312483d_owry
doxy156419953d__oxy
doyley13487283d_oyley
dozily19329103dozily
dozy175920323d__ozy
drably123511613drably
drawly134910723drawly
drily95816523d_rily
droll65415403d_roll
drolls75312393drolls
drooled9369203drooled
droop85814823droo_p
droopily1443943droopily
droops95110963droops
dropsy12497473dropsy
drosky14486163drosky
drossy10528473drossy
drowsy13487903drowsy
drumly1235703drumly
dryly12538453d_ryly
dually103210063dually
dully94921633d_ully
duly85323033d__uly
dumbly14399603dumbly
duolog835803duolog
emboly1336723emboly
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
folly115022603_folly
fool75330593_fool_
fools86824203_fools
footy115820533_footy
ghostly14355103ghostly
ghosty13467213ghosty
ghoul959053ghoul_
ghouls1036043ghouls
gloomy12528763gloomy
godly104913293_godly
golly95121103_golly
goodly11419303goodly
goody105620393_goody
gooey95522863_gooey
goofy124915623_goofy
googly11417883googly
gooky135818033_gooky
goony95519783_goony
goopy115816623_goopy
goosy96018883_goosy
groovy13375403groovy
growly13499173growly
haole84820083_haole
haply135915063_haply
hilly114422163_hilly
hiply134113613_hiply
hoagy124710473_hoagy
hoary114516763_hoary
hobby155913733_hobby
hokey155422183_hokey
hokily16409093_hokily
hold86235063_h_old
hole77553393_h_ole
holey115626903_holey
holily123612953_holily
holk116027943_h_olk
holla84918493_holla
hollo84822163_hollo
holm95628113_h_olm
holp95727553_h_olp
hols76946293_h_ols
holt77852583_h_olt
homely145313173_homely
homey135924843_homey
homily144712333_homily
homy126623223_h_omy
honey115629913_honey
honky156218523_honky
hooch135813703_hooch
hood85132333_hoo_d
hoods95124083_hoods
hooeys125512313_hooeys
hoof106036583_hoo_f
hoofs115721043_hoofs
hook116133283_hoo_k
hooka125513903_hooka
hookey164713933_hookey
hooks125027123_hooks
hoolie93217783_hoolie
hoop96129983_hoo_p
hoopla1147633_hoopla
hoops105621073_hoops
hooray123011373_hooray
hoot75752103_hoo_t
hoots84830253_hoots
hoppy154912353_hoppy
horny115619623_horny
horsy116318393_horsy
hosey116127023_hosey
hostly124210863_hostly
hourly12369623_hourly
howdy155711413_howdy
howl107625693_howl_
howls116219223_howls
hoy97447913_h_o_y
hoyle11314413_hoyle
hurly115819293_hurly
jolly154517513_jolly
jowly186410903_jowly
knolly13336133knolly
kooky114412873_kooky
lolly85120663_lolly
looby108115623_looby
looey84822913_looey
loony86918963_loony
loopy105316643_loopy
lowly114113333_lowly
molly105222493_molly
moly96031913__moly
moody115017493_moody
mool67533863_mool_
moola75117033_moola
mooley11311633_mooley
mools76027173_mools
moony104818273_moony
moory105115793_moory
nobly105314403_nobly
noily86120993_noily
nooky124814813_nooky
oily77932253__oily
only75319723__only
oozy167018133__oozy
phoney143612983phoney
phonily1537103phonily
phony136715443ph_ony
poly96235153__poly
poofy136213273_poofy
pool65835953_pool_
pools74427703_pools
poorly1137893poorly
ptooey11346413ptooey
roily86121113_roily
rooky126117623_rooky
roomy107118063_roomy
rooty86423023_rooty
school11410723school_
schools1249113schools
shaly114322863sh_aly
shelly124414473shelly
sheol84318373sheol_
sheols94614163sheols
shily115222013sh_ily
shoal83920273shoal_
shoals94215793shoals
shoddy1434543shoddy
sholom11910113sholom
shoo75929893shoo__
shooed103916083shooed
shook124920163shoo_k
shooks134515633shooks
shooled115212663shooled
shoon84022013shoo_n
shoos84226363shoo_s
shoot84235913shoo_t
shoots94619363shoots
shorl84720253shorl_
shorls94516203shorls
shortly13387573shortly
shorty124313203shorty
should1038033should
showily1636223showily
showy145714013sh_owy
shyly144811573sh_yly
slowly1237153slowly
snool55118643snool_
snools65715883snools
snoopy11449473snoopy
snooty94211513snooty
snoozy18517233snoozy
sonly85718053_sonly
sooey84522433_sooey
sooty84924843_sooty
spoofy14498553spoofy
spooky15418093spooky
spool75219043spool_
spools85115913spools
spoony114111793spoony
stool55619893stool_
stools65117023stools
swoony12408263swoony
swoopy14487283swoopy
theory121098363theory
thinly1238673thinly
thiol87616043thiol_
thiols95112763thiols
thole85620843th_ole
tholoi9339233tholoi
tholos94213003tholos
thorny12509843thorny
thusly1235133thusly
tool46735683_tool_
tools55325243_tools
trolly94012363trolly
unholy1238163unholy
whirly15448863whirly
whole114418093wh_ole
whoof144612693whoo_f
whoofs15457243whoofs
whoop134211443whoo_p
whoopla1542633whoopla
whoops14487863whoops
whoosh15244353whoosh
whorl114612453whorl_
whorls124410163whorls
woody125116883_woody
wool76427373_wool_
woolly12408513woolly
wools84421463_wools
woozy204410603_woozy
zooey173914803_zooey
zooty175415353_zooty

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 Limit1127163815.76619548.4
3Display Results3813810.1233097.6
 (SQL Overall)1786913816.02929638.6
 
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.