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

140 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
spiked13491555(None) 
piked125623311_piked
spiced115218311spiced
spied85427711spi_ed
spike114922841spike_
spiker124315661spiker
spikes124520711spikes
spikey155411331spikey
spiled94621991spiled
spined95423941spined
spired94921861spired
spited94820441spited
spoked134413891spoked
aspired1068172aspired
biked125320032_biked
diked115024682_diked
espied9359772espi_ed
hiked135919202_hiked
liked104523812_liked
miked125020452_miked
opined95113852opined
paiked135113432paiked
picked154421312_picked
pied75035362_pi_ed
pike106335212_pike_
piker115622842_piker
pikes115031032_pikes
piled85232992_piled
pined85935322_pined
pinked134819882_pinked
piped105123162_piped
poked125425392_poked
puked124716222_puked
sacked135525212sacked
sailed74327762sailed
sained75424242sained
seined74023062seined
seised74218122seised
seized164313652seized
shied96125492shi_ed
shined104620782shined
shirked153710462shirked
sicked134524402sicked
sided74825952s_ided
sike87138782s_ike_
siker95326032s_iker
sikes96236082s_ikes
silked114314812silked
siped84927682s_iped
sipped113720632sipped
sired66134282s_ired
sited65130742s_ited
sized155519242s_ized
skied104417752ski_ed
skinked11339012skinked
skited114313482skited
skived14429892skived
slaked114318272slaked
sliced94416312sliced
slicked144413842slicked
slimed94915122slimed
slinked123011382slinked
sliped95417062sliped
smiled93716432smiled
smirked14307232smirked
smoked134311722smoked
snaked115017592snaked
snicked143811632snicked
sniped94913482sniped
soaked114717592soaked
socked134721502socked
soiled73822472soiled
sopited104211062sopited
spaced114517252spaced
spaded103816752spaded
spaed85522272sp_aed
spake114322742spake_
spanked143111732spanked
spared95427492spared
sparked143513142sparked
spayed124213612spayed
specked16329012specked
sped76031492sp__ed
speed85526622sp_eed
speiled104412122speiled
speired103811102speired
spewed125512332spewed
spice95528812spice_
spicer104719312spicer
spices104326032spices
spicey134414232spicey
spider94516802spider
spiel74623912spi_el
spieled104811882spieled
spier75728032spi_er
spiered104412462spiered
spies76037622spi_es
spiffed16257102spiffed
spik105419712spik__
spikers135311992spikers
spikier13369982spikier
spiks114117472spik_s
spiky146014112spik_y
spile75230082spile_
spiles84227912spiles
spilled103613622spilled
spine76534422spine_
spinel85317332spinel
spines85132032spines
spinet85629752spinet
spire75828692spire_
spirea84015632spirea
spirem104214162spirem
spires84628112spires
spirted103913072spirted
spite75430662spite_
spites84127332spites
spitted103912702spitted
spliced124310592spliced
splined105013112splined
spoiled104811352spoiled
spoke114818662spoke_
spoken124610002spoken
spokes124417212spokes
spooked144510472spooked
spored94821792spored
spued84918472sp_ued
spumed114711542spumed
spunked14307782spunked
staked114621942staked
sticked144114632sticked
stied65723032sti_ed
stiped94517072stiped
stoked114718292stoked
sucked134120492sucked
suited74019422suited
sulked114314702sulked
swinked15349032swinked
swiped123811092swiped
swived133610632swived

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.356501941.0
2DLD Change Limit825511402.29635954.3
3Display Results1401400.0463043.5
 (SQL Overall)1786911402.69866230.9
 
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.