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

269 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
knolly1333613(None) 
knoll9389601knoll_
knolls10367411knolls
anally9513502anally
brolly114510852brolly
colly104926772_colly
coolly114811392coolly
dolly96125202_dolly
drolly105411672drolly
folly115022602_folly
golly95121102_golly
holly114824432_holly
jolly154517512_jolly
kelly124617022k_elly
knell94210922knell_
knells10439252knells
knobbly1842872knobbly
knobby1732712knobby
knolled12296562knolled
knoller11285902knoller
knotty13315222knotty
knurly13405532knurly
lolly85120662_lolly
molly105222492_molly
nelly84618812_nelly
nobly105314402_nobly
noily86120992_noily
trolly94012362trolly
wholly15366572wholly
woolly12408512woolly
abolla8410193abolla
ally76935643__ally
anodally1246293anodally
anole55330373ano_le
anoles64827423anoles
anomaly1238843anomaly
anomy105113393ano_my
apollo837183apollo
atoll57913923atoll_
atolls65511353atolls
bally105530103_bally
banally1249223banally
belly104625493_belly
billy105525363_billy
boldly12399423_boldly
boll65634753_boll_
bolls75531313_bolls
bully105124813_bully
chally144314293chally
chilly144113223chilly
cholla113911023cholla
coaly105521593_coaly
colby124415063_colby
coldly12459953_coldly
coly96940533_co_ly
cooly105525423_cooly
coyly135614893_coyly
cully105520463_cully
dally95324743_dally
delly96023873_delly
dhooly13457143dhooly
dilly94923783_dilly
doily95321033_doily
doll56632493_doll_
dolls66126923_dolls
dooly94821803_dooly
doyly124514013_doyly
droll65415403droll_
drolls75312393drolls
drooly104911073drooly
dually103210063dually
dully94921633_dully
enol45823823eno_l_
enolic8413353enolic
enology11239813enology
enols54718403eno_ls
enroll61110073enroll_
enrolls7108093enrolls
evilly1236593evilly
felly114922803_felly
filly114424903_filly
finally13310103finally
foley115222303_foley
folky159214713_folky
fondly13299043fondly
foully1239013foully
frilly124111443frilly
fully114820863_fully
gally95026173_gally
gilly94321633_gilly
gnarly104610383gnarly
godly104913293_godly
goodly11419303goodly
googly11417883googly
growly13499173growly
gully94020683_gully
hilly114422163_hilly
holey115626903_holey
holily123612953_holily
holla84918493_holla
hollo84822163_hollo
holy106333433_ho_ly
hooly115022223_hooly
hotly115815483_hotly
ignobly1342873ignobly
illy76925333__illy
inlay85214323in_lay
inly75622213in__ly
jelly154218253_jelly
jolty155713033_jolty
jowly186410903_jowly
kaolin1039583kaolin
keenly1336373keenly
kelpy145110683k_elpy
kernelly1543923kernelly
kill85533173k_ill_
kills94526173k_ills
kilty125213893k_ilty
kindly14358843kindly
kingly143511303kingly
kinkily1335223kinkily
knarry1334613knarry
kneel95012033kneel_
kneels10408933kneels
knelled12338983knelled
knelt94617683kn_elt
knob107417013kno__b
knobs11519713kno_bs
knock10487963kno_ck
knocks11397443knocks
knollers12255133knollers
knolling13206883knolling
knop107116593kno__p
knops115911813kno_ps
knosp11576823kno_sp
knosps12405013knosps
knot85630503kno__t
knots95614723kno_ts
knottily1543153knottily
knout95018263kno_ut
knouts10438313knouts
know116115843kno__w
knower1337073knower
known12568343kno_wn
knowns13426443knowns
knows124912413kno_ws
knubby1742783knubby
knuckly1542473knuckly
knurl9398913knurl_
knurls10396243knurls
koala95112213k_oala
koel84519943k_oel_
koels94613903k_oels
kohl113911713k_ohl_
kohls12437803k_ohls
kola85124963k_o_la
kolas94822233k_olas
kolo87026223k_o_lo
kolos94921213k_olos
kooky114412873k_ooky
krill94213643krill_
krills104211283krills
kvell12436693kvell_
kvells13346613kvells
leally94012613leally
loll46128383_loll_
lolls512121733_lolls
lonely92912473lonely
longly10279603longly
lowly114113333_lowly
moldy115014653_moldy
moll66735703_moll_
molls75129783_molls
moly96031913_mo_ly
mooley11311633mooley
newly114610203_newly
nill45634303_nill_
nills54926673_nills
nobby125513463_nobby
noble74420993_noble
nodally1137913_nodally
noddy105411203_noddy
noel45226553_noel_
noels56418703_noels
noil46133243_noil_
noils55024333_noils
noisy86813363_noisy
nolo46229313_no_lo
nolos54423353_nolos
nonoily1049543nonoily
nonyl849773_nonyl
nooky124814813_nooky
nosey85619883_nosey
nosily93712683_nosily
nosy76322893_no_sy
novelly1346513_novelly
noway111112843_noway
null45125313_null_
nulls55019983_nulls
oily77932253__oily
oldy85316843__oldy
olla44821173__olla
onlay84212943on_lay
only75319723__only
orally93113593orally
ovally12278443ovally
pally105727123_pally
panoply1434713panoply
penally121111763penally
poll66332133_poll_
polls74627723_polls
poly96235153_po_ly
poorly1137893poorly
quoll14379493quoll_
quolls15327303quolls
rally84725903_rally
really93315613really
roily86121113_roily
roll46331653_roll_
rolls55326233_rolls
sally85129713_sally
shelly124414473shelly
shoaly124010773shoaly
silly84527623_silly
slowly1237153slowly
smelly114110363smelly
snarly93815003snarly
snell54517303snell_
snells64614203snells
snobby1334403snobby
snool55118643snool_
snools65715883snools
snoopy11449473snoopy
snooty94211513snooty
snoozy18517233snoozy
snotty9489203snotty
snouty9419953snouty
snowily1336883snowily
snowy115011563sno_wy
snugly1055663snugly
solely93714213_solely
sonly85718053_sonly
stilly93714093stilly
sully84622903_sully
tally84526863_tally
telly84920823_telly
toll45535263_toll_
tolls54728433_tolls
tolyl84710093_tolyl
tonally10311373tonally
troll54416533troll_
trolley10328753trolley
trolls64613943trolls
unduly1037823unduly
ungodly1244473ungodly
unholily1444133unholily
unholy1238163unholy
unlay84613703un_lay
unroll61210073unroll_
unrolls797793unrolls
unruly938083unruly
venally13119563venally
volley12419743_volley
wally114625093_wally
welly114620013_welly
willy115321913_willy
wooly114417673_wooly
yolky15529523_yolky
zonally1938003zonally

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.1401276364.3
2DLD Change Limit1127162695.11022057.9
3Display Results2692690.0763539.5
 (SQL Overall)1786912695.32633550.7
 
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.