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

153 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
spike11492284(None) 
pike106335221_pike
sike87138791s_ike
spake114322741spake
spice95528811spice
spik105419711spik_
spiked134915551spiked
spiker124315661spiker
spikes124520711spikes
spikey155411331spikey
spiks114117471spiks
spiky146014111spiky
spile75230081spile
spine76534421spine
spire75828691spire
spite75430661spite
spoke114818661spoke
alike95523962alike
aspire8612122aspire
bike106532612_bike
dike95935772_dike
hike116830402_hike
kike76524802_kike
like86040852_like
mike105535302_mike
muspike1536042muspike
opine77422462opine
peke105926202_peke
pice84641102_pice
pie55457412_pi_e
pika106322962_pika
piked125623312_piked
piker115622842_piker
pikes115031032_pikes
piki106520572_piki
pile65649702_pile
pine67755722_pine
pipe86434442_pipe
poke105335362_poke
puke105025462_puke
saice75424052saice
sake85244962s_ake
seine55732872seine
seise54727852seise
seize143819502seize
shake124726402shake
shikse1386072shikse
shine85533092shine
shire84727132shire
shive114423422shive
shrike134513242shrike
sice65545602s_ice
side55444502s_ide
sika86021332s_ika
siker95326032s_iker
sikes96236082s_ikes
sine46560632s_ine
sipe67341052s_ipe
sire46150422s_ire
site47052422s_ite
size135630972s_ize
skite95120062skite
skive124614122skive
slake93724052slake
slice74925822slice
slide64725422slide
slime74925752slime
slipe75626132slipe
smile74823922smile
smite75224872smite
smoke115015822smoke
snake94821112snake
snide64318732snide
snipe75320572snipe
soke85436262s_oke
sopite84917712sopite
space95325672space
spade84423322spade
spae65034322sp_ae
spale74929212spale
spare75135562spare
spate74731582spate
speise84614252speise
spic85227432spi_c
spica94717942spica
spicae104313702spicae
spiced115218312spiced
spicer104719312spicer
spices104326032spices
spicey134414232spicey
spick134519072spick
spicks144814992spicks
spics94123242spics
spicy125417712spicy
spider94516802spider
spied85427712spied
spiel74623912spiel
spier75728032spier
spies76037622spies
spiff133616402spiff
spikers135311992spikers
spikier13369982spikier
spiled94621992spiled
spiles84227912spiles
spill74821162spill
spilt75532222spilt
spin66231302spi_n
spined95423942spined
spinel85317332spinel
spines85132032spines
spinet85629752spinet
spins75327982spins
spiny104921302spiny
spirea84015632spirea
spired94921862spired
spirem104214162spirem
spires84628112spires
spirt75032952spirt
spiry105017352spiry
spit65545082spi_t
spited94820442spited
spites84127332spites
spits74429552spits
spitz166017972spitz
spiv95917792spi_v
spivs105114242spivs
splake1259782splake
splice104915102splice
spline86020532spline
spode84617702spode
spoked134413892spoked
spoken124610002spoken
spokes124417212spokes
spore75428592spore
spree74830862spree
sprite84421772sprite
sprue74717632sprue
spue66025522sp_ue
spume95817312spume
stake95927532stake
stile54931572stile
stime76521802stime
stipe76523372stipe
stoke94922512stoke
strike105619732strike
suite54829562suite
supine84216692supine
swine85625302swine
swipe105217082swipe
swive115316192swive
syke115420562s_yke
tike85534492_tike
trike95320162trike

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 Filter178691538000.313570897.8
2DLD Change Limit538001531.68631909.8
3Display Results1531530.0463326.1
 (SQL Overall)1786911532.04587379.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.