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

274 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
starkly1427703(None) 
sparkly16348131sparkly
darkly145411072_darkly
sarky125521782s_ark_y
scarily12311702scarily
sharply15406832sharply
slackly1635262slackly
smartly12497432smartly
snarkily1534582snarkily
snarky134210842snark_y
snarly93815002snar_ly
sparely123410672sparely
sparkily1735022sparkily
sparkle133710212sparkle
sparky154511522spark_y
stably113314122sta_bly
stagily1139052stagily
staidly1136682staidly
stalely1039212stalely
stalkily1534822stalkily
stalky13499302stalk_y
starchy15286742starchy
stark95425622stark__
starker114114692starker
starry94911672star_ry
startle72511122startle
startsy10536702startsy
stately10310222stately
sternly1037852sternly
tartly96014022_tartly
asparkle1443843asparkle
astrally1148883astrally
ataraxy1743983ataraxy
autarky1444703autark_y
barely114716793_barely
barfly14339653_barfly
barky145721613_bark_y
bastardly15264293bastardly
blackly1835253blackly
blankly1634263blankly
charily15310283charily
clerkly1643573clerkly
crackly18397703crackly
crankly16358123crankly
dankly14419463_dankly
darkey145212423_darkey
darkle113813943_darkle
darky136018833_dark_y
dastardly14273803dastardly
dearly104615323dear_ly
dotardly1343843dotardly
early85324123_ear_ly
frankly17315633frankly
gnarly104610383gnar_ly
hackly18298733_hackly
hardly135112833_hardly
hoarily1338973hoarily
lankly13439623_lankly
larky125218873_lark_y
marbly134111933_marbly
marly106925613_mar_ly
murkly15368303_murkly
narky126017803_nark_y
nearly94813733near_ly
packly17228333_packly
partly116315473_partly
pearly116414843pear_ly
peartly1267453peartly
rankly133910453_rankly
rarely93513653_rarely
sadly94519123s_a_dly
safely12249393s_afely
sagely102811383s_agely
sally85129713s_a_lly
sanely93114613s_anely
sark84938973s_ark__
sarks96632463s_ark_s
satrapy12497933satrapy
sawfly1535133s_awfly
scaly104718723sca__ly
scantly12419553scantly
scarcely1534313scarcely
scarey115016983scar_ey
scarify1537443scarify
scarry116311183scar_ry
scary105222593scar__y
scrawly15197183scrawly
shackle16409543shackle
shadfly1733783shadfly
shadily1437723shadily
shakily1736903shakily
shaky154616843sha_k_y
shaly114322863sha__ly
shapely1536893shapely
shark126225023shark__
sharked153613913sharked
sharker144313813sharker
sharks135019723shark_s
sharny124711833shar_ny
sharpy145211033shar_py
shortly13387573shortly
sickly153110483s_ickly
skanky12476963skank_y
slantly10399323slantly
sleekly14325183sleekly
slickly1635853slickly
smarmily1543523smarmily
smarmy13629353smar_my
smarty115013793smar_ty
smirkily1753333smirkily
smirky15406943smirk_y
snakey135011273sna_key
snakily1436913snakily
snaky125113913sna_k_y
snark95419943snark__
snarks104815733snark_s
snarl54921083snar_l_
snarls64016873snar_ls
soapily1237963soapily
sorely94618013s_orely
sorrily1039833sorrily
sourly93612213sour_ly
spackle15369573spackle
spangly1336473spangly
spark114920893spark__
sparked143513143sparked
sparker133914363sparker
sparkled15317733sparkled
sparkler14317983sparkler
sparkles143210493sparkles
sparklet143110593sparklet
sparks124616363spark_s
sparry115111303spar_ry
sparsely1335123sparsely
sprawly15166043sprawly
spryly1435513s_pryly
squarely2045353squarely
stabile9312063stabile
stable83921643sta_ble
stack114421693stack__
stacked143416123stacked
stacker134416263stacker
stacks124317263stack_s
stackup1533743stackup
staddle9288093staddle
stagey105915583sta_gey
staggy115510393sta_ggy
stagy96618893sta__gy
stairway1462923stairway
stake95927533sta_k_e
staked114621943sta_ked
stakes103927293sta_kes
stale55637103sta__le
stalk94518003sta__lk
stalked123811173stalked
stalker113912253stalker
stalks104614553stalk_s
stall54722353sta__ll
stalls64019933sta_lls
stanchly1644443stanchly
standby1334423standby
stank95823303stank__
stanks104917703stank_s
stanol6310723stanol_
stanols739733stanols
staple84415823sta_ple
star48037763star___
starch113013203star_ch
starchily1745013starchily
stardom1037763stardom
stare54440263star__e
stared75429873star_ed
starer64027363star_er
starers74522313starers
stares66038753star_es
starets73515923starets
staring84527053staring
staringly1337973staringly
starkers123712393starkers
starkest1239723starkest
starlet71620123starlet
starlit71512913starlit
starred85013453starred
stars55836573star__s
start55642313star__t
started84217323started
starter73817883starter
startled9208563startled
startler8248793startler
startles82111963startles
starts65423123star_ts
startup934963startup
starve94613743star_ve
starved114911573starved
starver104611993starver
starves104614553starves
statal61613223statal_
statedly1245833statedly
statusy10455423statusy
stay78333723sta___y
steadily1236213steadily
steamily1335803steamily
steely93612573st_eely
steeply1236293steeply
sterile7316603sterile
sterol6613333sterol_
sterols7313443sterols
stickily1736083stickily
stickle132410973stickle
sticky154711343stick_y
stiffly16235173stiffly
stilly93714093st_illy
stinky134611073stink_y
stirk95717413stirk__
stirks104914243stirk_s
stockily1735443stockily
stocky15369153stock_y
stonily1049433stonily
storey95217613stor_ey
stork96819693stork__
storks106115953stork_s
stormily1345243stormily
stormy115510733stor_my
story86723033stor__y
stoutly1035833stoutly
straggly13355563straggly
straitly1136563straitly
strake104017393strak_e
straked125415343straked
strakes114218073strakes
strappy14205263strappy
strawy1210312823st_rawy
stray88525573st_r_ay
stripy115812743st_ripy
stroll6311603st_roll
stroy87720393st_r_oy
stubbly1444473stubbly
studly10397693st_udly
sturdily1245083sturdily
sturdy1037043stur_dy
suably112814533sua_bly
suavely1376493suavely
surely93816463s_urely
surly85124433s_ur_ly
swankily1833833swankily
swanky16447973swank_y
swarthy16466373swarthy
swarty125812383swar_ty
swirly12439253swir_ly
tackey154613083_tackey
tackily1637503_tackily
tackle123815733_tackle
tacky145617443_tack_y
talky126215683_talk_y
tally84526863_ta_lly
tamely113711953_tamely
tangly104413913_tangly
tardily11269583_tardily
tardy94720463_tar_dy
tarry85422513_tar_ry
tartily103511573_tartily
tarty86328183_tar_ty
tautly9499503_tautly
tearily10311153tearily
termly1138433_termly
tinkly134811153_tinkly
truly84111553_t_ruly
turkey1337763_turkey
warily122915093_warily
warmly14228063_warmly
weakly1636483wea_kly
wearily1338783wearily
yarely122810303_yarely
yearly125210273year_ly

Search took 7 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 Limit1340272746.56320421.6
3Display Results2742740.0932946.2
 (SQL Overall)1786912746.80926243.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.