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

204 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
spunkies1422759(None) 
punkies134216801_punkies
spunkie13215301spunkie_
spunkier14235821spunkier
spunkiest15166561spunkiest
flunkies1536392flunkies
hunkies143214502_hunkies
junkies183711692_junkies
pinkies133818262_pinkies
punkie123513612_punkie_
punkier133512792_punkier
punkiest149312662_punkiest
punkins133111112_punkins
punties94520782_punties
skunkier11174282skunkier
skunkiest12135092skunkiest
spinnies103210542spinnies
spunked14307782spunk_ed
spunkily1733772spunkily
spunkiness1644172spunkiness
spunking15258062spunking
spunks12349332spunk__s
spurries102311322spurries
sulkies114315762s_ulkies
aunties73920073_aunties
bounties10311403bounties
bunnies94415003_bunnies
chuckies1937703chuckies
chunkier17395883chunkier
chunkiest1835263chunkiest
clunkier14345793clunkier
clunkiest1535163clunkiest
counties10316283counties
dinkies123716033_dinkies
duckies143613813_duckies
flunkie1434513flunkie_
funkias1435383_funkias
funkier14349983_funkier
funkiest152810973_funkiest
funnies104113603_funnies
gunkier12369553_gunkier
gunkiest132610573_gunkiest
gunnies83413123_gunnies
hankies143617763_hankies
honkies143015143_honkies
hunkie133812383_hunkie_
hunkier144512143_hunkier
hunkiest153812333_hunkiest
huskies143212083_huskies
junkie17339603_junkie_
junkier18339493_junkier
junkiest192610173_junkiest
luckies133313683_luckies
lunies64723013_lun_ies
maundies1137853maundies
muskies133614673_muskies
opuntias10103233opuntias
pandies104224503_pandies
pansies94521983_pansies
panties94230933_panties
pennies94218813_pennies
pinkie124414273_pinkie_
pinkoes135512313_pinkoes
pinnies93318443_pinnies
plunkier14305323plunkier
plunkiest1535503plunkiest
pokies125921333_p_okies
ponies84833463_pon_ies
porkies133416493_porkies
pukes114523023_pu_k_es
punches144816133_punches
pundits10379293_pundits
pungles104013713_pungles
punier84519223_pun_ier
puniest92918093_pun_iest
punjis1536693_punji_s
punkahs16284783_punkahs
punkas123410673_punk_as
punker123718823_punk_er
punkers133714853_punkers
punkest132611693_punk_est
punkey154011173_punk_ey
punkeys16366493_punkeys
punkin123611523_punki_n
punkiness15226983_punkiness
punkish16257693_punkish
punks114822683_punk__s
punnier93511263_punnier
punniest102511583_punniest
puppies103212613_puppies
pussies93615693_pussies
putties94420023_putties
runkles114111943_runkles
sanies63031953s_an_ies
sauries72821623sau_ries
scanties103215423scanties
scurries102911483scurries
scurvies13248123scurvies
selkies113513353s_elkies
shandies122714103shandies
shannies113411253shannies
shanties113116583shanties
shindies122610503shindies
shinnies113010913shinnies
shunpikes1841903shunpikes
sickies133717503s_ickies
silkies113715693s_ilkies
skankier11184883skankier
skankiest12145703skankiest
skies95026833s___kies
skunked11316193skunk_ed
skunking12256653skunking
skunks9468163skunk__s
slinkier12206933slinkier
slinkiest13188073slinkiest
slurries82710413slurries
snuggies10246363snuggies
sonnies7315223s_onnies
spackles16319953spackles
spangles1138893spangles
spaniel948923span_iel
spaniels1045963span_iels
spanked143111733spank_ed
spanker133612353spank_er
spankers14369863spankers
spanking153911973spanking
spankings16215003spankings
spanks124514123spank__s
sparkier14298033sparkier
sparkiest15188093sparkiest
sparkles143210493sparkles
spavies123012943sp_avies
species11314133sp_ecies
speckles16268133speckles
spences113413923spen_ces
spendier1147143spendier
spendiest1237523spendiest
spenses92913573spen_ses
spies76037623sp___ies
spiffies16277993spiffies
spikes124520713sp_ik_es
spikier13369983sp_ikier
spikiest14259533sp_ikiest
spinages11289293spinages
spindles112710353spindles
spines85132033spin__es
spinier93715163spin_ier
spiniest102813223spin_iest
spinules10249333spinules
splakes1349673splak_es
spokes124417213sp_ok_es
spondees1136483spondees
sponges10311043spon_ges
spongier1135743spongier
spongiest1237083spongiest
spongins1136563spongins
spookier14175493spookier
spookiest15156393spookiest
spoonies101911753spoonies
sprinkles1534923sprinkles
spues75025383spu___es
spumes1021314883spu__mes
spumier1137903spu_mier
spumiest1238203spu_miest
spumones1254953spumones
spunk114513403spunk___
spunky15427163spunk__y
spurges104111653spu_rges
spurrier10297693spurrier
spurriers11245063spurriers
spurtles1037783spurtles
sputniks1462093sputniks
squinnies1844483squinnies
stenokies1345313stenokies
stickies142211973stickies
stinkier12278543stinkier
stinkiest13198463stinkiest
studdies10207073studdies
studies82413863stu_dies
sturdies92110273sturdies
suckier133613973s_uckier
suckiest143314113s_uckiest
suckles134516743s_uckles
sulkier113811963s_ulkier
sulkiest124212503s_ulkiest
sullies74122233s_ullies
sundaes8313093s_undaes
sundries9312023s_undries
sunken103511783s_unk_en
sunket103721363s_unk_et
sunkets113511283s_unkets
sunnier73412153s_unnier
sunniest82712913s_unniest
sunrise7310813s_unrise
sunrises8310693s_unrises
sunwise1036433s_unwise
supplies1268833supplies
swankier15225503swankier
swankiest16136203swankiest
tunnies73614263_tunnies
twankies1535893twankies
twinkies1535983twinkies
undies73821963__undies
unties64326923__unties

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 Filter1786911461620.403443402.0
2DLD Change Limit1461622047.14320462.3
3Display Results2042040.0762684.2
 (SQL Overall)1786912047.62223444.1
 
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.