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

243 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
sunnily103783(None) 
funnily1336371funnily
bonnily1236872bonnily
cannily1239262cannily
funkily1736512funkily
punily11311772pu_nily
shinily13268932shinily
spunkily1733772spunkily
stonily1049432stonily
sulkily14218112sulkily
sundrily1246052sundrily
sunnier73412152sunnier
sunning83715672sunning
sunny84917742sunn__y
surlily1039992surlily
tinnily1047362tinnily
auntly95211063au_ntly
bouncily1544383bouncily
bulkily16227123bulkily
bumpily1665653bumpily
bunchily1844543bunchily
bunnies94415003bunnies
bunny104715803bunn__y
burlily1237713burlily
bushily15268893bushily
busily112211503bu_sily
chunkily2043083chunkily
cornily12410853cornily
cunning104214623cunning
cunningly1545533cunningly
curlily1238383curlily
cushily15257923cushily
dandily12279633dandily
dingily1238103dingily
dumpily1566233dumpily
dunning93514473dunning
dunnite857333dunnite
duskily15236743duskily
dustily113211523dustily
fancily1538253fancily
fuggily1534963fuggily
funnel93610743funnel_
funnels10348173funnels
funnier103210163funnier
funnies104113603funnies
funning113813613funning
funny114614833funn__y
furrily1337603furrily
fussily13267603fussily
fustily133111373fustily
fuzzily2145073fuzzily
gunnel73411053gunnel_
gunnels8358563gunnels
gunnery11376373gunnery
gunnies83413123gunnies
gunning93413173gunning
gunny94413663gunn__y
gushily14257823gushily
gustily113010903gustily
gutsily11267223gutsily
handily143610873handily
hornily1338283hornily
huffily1934693huffily
hungrily1563053hungrily
hunnish1336163hunnish
huskily17236333huskily
jauntily1834173jauntily
juicily1935493juicily
jumpily2174983jumpily
jungly17407693ju_ngly
kinkily1335223kinkily
lankily1437123lankily
loonily1037073loonily
luckily16297083luckily
lumpily1476563lumpily
lustily103611243lustily
mangily1339753mangily
manlily1238743manlily
moonily1248943moonily
muckily18277743muckily
muddily1435963muddily
muggily1435103muggily
munnion935863munnion
murkily16287113murkily
mushily152410093mushily
muskily16289043muskily
mussily12279773mussily
mustily123613633mustily
muzzily2045023muzzily
noily86120993__noily
nonoily1049543nonoily
nunnery10355303nunnery
nunnish1035933nunnish
nuttily10308633nuttily
phonily1537103phonily
pudgily1434903pudgily
puffily1834843puffily
pulpily1436103pulpily
punchily1844863punchily
punnier93511263punnier
punning103414993punning
punningly1545153punningly
punny104217713punn__y
pursily1238213pursily
pushily15247983pushily
quakily2336693quakily
rainily10310433rainily
ruddily1236303ruddily
runnel63510663runnel_
runnels7329153runnels
runnier74010113runnier
running83514593running
runny84613483runn__y
rustily103112993rustily
ruttily10338613ruttily
saintly1039343saintly
saltily10310543saltily
sandfly1435643sandfly
sanely93114613s_anely
sanity9316203s_anity
sappily1437163sappily
sassily1038723sassily
saucily1237913saucily
savvily1634323savvily
scantily1337583scantily
scantly12419553scantly
scarily12311703scarily
scummily1743303scummily
scurvily1643773scurvily
seedily1178583seedily
senile63420213s_enile
sennit63117923senni_t
sennits73811283sennits
sensibly1345593sensibly
sexily1638853s_exily
shadily1437723shadily
shakily1736903shakily
shily115222013s__hily
shingly143210803shingly
showily1636213showily
shunning12367843shunning
signify1444853signify
silkily14236963silkily
sillily10209783sillily
singly104015853s_ingly
sinning83918443sinning
slangily1235383slangily
slantly10399323slantly
slily85820033s__lily
slimily1247713slimily
slinkily1534853slinkily
slushily1445013slushily
smokily1635373smokily
smudgily1543123smudgily
smuttily1344273smuttily
snail57020203s_nail_
snails64816653s_nails
snakily1436913snakily
snarly93815003s_narly
snowily1336883snowily
snuffily17124313snuffily
snuffly16305193snuffly
snugly1055663s_nugly
soapily1237963soapily
soggily1235953soggily
sonly85718053s_on_ly
sonnies7315223sonnies
sonny85016103sonn__y
sootily101810513sootily
sorrily1039823sorrily
soundly1136683soundly
spangly1336473spangly
spicily1438653spicily
spikily1635873spikily
spindly13257383spindly
spongily1444903spongily
spoonily1335233spoonily
stagily1139053stagily
stingily1236793stingily
stubbily1564243stubbily
stuffily17124163stuffily
stunning9298463stunning
stunningly1443173stunningly
sturdily1245073sturdily
suably112814533su_ably
suavely1376483suavely
suavity1336313suavity
subfile122010503subfile
subsidy1345973subsidy
subtile91912613subtile
subtilty1345453subtilty
subtly11249263su_btly
sully84622893su__lly
sultrily1146483sultrily
sunbelt939233sunbelt
sunbird1044743sunbird
sundial859863sundial
sundials946753sundials
sundry1057943su_ndry
sunfish1338883sunfish
sunlike112310573sunlike
sunlit61516103sunli_t
sunn45423593sunn___
sunna55016063sunn__a
sunnah9369353sunn_ah
sunnahs10326593sunnahs
sunnas63914563sunn_as
sunned74216323sunn_ed
sunniest82712903sunniest
sunns55017353sunn__s
sunray9310123su_nray
sunrise7310813sunrise
sunshiny1445253sunshiny
sunwise1036433sunwise
supinely1376283supinely
supply1346893su_pply
surely93816453su_rely
surly85124423su__rly
swankily1833833swankily
tawnily1335443tawnily
tinily94014433_tinily
tuftily1335573tuftily
tunably12218293tunably
tunnel64310633tunnel_
tunnels7328723tunnels
tunnies73614263tunnies
tunning83514453tunning
tunny86515033tunn__y
uglily1036193_uglily
unduly1037823_unduly
unfitly1335573_unfitly
unholy1238163_unholy
unify113611113_u_nify
unity84918493_u_nity
unnail6410583_unnail_
unnails738223_unnails
unnoisy1044243_unnoisy
unpile81914323_unpile
unruly938083_unruly
untidy1059153_untidy
until53517743_until_
windily1437943windily
zanily18310183_zanily

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 Limit1340272437.51617832.2
3Display Results2432430.0932612.9
 (SQL Overall)1786912437.76523012.4
 
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.