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

282 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
openly113712(None) 
evenly1236992evenly
keenly1336372keenly
only75319722o__nly
open66427002open__
opened94311862opened
opener83910992opener
opens76118552open_s
overly122411362overly
penny105119452_penny
spendy124911142spendy
adenyl1035023adenyl
agedly1136463agedly
agency1237033agency
alienly1037503alienly
apery106517903ape_ry
apetaly1237253apetaly
aplenty1237173aplenty
apply125111393ap_ply
aptly105111813ap_tly
belly104625493_belly
bendy115017253_bendy
benny105217363_benny
blenny1156203blenny
brokenly1744203brokenly
cleanly1236323cleanly
cogency1547013cogency
cogently1446323cogently
comely134213733come_ly
copen94826433copen__
copens106119963copen_s
cowedly1635703cowedly
deeply1257013deeply
delly96023873_delly
deny86027123_den_y
dopey116020353dope__y
dopily123510463dop_ily
eely77725213__eely
envy10411253__envy
feebly1436653feebly
felly114922803_felly
fenny115115133_fenny
ferly115517353_ferly
feyly14429513_feyly
finely123011563finely
freely12310963freely
frenzy2135883frenzy
frozenly2343123frozenly
gainly1049323gainly
gently103710913_gently
glegly1134873glegly
goldenly1344103goldenly
gospelly1443143gospelly
greenly11408193greenly
greyly13316543greyly
henley1237483_henley
henry114014473_henry
homely145313173home_ly
hopingly1735653hopingly
inly75622213__inly
jelly154218253_jelly
jenny153811623_jenny
kelly124617023_kelly
lanely93914483lanely
leanly93811503leanly
liefly1266363liefly
lonely92912473lone_ly
lovely12339713love_ly
loverly1346973loverly
mainly11411493mainly
manly105022953_manly
mealy104422183_mealy
meanly115412043meanly
meekly1535193meekly
meetly1138673meetly
modernly1443843modernly
moltenly1344583moltenly
momently1546473momently
mopery135210973mope_ry
mopey124821823mope__y
mopingly1636013mopingly
nelly84618813_nelly
newly114610203_newly
notedly1136883notedly
novelly1346513novelly
obeli73711933obe_li
obento837893obento
obesely1245113obesely
obey96521303obe__y
ocelli836843ocelli
oddly1037163o_ddly
oilily93111723oilily
oily77932253o__ily
omen66828183omen__
omened93711003omened
omens75618963omen_s
omenta83411723omenta
onery8414123one_ry
onlay84212943o__nlay
oogeny10117923oogen_y
oozily18328073oozily
opal66923523op_al_
opals75718353op_als
ope56845243ope___
oped76230153ope__d
openable1247013openable
openers9339493openers
openest9312913openest
opening1039923opening
opera7313573ope_ra
operably1557093operably
operantly1444913operantly
operas8312453operas
operon8811773operon
opes65942613ope__s
opine77422463opin_e
opined95113853opined
opines84820703opines
oping86322413opin_g
opulency1543323opulency
opulently1443633opulently
orally93113593orally
orangy105111233orangy
orderly1135763orderly
ornery938463ornery
outfly1238273outfly
ovally12278443ovally
oven76624143oven__
ovens86217453oven_s
overfly16246883overfly
overlay132410833overlay
overply15227653overply
overtly13268983overtly
oxen116218593oxen__
pally105727123_pally
paly95835533_p_aly
pandy115021173_pandy
pansy105717973_pansy
panty105929303_panty
patly105020583_patly
peaky145718153_peaky
peal68648103_peal_
peals75235493_peals
pearly116414843_pearly
peaty105725693_peaty
peavy135014843_peavy
pebbly1545083_pebbly
pecky165515093_pecky
peel65535613_peel_
peels75226423_peels
peery105719443_peery
pele65539553_pe_le
pelf97031453_pe_lf
pelt67651083_pe_lt
pen56558843_pen__
penal75228373_penal
penally121111773_penally
penalty1267743_penalty
pence94924453_pence
pend75934533_pen_d
pends85527193_pends
penes75839223_penes
pengo84317593_pengo
penile82219603_penile
penis75129323_penis
penna74520203_penna
penne75423853_penne
penni74617903_penni
pens65649643_pen_s
pent66559073_pen_t
pentyl1138813_pentyl
penult8314653_penult
penury1148103_penury
peony105717563_peony
pepla9312863_pepla
peppy114310363_peppy
perdy115417333_perdy
perky145319483_perky
perry105222713_perry
pertly115312553_pertly
pesky145911563_pesky
pesty106421713_pesty
petty105320293_petty
phenyl1435323phenyl
pily96132733_p_ily
piney105727503_piney
pinkly155012243_pinkly
pinky145823403_pinky
pinny105222063_pinny
piny911838353_pin_y
plenty11311413plenty
ply86323553_p__ly
poesy105014063poe_sy
poetry1139383poetry
pointy114913283pointy
pokily15309063pokily
poly96235153_p_oly
pony96434053_pon_y
poorly1137893poorly
popery134511703pope_ry
porny106020193porn_y
portly114713403portly
poshly1437723poshly
potency1457433potency
potently1347403potently
propenyl1544583propenyl
properly1546463properly
provenly1646203provenly
punily11311773_punily
punky144419393_punky
punny104217713_punny
punty106021613_punty
puny95526993_pun_y
queenly1944463queenly
redly94217203_redly
refly113914563_refly
rely75428953_re_ly
reply104015853_reply
ripely112511153ripe_ly
ropery114313873rope_ry
ropeway1544773ropeway
ropey106021873rope__y
ropily113312443rop_ily
rottenly1144153rottenly
sanely93114613sanely
seely84522633_seely
seemly1138433seemly
shelly124414473shelly
slovenly1443853slovenly
smelly114110363smelly
soberly1236943soberly
soddenly1343783soddenly
solely93714213sole_ly
solemnly1343843solemnly
sonly85718053_sonly
sorely94618013sore_ly
spangly1336473spangly
speedy1218410793speedy
speel74420763speel_
speels85116393speels
speil75618643speil_
speils84116223speils
spell75020303spe_ll
spells84617683spells
spelt75430193spe_lt
spence103813793spence
spend85619333spen_d
spends94714473spends
spense83912433spense
spent75532833spen_t
spindly13257383spindly
spinny114510183spinny
spiny104921303spin_y
spongy1236743spongy
spryly1435513spryly
spunky15427163spunky
steely93612573steely
sternly1037853sternly
teensy9478273teensy
teeny85417883teen_y
telly84920823_telly
tenty86121603_tenty
thegnly1442613thegnly
thinly1238673thinly
trebly1138973trebly
trendy10469603trendy
twenty1236223twenty
twopenny1641513twopenny
upend85011043upen_d
upends9438763upends
vainly1258503vainly
vealy115817773_vealy
vixenly2043193vixenly
wanly115118023_wanly
weekly1635313weekly
weensy12416823weensy
weeny115316163ween_y
welly114620013_welly
wenny114412463_wenny
wetly114511713_wetly
womanly1535853womanly
woodenly1544293woodenly

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.373479064.3
2DLD Change Limit1127162824.84323274.0
3Display Results2822820.0803525.0
 (SQL Overall)1786912825.29633740.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.