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

211 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
spikily163587(None) 
spicily1438651spicily
pokily15309062_pokily
shakily1736902shakily
shinily13268932shinily
silkily14236962silkily
slimily1247712slimily
slinkily1534852slinkily
smirkily1753332smirkily
smokily1635372smokily
snakily1436912snakily
sparkily1735022sparkily
spiffily19153482spiffily
spikey155411332spik_ey
spikier13369982spikier
spiking144312882spiking
spiky146014112spik__y
spindly13257382spindly
spookily1744172spookily
spunkily1733772spunkily
stickily1736082stickily
sulkily14218112sulkily
airily93014823_airily
apishly1535663apishly
balkily16266693balkily
bulkily16227123bulkily
cockily1838493cockily
duskily15236743duskily
epiboly1454353epiboly
flakily1736293flakily
flukily1735213flukily
friskily1834503friskily
funkily1736513funkily
gawkily1834093gawkily
grimily1336523grimily
hokily16409093_hokily
huskily17236333huskily
icily101211693__icily
ickily1535753_ickily
jerkily2134623jerkily
jokily20306533_jokily
juicily1935493juicily
kinkily1335223kinkily
lankily1437123lankily
leakily1436473leakily
likely13328133_likely
luckily16297083luckily
milkily16216553milkily
mirkily16266403mirkily
muckily18277743muckily
murkily16287113murkily
muskily16289043muskily
nippily1444713nippily
noisily1038403noisily
oilily93111723_oilily
pawkily1934203pawkily
perkily1637803perkily
peskily1635083peskily
piddly13319143_piddly
piki106520563_piki__
piking133719643_piking
pikis115116393_piki_s
pily96132733_p__ily
pimply15329213_pimply
pinkly155012243_pinkly
pithily1567033_pithily
pockily1846233pockily
pricily142710283pricily
privily15207623privily
punily11311773_punily
quakily2336693quakily
quirkily2442593quirkily
rainily10310433rainily
riskily1436413riskily
saintly1039343saintly
saltily10310543saltily
sapidity1446433sapidity
sappily1437163sappily
sassily1038723sassily
saucily1237913saucily
savvily1634323savvily
scarily12311703scarily
seedily1178583seedily
sexily1638853s_exily
shadily1437723shadily
shiftily1744553shiftily
shily115222013s__hily
shingly143210813shingly
showily1636223showily
sicklily1744293sicklily
sickly153110483s_ickly
sigil63515503s_igil_
sigils73912363s_igils
sillily10209783sillily
silly84527623s_i_lly
simile83115633s_imile
simply133010523s_imply
singly104015853s_ingly
skiey125012893s__kiey
skill94316723s__kill
skimpily1963053skimpily
slickly1635853slickly
slily85820033s__lily
slimly11408903sli_mly
slippily1544193slippily
snarkily1534583snarkily
sneakily1544423sneakily
snidely1136813snidely
sniffily17154033sniffily
sniffly16265643sniffly
snippily1543573snippily
snowily1336883snowily
soapily1237963soapily
soggily1235953soggily
sootily101810523sootily
sorrily1039833sorrily
spail74921553sp_ail_
spails84817823sp_ails
spangly1336473spangly
sparely123410673sparely
sparkly16348133sparkly
specify1764993specify
speedily1465173speedily
speil75618643sp_eil_
speils84116223sp_eils
spicery14499013spicery
spicey134414233spi_cey
spicier115112463spicier
spicing123914533spicing
spicula11259293spicula
spicule11269933spicule
spicy125417713sp__icy
spidery13308203spidery
spiel74623913spi_el_
spiels85317953spi_els
spiffy17326223spi_ffy
spik105419713spik___
spike114922843spik__e
spiked134915553spik_ed
spikelet1446533spikelet
spiker124315663spik_er
spikers135311993spikers
spikes124520713spik_es
spikiest14259533spikiest
spiks114117473spik__s
spile75230083sp__ile
spiling102919703spiling
spill74821163sp__ill
spills84717463spi_lls
spilt75532223sp__ilt
spinal84915313spinal_
spinally1338023spinally
spinals93911863spinals
spindle103210093spindle
spinel85317333spinel_
spinels94512443spinels
spinier93715163spinier
spinney12438923spinney
spinny114510183spi_nny
spinula9257903spinula
spinule9299993spinule
spiny104921303sp__iny
spiral83715343spiral_
spirally1348023spirally
spirals93212513spirals
spirier93214073spirier
spirilla1045073spirilla
spiring103918183spiring
spirit83519923spiri_t
spirits94112623spirits
spirula9257703spirula
spiry105017353sp__iry
spital83813873spital_
spitals93011593spitals
spiting103917623spiting
spittle937923spittle
spivvy1733213spi_vvy
spoil75818653sp_oil_
spoils84614533sp_oils
spoilt85016593sp_oilt
spoking143212223spoking
spongily1444903spongily
spoonily1335233spoonily
sportily1337733sportily
spottily1335153spottily
sprawly15166043sprawly
springily1545583springily
spryly1435513sp_ryly
stagily1139053stagily
stalkily1534823stalkily
stiffly16235173stiffly
stilly93714093sti_lly
stingily1236793stingily
stockily1735443stockily
stonily1049433stonily
sunnily1037833sunnily
supinely1376293supinely
surlily10310003surlily
swankily1833833swankily
swiftly1633733swiftly
swimmily1842713swimmily
swirly12439253swi_rly
swithly1634443swithly
tackily1637503tackily
tidily102811393_tidily
tinily94014433_tinily
tipsily1236043tipsily
trickily1736233trickily
wackily1936053wackily
wilily123310763_wilily
wirily123310783_wirily

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.1561145455.1
2DLD Change Limit1340272117.25018486.5
3Display Results2112110.0762776.3
 (SQL Overall)1786912117.48223882.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.