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

101 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
spunkily173377(None) 
chunkily2043082chunkily
funkily1736512_funkily
punily11311772_pun_ily
slinkily1534852slinkily
sparkily1735022sparkily
spikily1635872sp_ikily
spongily1444902spongily
spookily1744172spookily
spunkie13215302spunki_e
spunkier14235822spunkier
spunkies14227592spunkies
spunking15258062spunking
spunky15427162spunk__y
sulkily14218112s_ulkily
sunnily1037832s_unnily
swankily1833832swankily
bouncily1544383bouncily
bulkily16227123_bulkily
crankily1755623crankily
duskily15236743_duskily
flukily1735213flu_kily
funnily1336373_funnily
huskily17236333_huskily
jauntily1834173jauntily
kinkily1335223_kinkily
lankily1437123_lankily
luckily16297083_luckily
muckily18277743_muckily
murkily16287113_murkily
muskily16289043_muskily
pawkily1934203_pawkily
perkily1637813_perkily
peskily1635083_peskily
pinkly155012243_pink_ly
pluckily1963413pluckily
pockily1846233_pockily
pokily15309063_p_okily
pudgily1434903_pudgily
puffily1834843_puffily
pulpily1436103_pulpily
punchily1844863_punchily
punkey154011173_punk_ey
punkie123513613_punki_e
punkier133512793_punkier
punkies134216803_punkies
punkin123611523_punki_n
punkins133111113_punkins
punkish16257693_punkish
punky144419393_punk__y
pursily1238213_pursily
pushily15247983_pushily
quakily2336693_quakily
saucily1237913sau_cily
scantily1337583scantily
scummily1743303scummily
scurvily1643783scurvily
shakily1736903s_hakily
shinily13268933shin_ily
silkily14236963s_ilkily
skunkier11174283skunkier
skunking12256653skunking
skunky12436163skunk__y
slangily1235383slangily
slushily1445013slushily
smirkily1753333smirkily
smokily1635373s_mokily
smudgily1543123smudgily
smuttily1344273smuttily
snakily1436913s_nakily
snarkily1534583snarkily
sneakily1544423sneakily
snuffily17124323snuffily
soundly1136683soun_dly
spangly1336473span_gly
spanking153911973spanking
sparkly16348133spark_ly
speedily1465183speedily
spicily1438653sp_icily
spiffily19153483spiffily
spinally1338023spinally
spindly13257383spin_dly
spoonily1335233spoonily
sportily1337733sportily
spottily1335153spottily
springily1545583springily
spunk114513403spunk___
spunked14307783spunk_ed
spunkiest15166563spunkiest
spunks12349333spunk__s
squeakily2542003squeakily
stalkily1534823stalkily
stickily1736083stickily
stingily1236793stingily
stockily1735443stockily
stonily1049433ston_ily
stubbily1564243stubbily
stuffily17124163stuffily
sturdily1245083sturdily
sundrily1246063s_undrily
surlily10310003s_urlily

Search took 9 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.466383457.1
2DLD Change Limit1461621017.65619091.2
3Display Results1011010.0333060.6
 (SQL Overall)1786911018.15521911.8
 
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.