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

240 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
sheerly1333770(None) 
cheerly15417601cheerly
cheerily1655422cheerily
cheery144913152cheer_y
queerly1934232queerly
seely84522632s_ee_ly
seemly1138432s_eemly
sheeney13398932sheeney
sheeny124912192shee_ny
sheer84726892sheer__
sheered113515452sheered
sheerer103813842sheerer
sheers94322402sheer_s
shelly124414472sh_elly
sherry124510412sh_erry
sleekly14325182sleekly
sneery93610412sneer_y
soberly1236942soberly
steely93612572stee_ly
steeply1236292steeply
sweetly1335592sweetly
angerly1137773angerly
beery105220123_beer_y
bheesty1542493bheesty
cheaply1735023cheaply
cheekily2053473cheekily
cheeky18448613chee_ky
cheer105420383cheer__
cheered133713293cheered
cheerer123511753cheerer
cheerio12379313cheerio
cheerled14105703cheerled
cheero114712933cheer_o
cheeros123711633cheeros
cheers114518913cheer_s
cheesily1654413cheesily
cheesy14419193chee_sy
cherry144810763ch_erry
cherty144612473ch_erty
chiefly1834103chiefly
clearly1236663clearly
cleverly1643453cleverly
dearly104615323_dearly
deeply1257013_deeply
deerfly1443983_deerfly
eagerly1136053eagerly
early85324123__early
eely77725213__ee_ly
eerily92913563__eerily
eery76129623__eer_y
elderly1154943elderly
feebly1436653_feebly
ferly115517353__ferly
fleetly1336313fleetly
freely12310953free_ly
greenly11408183greenly
hearty126313633_hearty
heel75034223_hee_l_
heels85625533_hee_ls
henry114014473_henr_y
herby134715313_h_erby
hereby14468333_hereby
heresy125011233_heresy
herl75834553_h_erl_
herls85226433_h_erls
herry114922473_h_erry
hourly12369623_hourly
hurly115819293_h_urly
innerly1037133innerly
keenly1336373_keenly
leerily1037633_leerily
leery85919133_leer_y
loverly1346973loverly
meekly1535193_meekly
meetly1138673_meetly
merely111312583_merely
miserly12329823miserly
nearly94813733_nearly
orderly1135763orderly
overly122411363_overly
pearly116414843_pearly
peery105719443_peer_y
queenly1944463queenly
safely12249393safe_ly
sagely102811383sage_ly
sanely93114613sane_ly
scenery1236553scener_y
seedily1178583seedily
seedy94821533s_ee_dy
seel45042983s_ee_l_
seels55632823s_ee_ls
seepy104717973s_ee_py
seer45547043s_eer__
seers55136383s_eer_s
serry84824123s__erry
severely1445293severely
sexily1638853s_exily
shadfly1733783shadfly
shadily1437723shadily
shakily1736903shakily
shaly114322863sh__aly
shapely1536893shapely
sharny124711833sh_arny
sharply15406833sharply
sharpy145211033sh_arpy
sheal84927703sh_eal_
sheals94420643sh_eals
shear85424833shear__
sheared114516003sheared
shearer104414683shearer
shears93820903shear_s
sheen85023313shee__n
sheened113511703sheened
sheeneys14294903sheeneys
sheenie10159493sheenie
sheens95116993shee_ns
sheep105321523shee__p
sheerest11310083sheerest
sheering123715103sheering
sheerlegs1343293sheerlegs
sheesh1237813shee_sh
sheet84836963shee__t
sheeted113813043sheeted
sheeter103814913sheeter
sheets93918503shee_ts
sheeve123412843shee_ve
sheeves133911953sheeves
sheila969843sh_eila
shekel1338383shekel_
shekels1436043shekels
shelf115221113sh_e_lf
shell84424123sh_e_ll
shells94319523sh_ells
shelty124011553sh_elty
shelvy15377863sh_elvy
sheol84318373sh_eol_
sheols94614163sh_eols
sheqel1846523sheqel_
sheqels1934753sheqels
sherd96321153sh_er_d
sherds105614723sh_erds
shereef1337743shereef
sherif122915243sh_erif
sherpa1138093sh_erpa
sherris10168803sherris
shewer124515103shewer__
shewers134312043shewer_s
shiel811023773shie_l_
shield106212973shie_ld
shiels95418923shie_ls
shier85428943shier__
shiers94921753shier_s
shily115222013sh__ily
shingly143210813shingly
shinily13268933shinily
shirty124312563sh_irty
shivery16317023shiver_y
shoaly124010773sh_oaly
shoer84722163shoer__
shoers94518333shoer_s
shoofly1634353shoofly
shorl84720253sh_orl_
shorls94516203sh_orls
shortly13387573shortly
shorty124313203sh_orty
showery16437243shower_y
showily1636223showily
shrewdly1842523shrewdly
shrilly13318563shrilly
shtetl936443shtetl_
shtetls1034583shtetls
shyer114714783shyer__
shyers124712203shyer_s
shyly144811573sh__yly
sickerly1734033sickerly
silverly14284313silverly
sisterly1146333sisterly
skerry13356103s_kerry
sleeky13398963slee_ky
sleepily1344823sleepily
sleepy11479413slee_py
sleety94112653slee_ty
slenderly1343453slenderly
smeary114110803smear_y
smelly114110363s_melly
snarly93815003s_narly
sneer54919953sneer__
sneered83113973sneered
sneerer73512313sneerer
sneers64016173sneer_s
sneezy18345273snee_zy
solely93714213sole_ly
somberly1544053somberly
sorely94618013sore_ly
sourly93612213s_ourly
sparely123410673sparely
speedily1465173speedily
speedy1218410783spee_dy
speel74420763spee_l_
speels85116393spee_ls
speer74623903speer__
speered103614813speered
speers85019953speer_s
sphery14318883spher_y
steel55721993stee_l_
steels64117983stee_ls
steeple937323steeple
steer55423863steer__
steered83615253steered
steerer73113633steerer
steers63820983steer_s
sternly1037853sternly
summerly15275103summerly
superbly1546983superbly
superlay1347753superlay
surely93816463sure_ly
surly85124433s__urly
sweeney13387003sweeney
sweeny12358843swee_ny
sweepy14447453swee_py
sweer84918573sweer__
swirly12439253s_wirly
synergy1442943synergy
thegnly1442613thegnly
theory121098363theor_y
thereby1534633thereby
theurgy1442733theurgy
utterly1035443utterly
veery115816253_veer_y
weekly1635313_weekly
wheedle1434823wheedle
wheel115515333whee_l_
wheels123811713whee_ls
wheeple1534853wheeple
wheezily2642303wheezily
wheezy24244523whee_zy
whereby1842913whereby
wherry15477333wh_erry
whirly15448863wh_irly
yearly125210273_yearly

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.1561145455.1
2DLD Change Limit1340272407.31318327.2
3Display Results2402400.0763157.9
 (SQL Overall)1786912407.54523683.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.