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

254 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
lewdly133439(None) 
deadly113811472deadly
dewily1338342dewily
leady95618602lead_y
leally94012612leally
leanly93811502leanly
ledgy105712012le_dgy
lewd85716592lewd__
lewder10479612lewder
lordly1038752lordly
loudly1037782loudly
lowly114113332low_ly
newly114610202new_ly
redly94217192re_dly
acidly125211793acidly
aerily93017013aerily
agedly1136463agedly
alertly1046793alertly
aridly105513703aridly
avidly13548783avidly
badly114918763_badly
baldly12479833baldly
bawdily1635803bawdily
bawdry15516463bawdry
bawdy147513283bawd_y
beadily1378843beadily
beadle93314683beadle
beady114719923bead_y
belly104625493be_lly
benday123810813benday
bendy115017253bend_y
bewray14147733bewray
blandly1336043blandly
bleakly1634663bleakly
blindly1335743blindly
blowfly1843243blowfly
boldly12399423boldly
cleanly1236323cleanly
clearly1236663clearly
clerkly1643573clerkly
coldly12459953coldly
cowedly1635693cowedly
cuddly13388413cuddly
dawdle11399503dawdle
deafly13389123deafly
dearly104615323dearly
deedy104315893deed_y
deeply1257013deeply
deftly1336533deftly
delly96023873de_lly
dewy115419023dew__y
diddly12389573diddly
dowdily1534953dowdily
dowdy136112543dowd_y
early85324123_early
eddy93912093_e_ddy
edgy94713523_e_dgy
eely77725213_e_ely
eerily92913563eerily
featly123711753featly
feckly18335963feckly
feebly1436653feebly
felly114922803fe_lly
ferly115517353fe_rly
fetidly1435013fetidly
feyly14429513fe_yly
fiddly14328483fiddly
fledgy14414913fle_dgy
fleetly1336313fleetly
fleshly16346093fleshly
fluidly1434813fluidly
fondly13299043fondly
gelidly1234743gelidly
gently103710913gently
gladly11497933gladly
glegly1134873gle_gly
glowfly1742673glowfly
godly104913293_godly
goodly11419303goodly
hardly135112833hardly
headily1478623headily
heady125117263head_y
heddle114211163heddle
hedgy134510743he_dgy
heyday1635143heyday
heydey1634633heydey
howdy155711413howd_y
idly85617323__idly
jelly154218253je_lly
jewel156711703jewel_
jewelry2041993jewelry
jewels16508613jewels
jowly186410903jow_ly
keenly1336373keenly
kelly124617023ke_lly
kindly14358843kindly
lacily11612763lacily
ladle66320443l_adle
lady86527153l_ad_y
lairdly1134913lairdly
lamely114013223lamely
lanely93914483lanely
lankly13439623lankly
lardy96119273lard_y
lastly93310873lastly
lately93413843lately
lawny115912013law_ny
laxly15610103l_axly
lazily1859713lazily
leachy14419733leachy
lead56038853lead__
leaded84221543leaded
leaden74515223leaden
leadenly1244733leadenly
leader74824653leader
leads66028493lead_s
leafy116316213le_afy
leakily1436473leakily
leaky125217723le_aky
leal46043273le_al_
lealty92910603lealty
leary85927383le_ary
leavy115715773le_avy
led46254553le_d__
ledge76519463le_dge
leerily1037633leerily
leery85919133le_ery
leewardly16102093leewardly
leeway1255883leeway
lefty115613563le_fty
legacy1256653legacy
legal65715943legal_
legally1138133legally
legals73412733legals
leggy105210243le_ggy
legibly1344623legibly
lemony11419553lemony
lend56233673lend__
lender73921273lender
lends65326253lend_s
lenity9612713lenity
leud57223423leud__
leudes75314093leudes
leuds66214813leud_s
level84116553level_
levelly1335843levelly
levels94113283levels
levity1277903levity
levy106418503le__vy
lewdest1136283lewdest
lewis85315843lew_is
ley66246813le___y
lezzy16608083le_zzy
liefly1266363liefly
likely13328133likely
lily76730183l__ily
limply133810033limply
lindy96918313lind_y
lively123310813lively
lividly1434783lividly
logily1039833logily
lolly85120663l_olly
lonely92912463lonely
longly10279603longly
lovely12339713lovely
lowboy1435903lowboy
lowery124112703lowery
lowlily1335353lowlily
lucidly13125213lucidly
luridly1196283luridly
lushly12247343lushly
madly115218133_madly
mealy104422183me_aly
meanly115412043meanly
measly113610443measly
meddle103312763meddle
medfly1535223medfly
medley1298333me_dley
meekly1535193meekly
meetly1138673meetly
merely111312583merely
mewl95618323mew_l_
mewls105813233mew_ls
mildly12318243mildly
muddly13418603muddly
nearly94813733nearly
neatly93812483neatly
nebuly1135793nebuly
neddy10479873ne_ddy
needily1166323needily
needle73310613needle
needy94614693need_y
nelly84618813ne_lly
nerdy95014703nerd_y
nettly9459453nettly
newel86114133newel_
newels93710823newels
newsy11489393new_sy
oddly1037163_oddly
pearly116414843pearly
pebbly1545083pebbly
peddle103512823peddle
perdy115417323perd_y
pertly115312543pertly
piddly13319143piddly
puddly13438133puddly
rawly115115833raw_ly
readily11711403readily
ready94821503read_y
really93315613really
reddle83815913reddle
redry94314363re_dry
reedily1179603reedily
reedy910020283reed_y
refly113914563re_fly
rely75428953re__ly
reply104015853re_ply
reweld103711113reweld
rowdily1436083rowdily
rowdy125711533rowd_y
sadly94519123_sadly
sawfly1535133sawfly
sedgy104512783se_dgy
seedily1178583seedily
seedy94821533seed_y
seely84522633se_ely
seemly1138433seemly
sexily1638853sexily
shrewdly1842513shrewdly
sleekly14325183sleekly
slowly1237153slow_ly
studly10397693studly
tawdry13395253tawdry
teddy10489493te_ddy
telly84920823te_lly
tepidly1334403tepidly
termly1138433termly
tiddly11308783tiddly
vealy115817773ve_aly
verily122616053verily
vexedly2143443vexedly
waddly14478723waddly
waly105830903__waly
weakly1636483weakly
wedgy13479793we_dgy
weedily1476123weedily
weedy125115003weed_y
weekly1635313weekly
weirdly14274493weirdly
welly114620013we_lly
wetly114511713we_tly
wildly13328123wildly
wily106428813__wily
yearly125210273yearly

Search took 10 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 Limit1127162548.66013015.7
3Display Results2542540.1861365.6
 (SQL Overall)1786912548.98619885.5
 
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.