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

236 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
spicily143865(None) 
spikily1635871spikily
icily101211692__icily
juicily1935492juicily
pricily142710282pricily
saucily1237912saucily
shinily13268932shinily
sickly153110482s_ickly
slickly1635852slickly
slimily1247712slimily
specify1764992specify
spicery14499012spicery
spicey134414232spic_ey
spicier115112462spicier
spicing123914532spicing
spicula11259292spicula
spicule11269932spicule
spicy125417712spic__y
spiffily19153482spiffily
spindly13257382spindly
stickily1736082stickily
airily93014823_airily
apical10913903apical_
apically1539833apically
apicals1159923apicals
apiculi1145113apiculi
apishly1535663apishly
chicly16429203chic_ly
cicely1338833_cicely
epiboly1454353epiboly
epical10413393epical_
epically15310583epically
epicalyx2242303epicalyx
fancily1538253fancily
fickly18318533_fickly
grimily1336523grimily
ickily1535753__ickily
lacily11612763_lacily
licitly12276673_licitly
nicely1139493_nicely
nippily1444713nippily
noisily1038403noisily
oilily93111723_oilily
opacify1743653opacify
opacity1436313opacity
pacify1667473_pacify
packly17228333_packly
pical95524373_pical_
pickle144215653_pickle
picky165416943_pic_ky
picul95015363_picul_
piculs103511753_piculs
piddly13319143_piddly
pily96132733_p__ily
pimply15329213_pimply
pinkly155012243_pinkly
pitchily1855013_pitchily
pithily1567033_pithily
pockily1846233_pockily
pokily15309063_pokily
prickly18367893prickly
privily15207623privily
punily11311773_punily
quickly2534073quickly
racily11715173_racily
rainily10310433rainily
richly1438003_richly
saintly1039343saintly
saltily10310543saltily
sapidity1446433sapidity
sappily1437163sappily
sassily1038723sassily
savvily1634323savvily
scaly104718723s__caly
scarily12311703scarily
seedily1178583seedily
septicity1646583septicity
sexily1638853s_exily
shadily1437723shadily
shakily1736903shakily
shiftily1744553shiftily
shily115222013s__hily
shingly143210813shingly
showily1636223showily
sickle124418323s_ickle
sicklily1744293s_icklily
sigil63515503s_igil_
sigils73912363s_igils
silicify1644273silicify
silkily14236963silkily
sillily10209783sillily
silly84527623s_i_lly
simile83115633s_imile
simply133010523s_imply
singly104015853s_ingly
skimpily1963053skimpily
slackly1635263slackly
slicing103514643slicing
slily85820033s__lily
slimly11408903sli_mly
slinkily1534853slinkily
slippily1544193slippily
smirkily1753333smirkily
smokily1635373smokily
snakily1436913snakily
snidely1136813snidely
sniffily17154033sniffily
sniffly16265643sniffly
snippily1543573snippily
snowily1336883snowily
soapily1237963soapily
soggily1235953soggily
sootily101810523sootily
sorrily1039833sorrily
spacey136212533spac_ey
spacial1138763spacial
spacially1645653spacially
spacier114011633spacier
spacing123614493spacing
spackle15369573spackle
spacy125415623spac__y
spail74921553sp_ail_
spails84817823sp_ails
spangly1336473spangly
sparely123410673sparely
sparkily1735023sparkily
sparkly16348133sparkly
special11310303special
specially1647343specially
specials1238033specials
specialty1644303specialty
specie10412223speci_e
species11314133species
speckle15297553speckle
specula11187413specula
speedily1465183speedily
speil75618643sp_eil_
speils84116223sp_eils
spic85227433spic___
spica94717943spic__a
spicae104313703spic_ae
spicas104715823spic_as
spicate113214193spicate
spice95528813spic__e
spiced115218313spic_ed
spicer104719313spic_er
spicers113815553spicers
spices104326033spic_es
spiciest122711603spiciest
spick134519073spic__k
spicks144814993spic_ks
spics94123243spic__s
spiculae12218603spiculae
spicular12238903spicular
spicules12219803spicules
spiculum1464213spiculum
spidery13308203spidery
spiel74623913spi_el_
spiels85317953spi_els
spiffy17326223spi_ffy
spikey155411333spi_key
spikier13369983spikier
spiking144312883spiking
spiky146014113sp__iky
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
splicing1338963splicing
spoil75818653sp_oil_
spoils84614533sp_oils
spoilt85016593sp_oilt
spongily1444903spongily
spookily1744173spookily
spoonily1335233spoonily
sportily1337733sportily
spottily1335153spottily
sprawly15166043sprawly
springily1545583springily
sprucely1543123sprucely
spryly1435513sp_ryly
spunkily1733773spunkily
stagily1139053stagily
stickle132410973stickle
sticky154711343stic_ky
stiffly16235173stiffly
stilly93714093sti_lly
stingily1236793stingily
stockily1735443stockily
stonily1049433stonily
strictly1345813strictly
suicide1038893suicide
sulkily14218113sulkily
sunnily1037833sunnily
supinely1376293supinely
surlily10310003surlily
swiftly1633733swiftly
swimmily1842713swimmily
swirly12439253swi_rly
swithly1634443swithly
thickly19415573thickly
tidily102811393_tidily
tinily94014433_tinily
tipsily1236043tipsily
trickily1736233trickily
trickly16369893trickly
wilily123310763_wilily
wirily123310783_wirily

Search took 7 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.406440125.6
2DLD Change Limit1340272366.00022337.8
3Display Results2362360.0802950.0
 (SQL Overall)1786912366.48627550.3
 
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.