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

405 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
wholly1536657(None) 
holly114824431_holly
woolly12408511woolly
brolly114510852brolly
chally144314292chally
chilly144113222chilly
cholla113911022cholla
colly104926772_colly
coolly114811392coolly
dhooly13457142dhooly
dolly96125202_dolly
drolly105411672drolly
folly115022602_folly
golly95121102_golly
hilly114422162_hilly
holey115626902_holey
holily123612952_holily
holla84918492_holla
hollo84822162_hollo
holy106333432_ho_ly
hooly115022222_hooly
hotly115815472_hotly
jolly154517512_jolly
knolly13336132knolly
lolly85120662_lolly
molly105222492_molly
shelly124414462shelly
shoaly124010762shoaly
trolly94012352trolly
wally114625092w_ally
welly114620012w_elly
whelky19314972whelky
whirly15448862whirly
whole114418092who_le
wholes124616772wholes
whorl114612452whorl_
whorls124410162whorls
willy115321912w_illy
wooly114417672w_ooly
abolla8410193abolla
ahold94714253aho_ld
aholds10469483aholds
ahoy101919183aho__y
ahull84010313ahull_
ally76935643__ally
anally9513503anally
aphylly1843353aphylly
apollo837183apollo
atoll57913923atoll_
atolls65511353atolls
awfully1644003awfully
bally105530103_bally
belly104625493_belly
billy105525363_billy
boldly12399423_boldly
boll65634753_boll_
bolls75531313_bolls
bully105124813_bully
chalky18468773chalky
challa114014193challa
chicly16429203chicly
childly1644803childly
chill105619873chill_
chilli114312773chilli
chills114717703chills
chokey184811713chokey
choky175711223cho_ky
chola104718033cho_la
cholas114817993cholas
choler113717153choler
chollas123811353chollas
cholo105217973cho_lo
cholos114716853cholos
choosy14459103choosy
choppy18376293choppy
chorally1638103chorally
coaly105521593_coaly
colby124415063_colby
coldly12459953_coldly
coly96940533_co_ly
cooly105525423_cooly
coyly135614893_coyly
cully105520463_cully
dally95324743_dally
delly96023873_delly
dhole95215363dho_le
dholes104914793dholes
dilly94923783_dilly
doily95321033_doily
doll56632493_doll_
dolls66126923_dolls
dooly94821803_dooly
doyly124514013_doyly
droll65415403droll_
drolls75312393drolls
drooly104911073drooly
dually103210063dually
dully94921633_dully
evilly1236593evilly
felly114922803_felly
filly114424903_filly
foley115222303_foley
folky159214713_folky
foully1239013foully
frilly124111443frilly
fully114820863_fully
gally95026173_gally
ghostly14355103ghostly
ghosty13467213ghosty
ghoul959053ghoul_
ghouls1036043ghouls
ghyll1246323ghyll_
ghylls1335143ghylls
gilly94321633_gilly
godly104913293_godly
goodly11419303goodly
googly11417883googly
growly13499173growly
gully94020683_gully
hall75741163_hall_
hallo85127553_hallo
halls85633783_halls
haply135915063_haply
hell75637893_hell_
hello86522983_hello
hells85032043_hells
hill76439493_hill_
hillo84721653_hillo
hills85431353_hills
hiply134113613_hiply
hoagy124710473_hoagy
hoary114516763_hoary
hobby155913723_hobby
hokey155422183_hokey
hokily16409093_hokily
hold86235063_ho_ld
holds94623243_holds
hole77553393_ho_le
holed95634133_holed
holes84748653_holes
holk116027943_ho_lk
holks124720563_holks
hollas94616903_hollas
holler93520613_holler
holloa94914823_holloa
holloo94415253_holloo
hollos95320633_hollos
hollow124212663_hollow
holm95628103_ho_lm
holms105117803_holms
holp95727553_ho_lp
hols76946293_ho_ls
holt77852583_ho_lt
holts85627913_holts
homely145313173_homely
homey135924843_homey
homily144712333_homily
homy126623223_ho_my
honey115629913_honey
honky156218523_honky
hoody124919723_hoody
hooey114926603_hooey
hooky155220263_hooky
hooty115022433_hooty
hoppy154912353_hoppy
horny115619623_horny
horsy116318393_horsy
hosey116127023_hosey
hostly124210863_hostly
hourly12369623_hourly
howdy155711413_howdy
howl107625693_howl_
howls116219223_howls
hoy97447913_ho__y
hoyle11314413_hoyle
hulky155312473_hulky
hull75428783_hull_
hullo84417453_hullo
hulls84923563_hulls
hurly115819293_hurly
illy76925333__illy
jelly154218253_jelly
jolty155713033_jolty
jowly186410903_jowly
kelly124617023_kelly
knoll9389603knoll_
knolls10367413knolls
leally94012613leally
loll46128383_loll_
lolls512121733_lolls
lowly114113333_lowly
moldy115014653_moldy
moll66735703_moll_
molls75129783_molls
moly96031913_mo_ly
mooley11311633mooley
nelly84618813_nelly
nobly105314403_nobly
noily86120993_noily
oily77932253__oily
oldy85316843__oldy
olla44821173__olla
only75319723__only
orally93113593orally
ovally12278443ovally
pally105727123_pally
phalli1148263phalli
phoney143612983phoney
phonily1537103phonily
phony136715443pho_ny
phooey14379233phooey
phyllo1435873phyllo
poll66332133_poll_
polls74627723_polls
poly96235153_po_ly
poorly1137893poorly
quoll14379493quoll_
quolls15327303quolls
rally84725903_rally
really93315613really
roily86121113_roily
roll46331653_roll_
rolls55326233_rolls
sally85129713_sally
shaley123714993shaley
shall85024053shall_
shaly114322863sh_aly
shell84424123shell_
shells94319523shells
shelty124011543shelty
shelvy15377863shelvy
shill85325333shill_
shills94519603shills
shily115222013sh_ily
shoal83920263shoal_
shoals94215783shoals
shoddy1434533shoddy
sholom11910093sholom
shoofly1634343shoofly
shool84523143shool_
shools94919003shools
shorl84720243shorl_
shorls94516193shorls
shortly13387563shortly
shorty124313193shorty
should1038023should
showily1636213showily
showy145714003sho_wy
shrilly13318553shrilly
shyly144811573sh_yly
silly84527613_silly
slowly1237153slowly
smelly114110353smelly
solely93714213_solely
sonly85718053_sonly
stilly93714073stilly
sully84622893_sully
tally84526863_tally
telly84920823_telly
thalli958903thalli
thill85918733thill_
thills95515383thills
thinly1238663thinly
thole85620843tho_le
tholed105113873tholed
tholes94919783tholes
tholoi9339223tholoi
tholos94213003tholos
thorny12509843thorny
thusly1235133thusly
toll45535263_toll_
tolls54728433_tolls
tolyl84710093_tolyl
troll54416533troll_
trolley10328753trolley
trolls64613943trolls
unholily1444133unholily
unholy1238163unho_ly
volley12419743_volley
wabbly16348363wabbly
waddly14478723waddly
waffly18305433waffly
waggly14347293waggly
wall76236103w_all_
walla85321033w_alla
walls85529383w_alls
waly105830903w__aly
wambly16388663wambly
wanly115118023w_anly
warily122915093warily
warmly14228063warmly
wavily15219483wavily
waxily19218413waxily
waylay1535453waylay
weakly1636483weakly
weekly1635313weekly
well75832043w_ell_
wells85426193w_ells
wetly114511713w_etly
whacky21556493whacky
whale115517433wh_ale
whaled134612033whaled
whaler124611973whaler
whales124716943whales
whammy19375293whammy
wheal115716183wheal_
wheals124512523wheals
wheel115515333wheel_
wheels123811713wheels
wheezy24244523wheezy
whelk154311063wh_elk
whelks16367323whelks
whelm134611983wh_elm
whelms14377573whelms
whelp136012093wh_elp
whelps14437843whelps
wherry15477333wherry
whey135018713wh__ey
wheyey1834323wheyey
while115418693wh_ile
whiled134514133whiled
whiles124418013whiles
whilom1436133whilom
whilst1239143whilst
whimsy17375223whimsy
whiney155012643whiney
whinny15587493whinny
whiny144915573wh_iny
whippy19385843whippy
whirl114913823whirl_
whirls124710533whirls
whirry15477063whirry
whisky19455903whisky
whitely16346473whitely
whitey154911883whitey
whity145513473wh_ity
whizzy23274073whizzy
who95526773who___
whoa106615203who__a
wholism1535873wholism
whom127018173who__m
whomp155011323who_mp
whomps16457603whomps
whomso1434133whomso
whoof144612693who_of
whoofs15457243whoofs
whoop134211443who_op
whoopla1542633whoopla
whoops14487863whoops
whoosh15244353whoosh
whop125520923who__p
whops135013933who_ps
whore116018043who_re
whored135512123whored
whores125617103whores
whorled14366903whorled
whort114623693who_rt
whortle13335943whortle
whorts125111433whorts
whose114914533who_se
whosis1237163whosis
whoso11509223who_so
why126920013wh___y
widely133311033widely
wieldy13476183wieldy
wifely15429423wifely
wiggly14559683wiggly
wildly13328123wildly
wilily123310763wilily
will75737513w_ill_
wills84528963w_ills
wily106428813w__ily
wirily123310783wirily
wisely122711713wisely
woald94813073w_oald
wobbly16347093wobbly
wofully1644523wofully
wold85429073w_o_ld
wolds95420183w_olds
wolf105729563w_o_lf
wolfs116214163w_olfs
womby155910093w_omby
wonky154011773w_onky
woodsy13505923woodsy
woody125116883w_oody
wool76427373w_ool_
wooled103715503wooled
woolen93111373woolen
wooler93615873wooler
woolie93514483woolie
woolled1136643woolled
woollen1034723woollen
woollily1443123woollily
wools84421463w_ools
woozily2234383woozily
woozy204410603w_oozy
wordy126916163w_ordy
world96915363w_orld
worldly1433963worldly
wormy137514253w_ormy
worry116114333w_orry
would95513153w_ould
wrongly1434553wrongly
wryly14356703w_ryly
yolky15529523_yolky

Search took 6 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.1701051123.5
2DLD Change Limit1127164055.11022057.9
3Display Results4054050.1263214.3
 (SQL Overall)1786914055.40633054.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.