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

113 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
stockily173544(None) 
stickily1736081stickily
cockily1838492_cockily
pockily1846232_pockily
smokily1635372smo_kily
spookily1744172spookily
stalkily1534822stalkily
stockier14217252stockier
stocking152912502stocking
stockish17186042stockish
stockist14197712stockist
stockpile1743032stockpile
stocky15369152stock__y
stodgily1343902stodgily
stonily1049432sto_nily
stormily1345242stormily
tackily1637502_tackily
botchily1864373botchily
croakily1744733croakily
hokily16409093_ho_kily
ickily1535753__ickily
itchily1574493it_chily
jokily20306533_jo_kily
luckily16297083_luckily
muckily18277743_muckily
pluckily1963413pluckily
pokily15309063_po_kily
saucily1237913sauc_ily
shakily1736903s_hakily
shocking184311543shocking
shockingly2342683shockingly
shoddily1643573shoddily
showily1636223sho_wily
sicklily1744293s_icklily
sickly153110483s_ick_ly
silkily14236963s_ilkily
slackly1635263slack_ly
slickly1635853slick_ly
slinkily1534853slinkily
sloppily1544613sloppily
slouchily1742683slouchily
smirkily1753333smirkily
smocking17349103smocking
snakily1436913s_nakily
snarkily1534583snarkily
sneakily1544423sneakily
snobbily1544233snobbily
snoopily1345553snoopily
snootily1136253snootily
snottily1145553snottily
snowily1336883sno_wily
soapily1237963s_oapily
socking143518603s_ocking
soggily1235953s_oggily
sootily101810523s_ootily
sorrily1039833s_orrily
sparkily1735023sparkily
spicily1438653spic_ily
spikily1635873s_pikily
spongily1444903spongily
spoonily1335233spoonily
sportily1337733sportily
spottily1335153spottily
spunkily1733773spunkily
stacking154215083stacking
stagily1139053st_agily
starchily1745013starchily
starkly14277033stark_ly
steadily1236213steadily
steamily1335803steamily
stickier14229763stickier
stickies142211973stickies
sticking153513463sticking
stickit1339463sticki_t
stickle132410973stick_le
sticky154711343stick__y
stingily1236793stingily
stock114417563stock___
stockade1544523stockade
stockage1544903stockage
stockcar1642923stockcar
stocked144312873stock_ed
stocker133713083stock_er
stockers143411073stockers
stockfish2142853stockfish
stockiest15207753stockiest
stockinet1547193stockinet
stockings16296093stockings
stockists15194563stockists
stockman1644143stockman
stockmen1643923stockmen
stockpiled1952033stockpiled
stockpiler1842333stockpiler
stockpiles1842993stockpiles
stockpot1644663stockpot
stocks124715633stock__s
stoically1449673stoically
stoking123615593sto_king
stolidly1243833stolidly
stonefly1443473stonefly
stooking132711143stooking
stoutly1035833sto_utly
streakily1643673streakily
stubbily1564243stubbily
stuffily17124163stuffily
sturdily1245083sturdily
sulkily14218113s_ulkily
swankily1833833swankily
tackify1934493_tackify
techily1537123_techily
touchily1645233_touchily
trickily1736233trickily
wackily1936053_wackily

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.406440125.6
2DLD Change Limit1461621137.73318901.1
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.18521831.5
 
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.