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

253 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
shapely153689(None) 
chapel134911372chapel_
chapels14429152chapels
haply135915062_hap_ly
safely12249392s_afely
sagely102811382s_agely
sanely93114612s_anely
shadfly1733782shadfly
shadily1437722shadily
shakily1736902shakily
shaley123714992shale_y
shaly114322862sha__ly
shape105125112shape__
shaped125020102shape_d
shapen114414652shape_n
shaper114119932shape_r
shapers124016892shapers
shapes115124942shape_s
shapeup1443292shapeup
sharply15406832sharply
soapily1237962soapily
sparely123410672sparely
stalely1039212stalely
stately10310222stately
suavely1376492suavely
unshapely1742822unshapely
apery106517903__apery
apply125111393__apply
aptly105111813__aptly
ashamedly1842273ashamedly
barely114716793_barely
basely114412313_basely
bravely15428233bravely
chally144314293cha_lly
chape125221143chape__
chapeau1435523chapeau
chapes135421873chape_s
chaplet14512253chaplet
charily15310283charily
charley15118273charley
chastely1635813chastely
cheaply1735023cheap_ly
drapery13387943drapery
drapey125010583drape_y
gamely124711913_gamely
ghastly14354563ghastly
grapery13457953grapery
grapey126012303grape_y
gravely14469063gravely
hackly18298733_hackly
happily1745763_happily
happy155813533_hap_py
hardly135112833_hardly
hayey144812533_haye_y
hazel176414813_hazel_
hazelly2254383_hazelly
hazels185710083_hazels
hazily2179063_hazily
hiply134113613_hip_ly
homely145313173_homely
hugely1336803_hugely
inanely1037943inanely
inaptly1244413inaptly
irately1047683irately
japery18439143_japery
lamely114013223_lamely
lanely93914483_lanely
lapel73716683_lapel_
lapels83712043_lapels
lately93413843_lately
namely113711323_namely
napery11489813_napery
ovately1334433ovately
palely11311923_palely
papery134812743_papery
raptly11338913_raptly
rarely93513653_rarely
reapply1434323reapply
ripely112511153_ripely
sadly94519123s_a_dly
safety12206913s_afety
sally85129713s_a_lly
sappily1437163sappily
sappy125413473s_ap_py
savagely1543343savagely
saveloy1334663s_aveloy
sawfly1535133s_awfly
scalpel11377713scalpel_
scalpels12345883scalpels
scaly104718723sca__ly
scantly12419553scantly
scape96921843scape__
scaped115519553scape_d
scapes105122263scape_s
scapula1136343scapula
scarcely1534313scarcely
scarey115016983scare_y
scarily12311703scarily
sealery104011053sealery
sedately1245223sedately
seely84522633s__eely
shabbily1873903shabbily
shabby1635803sha_bby
shackle16409543shackle
shade95125583shade__
shaded114518873shade_d
shader104218763shade_r
shaders115915553shaders
shades105924533shade_s
shadowy1744723shadowy
shady125416513sha__dy
shaggily1643773shaggily
shaggy14478043sha_ggy
shake124726403shake__
shaken134113613shake_n
shaker134319463shake_r
shakers144015563shakers
shakes135024593shake_s
shakeup1632763shakeup
shaky154616843sha__ky
shale85332833sha__le
shaled105023953shale_d
shales94731253shale_s
shall85024053sha__ll
shalt85534493sha__lt
shamably18165803shamably
shamble14149263shamble
shame105726703shame__
shameably1943873shameably
shamed125120213shame_d
shames114726223shame_s
shammy16388503sha_mmy
shamoy14379913sha_moy
shandy134710033sha_ndy
shanny124110093sha_nny
shantey134210043shantey
shanty124715123sha_nty
shapable15197803shapable
shapeable1645743shapeable
shapeless1435563shapeless
shapelier1444463shapelier
shapeups1542723shapeups
shaping133116183shaping
share86437083share__
shared105829063share_d
sharer95025483share_r
sharers104720623sharers
shares95236413share_s
sharny124711833sha_rny
sharped134112053sharpe_d
sharpen12389723sharpe_n
sharpens13377813sharpens
sharper124312703sharpe_r
sharpers133810943sharpers
sharpest1339143sharpest
sharpy145211033sha_rpy
shaul85418103sha_ul_
shauled1148793shauled
shauls94913113sha_uls
shave114425893shave__
shaved135118383shave_d
shaven124213303shave_n
shaver123718913shave_r
shavers134115093shavers
shaves125224933shave_s
shawed134817233shawe_d
shawl116217573sha_wl_
shawled1437773shawled
shawls125411973sha_wls
shay107133343sha___y
sheeny124912193sh_eeny
sheerly13337703sheerly
shekel1338383shekel_
shekels1436043shekels
shelf115221113sh__elf
shell84424123sh__ell
shelly124414473sh_elly
shelty124011553sh__elty
shelvy15377863sh__elvy
sheqel1846523sheqel_
sheqels1934753sheqels
shiel811023773sh_iel_
shield106212973sh_ield
shiels95418923sh_iels
shily115222013sh__ily
shingly143210813shingly
shinily13268933shinily
shipway1844213shipway
shivery16317023shivery
shoaly124010773sh_oaly
shoofly1634353shoofly
shopboy1743803shopboy
shortly13387573shortly
shovel124611323shovel_
shovels13378393shovels
showery16437243showery
showily1636223showily
shrapnel1342133shrapnel_
shrieky17364803shrieky
shrilly13318563shrilly
shyly144811573sh__yly
simply133010523simp_ly
slackly1635263slackly
slantly10399323slantly
slatey95417063slate_y
slavery13407893slavery
slavey124011803slave_y
smartly12497433smartly
snakey135011273snake_y
snakily1436913snakily
snappily1544323snappily
snappy1366103snap_py
snarly93815003sna_rly
snidely1136813snidely
soaped95817973soape_d
soaper84517873soape_r
soapers93715923soapers
soapy106114783soap__y
solely93714213s_olely
sorely94618013s_orely
spacey136212533space_y
spangly1336473spangly
sparkly16348133sparkly
sparsely1335123sparsely
spell75020303s__pell
spelt75430193s__pelt
squarely2045353squarely
stably113314123sta_bly
stagey105915583stage_y
stagily1139053stagily
staidly1136683staidly
stapelia1044673stapelia
stapes85028733stape_s
staple84415823stap_le
stapled103613703stapled
stapler93913633stapler
staples93617213staples
starkly14277033starkly
statedly1245833statedly
steely93612573s_teely
steeply1236293steeply
stipel84412123stipel_
stipels9418953stipels
stupefy1542903stupefy
suably112814533sua_bly
supplely1543053supplely
supply1346893s_upply
surely93816463s_urely
tamely113711953_tamely
unaptly1244793unaptly
weasely13317853weasely
whitely16346473whitely
yarely122810303_yarely

Search took 8 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 Filter1786911340270.1531167915.0
2DLD Change Limit1340272537.01619103.1
3Display Results2532530.0803162.5
 (SQL Overall)1786912537.24924650.4
 
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.