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

111 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
stalkily153482(None) 
balkily16266692_balkily
saltily10310542s_altily
shakily1736902sha_kily
silkily14236962s_ilkily
snakily1436912sna_kily
snarkily1534582snarkily
sparkily1735022sparkily
stagily1139052sta_gily
stalely1039212stal_ely
stalkier1257072stalkier
stalking133512222stalking
stalky13499302stalk__y
starkly14277032stark_ly
stickily1736082stickily
stockily1735442stockily
sulkily14218112s_ulkily
swankily1833832swankily
tackily1637502_tackily
balmily14216463_balmily
bulkily16227123_bulkily
crankily1755623crankily
flakily1736293fla_kily
gawkily1834093_gawkily
lankily1437123_lankily
leakily1436473lea_kily
milkily16216553_milkily
pawkily1934203_pawkily
quakily2336693qua_kily
salably121610743s_alably
salify12311373s_al_ify
sally85129713s_al__ly
salsify1334703s_alsify
sappily1437163s_appily
sassily1038723s_assily
saucily1237913s_aucily
savvily1634323s_avvily
scabbily1763943scabbily
scalably15166703scalably
scantily1337583scantily
scarily12311703sca_rily
shabbily1873903shabbily
shadily1437723sha_dily
shaggily1643773shaggily
sicklily1744293sicklily
sillily10209783s_illily
slackly1635263slack_ly
slangily1235383slangily
slily85820033s__l_ily
slinkily1534853slinkily
smarmily1543523smarmily
smirkily1753333smirkily
smokily1635373s_mokily
snappily1544323snappily
sneakily1544423sneakily
soapily1237963soa_pily
sparkly16348133spark_ly
spikily1635873s_pikily
spookily1744173spookily
spunkily1733773spunkily
stabile9312063sta_bile
stably113314123sta__bly
stacking154215083stacking
staidly1136683sta_idly
staking123919803sta_king
staling83925423stal_ing
stalk94518003stalk___
stalked123811173stalk_ed
stalker113912253stalk_er
stalkers12369853stalkers
stalkiest1347903stalkiest
stalkings14314983stalkings
stalklike1243903stalklike
stalks104614553stalk__s
stall54722353stal__l_
stalling95116703stalling
stallion837513stallion
stalls64019933stal__ls
stanchly1644443stanchly
starchily1745013starchily
statedly1245833statedly
stately10310223sta_tely
steadily1236213steadily
stealthily1651823stealthily
steamily1335803steamily
stellify1443883stellify
stilly93714093stil__ly
stingily1236793stingily
stodgily1343903stodgily
stolidly1243833stolidly
stonily1049433st_onily
stormily1345243stormily
streakily1643673streakily
stubbily1564243stubbily
stuffily17124163stuffily
stultify1442723stultify
sturdily1245083sturdily
surlily10310003surl_ily
tackify1934493_tackify
talkie103914443_talki_e
talkier114011843_talkier
talkies113415733_talkies
talking123815823_talking
talky126215683_talk__y
tally84526863_tal__ly
tardily11269583_tardily
tartily103511573_tartily
tastily103311643_tastily
tattily10409993_tattily
tawnily1335443_tawnily
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.440406115.9
2DLD Change Limit1461621117.81318707.5
3Display Results1111110.0432581.4
 (SQL Overall)1786911118.29621539.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.