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

279 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
spryly143551(None) 
dryly12538452_dryly
shyly144811572s_hyly
slyly11489532s_lyly
sorely94618002sorely
sparely123410662sparely
sparkly16348122sparkly
sprawly15166042sprawly
spray106720062spr_ay
sprucy13356322sprucy
spry96819122spr__y
spryer11418532spryer
surely93816452surely
surly85124422sur_ly
wryly14356702_wryly
aerily93017013aerily
airily93014823airily
aphylly1843353aphylly
apply125111393ap_ply
aptly105111813ap_tly
aryl75922343_aryl_
aryls87015813_aryls
asphyxy2541383asphyxy
barely114716793barely
barfly14339653barfly
beryl101211673beryl_
beryls11107883beryls
burbly134311153burbly
burly104922833bur_ly
coyly135614893_coyly
curly105321233cur_ly
curtly1149283curtly
darkly145411073darkly
direly10311553direly
doyly124514013_doyly
drily95816523_drily
early85324123ear_ly
eerily92913563eerily
ferly115517353fer_ly
feyly14429513_feyly
firmly1436663firmly
gayly124513093_gayly
girly94415293gir_ly
gorily10612503gorily
grayly13287963grayly
greyly13316543greyly
hardly135112833hardly
hurly115819293hur_ly
lordly1038753lordly
marbly134111933marbly
marly106925613mar_ly
merely111312583merely
murkly15368303murkly
openly1137123openly
osprey1134883ospr_ey
pally105727123_pally
paly95835533_p_aly
partly116315473partly
patly105020583_patly
pertly115312543pertly
phyla13469183_phyla
phyle134111153_phyle
pily96132733_p_ily
ply86323553_p__ly
poly96235153_p_oly
portly114713403portly
pray96331533_pr_ay
prexy174611573_prexy
prey96228483_pr_ey
pricy124814563_pricy
prill74117943_prill
primly13439623_primly
privy13439833_privy
prole74527793_prole
prosy106319253_prosy
proxy175011013_proxy
pry85728053_pr__y
pryer104415313_pryer
purely114013613purely
purply13369043purply
rarely93513653rarely
rely75428953__rely
ruly76323143__ruly
sadly94519123s_adly
safely12249393safely
sagely102811383sagely
sally85129713s_ally
sanely93114613sanely
sappily1437163sappily
sarky125521783sar_ky
sawfly1535133sawfly
scaly104718723s_caly
scarily12311703scarily
scrawly15197183scrawly
screwy14659453screwy
scroll8310163scroll
scry96017763scr__y
seely84522633s_eely
seemly1138433seemly
seral56336383seral_
serry84824123ser_ry
sexily1638853sexily
shaly114322863s_haly
sharply15406833sharply
shelly124414463shelly
shily115222013s_hily
shoaly124010763shoaly
shortly13387563shortly
shrill94712303shrill
shrilly13318553shrilly
sibyl1037113sibyl_
sibyls1135303sibyls
sickly153110483sickly
silly84527613s_illy
simply133010523simply
singly104015853singly
sirupy11377053sirupy
skyey15537223s_kyey
slily85820033s_lily
slimly11408903slimly
slowly1237153slowly
sly66228563s___ly
smartly12497433smartly
smelly114110353smelly
smugly1274833smugly
snarly93815003snarly
snugly1055663snugly
softly12457763softly
solely93714213solely
sonly85718053s_only
sorel56231443sorel_
sorels63921163sorels
sorrily1039823sorrily
sorry84618253sor_ry
sourly93612203sourly
spacey136212533spacey
spacy125415623sp_acy
spail74921553spail_
spails84817823spails
spale74929213sp_ale
spall74919303sp_all
spalls84217343spalls
spangly1336473spangly
sparkily1735013sparkily
sparkle133710203sparkle
sparky154511523sparky
sparry115111303sparry
sparsely1335113sparsely
spay96631663sp__ay
spayed124213613spayed
spays105520513spay_s
speedy1218410783speedy
speel74420763speel_
speels85116393speels
speil75618643speil_
speils84116223speils
spell75020303sp_ell
spells84617683spells
spelt75430193sp_elt
spendy124911143spendy
sphery14318883sphery
sphynx2152613sphynx
spicey134414233spicey
spicily1438653spicily
spicy125417713sp_icy
spiel74623913spiel_
spiels85317953spiels
spiffy17326223spiffy
spikey155411333spikey
spikily1635873spikily
spiky146014113sp_iky
spile75230083sp_ile
spill74821163sp_ill
spills84717453spills
spilt75532223sp_ilt
spindly13257383spindly
spinny114510183spinny
spiny104921303sp_iny
spiral83715343spiral_
spirally1348013spirally
spirals93212513spirals
spirula9257703spirula
spiry105017353sp_iry
spivvy1733213spivvy
splay105816043sp_lay
spoil75818643spoil_
spoils84614533spoils
spoilt85016593spoilt
spongy1236743spongy
spoofy14498553spoofy
spooky15418093spooky
spool75219043spool_
spools85115913spools
spoony114111793spoony
sporal82915453sporal_
sportily1337733sportily
sporty115112493sporty
sporule937273sporule
spotty11448573spotty
sprag86418693spr_ag
sprags95715823sprags
sprain83614863sprain
sprang95713523sprang
sprat76635973spr_at
sprats85819933sprats
sprawl11188063sprawl
sprawls12176373sprawls
sprayed13398903sprayed
sprayer12369043sprayer
sprays115913643sprays
spread9312533spread
spree74830863spr_ee
sprees85620643sprees
sprent84522383sprent
sprier84119063sprier
sprig85617743spr_ig
spriggy14374213spriggy
sprigs94814773sprigs
spring94526013spring
springy13359663springy
sprint84526793sprint
sprit76736403spr_it
sprite84421773sprite
sprits85122533sprits
spritz174714413spritz
sprout8419403sprout
spruce103910873spruce
sprucely1543123sprucely
sprue74717633spr_ue
sprues84515763sprues
sprug85313893spr_ug
sprugs94010173sprugs
sprung94610033sprung
spryest12247813spryest
spumy124610363sp_umy
spunky15427163spunky
spurrey12307803spurrey
spurry11429113spurry
spurtle937453spurtle
spy86023743sp___y
stably113314123stably
starkly14277033starkly
steely93612573steely
sternly1037853sternly
stilly93714073stilly
strawy1210312823strawy
stray88525573str_ay
stripy115812743stripy
stroll6311603stroll
stroy87720393str_oy
studly10397693studly
style85519363s_tyle
styli83911173s_tyli
stymy13358293s_tymy
suably112814533suably
subtly11249263subtly
sully84622893s_ully
superbly1546973superbly
supply1346893supply
sural55931263sural_
surety93515003surety
surfy115319473sur_fy
surgy95118523sur_gy
surlily1039993surlily
surrey94414573surrey
survey124111663survey
swirly12439243swirly
syli74318983s__yli
syrupy14285823syrupy
syzygy2141113syzygy
tartly96014023tartly
termly1138433termly
truly84111553_truly
unruly938083unruly
verily122616053verily
warily122915093warily
warmly14228063warmly
wirily123310783wirily
yarely122810303yarely

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162796.01318745.4
3Display Results2792790.0962906.3
 (SQL Overall)1786912796.26528522.1
 
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.