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

125 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
snarkily153458(None) 
snakily1436911sna_kily
sparkily1735021sparkily
scarily12311702scar_ily
shakily1736902sha_kily
smarmily1543522smarmily
smirkily1753332smirkily
snappily1544322snappily
snarkier12336512snarkier
snarky134210842snark__y
snarly93815002snar__ly
sneakily1544422sneakily
sparkly16348132spark_ly
stalkily1534822stalkily
starkly14277032stark_ly
swankily1833832swankily
angrily1137723angr_ily
artily92814713__artily
balkily16266693_balkily
charily15310283char_ily
crankily1755623crankily
darkly145411073_dark_ly
flakily1736293fla_kily
gawkily1834093_gawkily
gnarly104610383gnar__ly
hardily143310273_hardily
heartily1436563heartily
hoarily1338973hoar_ily
jerkily2134623_jerkily
lankily1437123_lankily
leakily1436473lea_kily
mirkily16266403_mirkily
murkily16287113_murkily
nargile847653_nargile
narking124015383_narking
narky126017803_nark__y
nastily103011033_nastily
nattily103610323_nattily
nervily1336863_nervily
pawkily1934203_pawkily
perkily1637813_perkily
quakily2336693qua_kily
quirkily2442593quirkily
saltily10310543s_altily
sappily1437163s_appily
sarkier113413313s_arkier
sarky125521783s_ark__y
sassily1038723s_assily
saucily1237913s_aucily
savvily1634323s_avvily
scabbily1763943scabbily
scantily1337583scantily
scarcely1534313scarcely
scarcity1545093scarcity
scarify1537443scar_ify
scurvily1643783scurvily
shabbily1873903shabbily
shadily1437723sha_dily
shaggily1643773shaggily
sharking163912973sharking
sharply15406833shar_ply
silkily14236963s_ilkily
slackly1635263slack_ly
slangily1235383slangily
slinkily1534853slinkily
smartly12497433smar_tly
smokily1635373s_mokily
snacking153411703snacking
snail57020203sna__il_
snails64816653sna__ils
snakey135011273sna_k_ey
snakier112810003sna_kier
snaking123915303sna_king
snaky125113913sna_k__y
snarfing12358663snarfing
snaring83920953snar_ing
snark95419943snark___
snarkiest13207643snarkiest
snarks104815733snark__s
snarl54921083snar__l_
snarlier8278183snarlier
snarling92513183snarling
snarls64016873snar__ls
sniffily17154033sniffily
snippily1543573snippily
snobbily1544233snobbily
snoopily1345553snoopily
snootily1136253snootily
snorkel1135423snorkel_
snorkels1234413snorkels
snottily1145553snottily
snowily1336883sn_owily
snuffily17124323snuffily
soapily1237963soa_pily
sorrily1039833s_orrily
sparely123410673spar_ely
sparkier14298033sparkier
sparking152812543sparking
sparkish17276973sparkish
sparkle133710213spark_le
sparky154511523spark__y
sparsely1335123sparsely
sparsity1345463sparsity
spikily1635873s_pikily
spookily1744173spookily
sportily1337733sportily
spunkily1733773spunkily
stagily1139053sta_gily
starchily1745013starchily
stickily1736083stickily
stockily1735443stockily
stormily1345243stormily
sturdily1245083sturdily
sulkily14218113s_ulkily
sundrily1246063sundr_ily
surlily10310003s_urlily
swarthily1842583swarthily
tackily1637503_tackily
tardily11269583_tardily
tartily103511573_tartily
tearily10311153tear_ily
unwarily1446363unwar_ily
wackily1936053_wackily
warily122915093_war_ily
wearily1338783wear_ily

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 Limit1461621257.60619216.7
3Display Results1251250.0462717.4
 (SQL Overall)1786911258.09222082.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.