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 “spiced” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

141 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
spiced11521831(None) 
sliced94416311sliced
spaced114517251spaced
spice95528811spice_
spicer104719311spicer
spices104326031spices
spicey134414231spicey
spied85427711spi_ed
spiked134915551spiked
spiled94621991spiled
spined95423941spined
spired94921861spired
spited94820441spited
spliced124310591spliced
apices104916262apices
aspired1068172aspired
deiced104214482deiced
diced95824682_diced
espied9359772espi_ed
iced78721892__iced
juiced1636512juiced
opined95113852opined
paced106931682_paced
pice84641092_pice_
picked154421312_picked
pieced113912102_pieced
pied75035362_pi_ed
piked125623312_piked
piled85232992_piled
pined85935322_pined
piped105123162_piped
priced115018882priced
riced85825542_riced
saice75424052saice_
saices84221802saices
sailed74327762sailed
sained75424242sained
sauced93913302sauced
seined74023062seined
seised74218122seised
seized164313652seized
shied96125492shi_ed
shined104620782shined
sicced11489652sicced
sice65545592s_ice_
sices75637272s_ices
sicked134524402s_icked
sided74825952s_ided
siped84927682s_iped
sipped113720632sipped
sired66134282s_ired
sited65130742s_ited
sized155519242s_ized
skied104417752ski_ed
skited114313482skited
skived14429892skived
slice74925822slice_
slicer84117602slicer
slices84022852slices
slicked144413842slicked
slimed94915122slimed
sliped95417062sliped
sluiced1046052sluiced
smiled93716432smiled
snicked143811632snicked
sniped94913482sniped
soiled73822472soiled
sopited104211062sopited
space95325672space_
spacer104917792spacer
spaces104722632spaces
spacey136212532spacey
spaded103816752spaded
spaed85522272sp_aed
spared95427492spared
spayed124213612spayed
specced14266702specced
specked16329012specked
sped76031492sp__ed
speed85526622sp_eed
speiled104412122speiled
speired103811102speired
spewed125512332spewed
spic85227432spic__
spica94717942spic_a
spicae104313702spicae
spicas104715822spicas
spicated13309902spicated
spicers113815552spicers
spicery14499012spicery
spicier115112462spicier
spick134519072spic_k
spicks144814992spicks
spics94123242spic_s
spicy125417712spic_y
spider94516802spider
spiel74623912spi_el
spieled104811882spieled
spier75728032spi_er
spiered104412462spiered
spies76037622spi_es
spiffed16257102spiffed
spike114922842spike_
spiker124315662spiker
spikes124520712spikes
spikey155411332spikey
spile75230082spile_
spiles84227912spiles
spilled103613622spilled
spine76534422spine_
spinel85317332spinel
spines85132032spines
spinet85629752spinet
spire75828692spire_
spirea84015632spirea
spirem104214162spirem
spires84628112spires
spirted103913072spirted
spite75430662spite_
spites84127332spites
spitted103912702spitted
splice104915102splice_
splicer114710522splicer
splices113914382splices
splined105013112splined
spoiled104811352spoiled
spoked134413892spoked
spored94821792spored
spruced12307532spruced
spued84918472sp_ued
spumed114711542spumed
sticked144114632sticked
stied65723032sti_ed
stiped94517072stiped
suited74019422suited
swiped123811092swiped
swived133610632swived
synced12266962synced
triced95518672triced
viced115118182_viced
voiced123910112voiced

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511412.51332849.6
3Display Results1411410.0463065.2
 (SQL Overall)1786911412.90261575.1
 
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.