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

141 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
spunkie1321530(None) 
punkie123513611_punkie
spunkier14235821spunkier
spunkies14227591spunkies
flunkie1434512flunkie
hunkie133812382_hunkie
junkie17339602_junkie
pinkie124414272_pinkie
punkier133512792_punkier
punkies134216802_punkies
punkin123611522_punkin
skunkier11174282skunkier
spunk114513402spunk__
spunked14307782spunked
spunkiest15166572spunkiest
spunkily1733772spunkily
spunking15258062spunking
spunks12349332spunk_s
spunky15427162spunk_y
auntie64317703_auntie
chunkier17395883chunkier
clunkier14345793clunkier
duckie133511663_duckie
flunkies1536393flunkies
funkia1336343_funkia
funkier14349983_funkier
gunkier12369553_gunkier
hankie133915713_hankie
honkie133011673_honkie
hunkier144512143_hunkier
hunkies143214503_hunkies
junkier18339493_junkier
junkies183711693_junkies
luckie123611413_luckie
muskie123412543_muskie
opuntia9134153opuntia
pantie84326473_pantie
pinkies133818263_pinkies
plunkier14305323plunkier
puke105025463_pu_k_e
pundit92914183_pundit
pungle94413573_pungle
punier84519223_pun_ier
punji1438203_punji_
punjis1536693_punjis
punk105729973_punk__
punka114515483_punk_a
punkah15347093_punkah
punkas123410673_punkas
punker123718823_punker
punkey154011173_punkey
punkiest149312663_punkiest
punkins133111113_punkins
punkish16257693_punkish
punks114822683_punk_s
punky144419393_punk_y
punnier93511263_punnier
punties94520783_punties
puttie84116303_puttie
runkle103611543_runkle
selkie102811693s_elkie
shunpike1742153shunpike
sickie123715743s_ickie
silkie103313403s_ilkie
skankier11184883skankier
skunk85011763skunk__
skunked11316193skunked
skunkiest12135093skunkiest
skunking12256653skunking
skunks9468163skunk_s
skunky12436163skunk_y
slinkier12206933slinkier
slunk95016303slunk__
sonsie6614863s_onsie
spackle15369573spackle
spake114322743sp_ak_e
spangle1038403spangle
spaniel948923span_iel
spank115919573spank__
spanked143111733spanked
spanker133612353spanker
spanking153911973spanking
spanks124514123spank_s
sparkier14298033sparkier
sparkle133710213sparkle
spavie113611383sp_avie
specie10412223sp_ecie
speckle15297553speckle
spence103813793spen_ce
spendier1147143spendier
spense83912433spen_se
spike114922843sp_ik_e
spikier13369983sp_ikier
spinage10289653spinage
spinate93114813spinate
spindle103210093spindle
spine76534423spin__e
spinier93715163spin_ier
spinnies103210543spinnies
spinose937943spinose
spinule9299993spinule
splake1259783splak_e
spoke114818663sp_ok_e
spondee10310593spondee
sponge939663spon_ge
spongier1135743spongier
spongin1036373spongin
spookier14175493spookier
sprinkle1434893sprinkle
spue66025523spu___e
spume95817313spu__me
spumier1137903spu_mier
spumone1154383spumone
spun66221463spun___
spunkiness1644173spunkiness
spurge93711323spu_rge
spurrier10297693spurrier
spurries102311323spurries
spurtle937453spurtle
sputnik1372273sputnik
sputniks1462093sputniks
stinkier12278543stinkier
studdie9195273studdie
stunk94616293stunk__
suckier133613973s_uckier
suckle124015963s_uckle
sulkier113811963s_ulkier
sulkies114315763s_ulkies
sundae7312873s_undae
sunk85031813s_unk__
sunken103511783s_unken
sunket103721363s_unket
sunlike112310573s_unlike
sunlit61516103s_unlit
sunnier73412153s_unnier
sunrise7310813s_unrise
sunwise1036433s_unwise
swankier15225503swankier
twinkie1434573twinkie
untie54425493__untie
vauntie1036633vauntie

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.423422437.4
2DLD Change Limit1340271416.53020524.8
3Display Results1411410.0502820.0
 (SQL Overall)1786911417.00325516.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.