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

216 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
spite7543066(None) 
site47052411s_ite
skite95120051skite
smite75224871smite
sopite84917711sopite
spate74731581spate
spice95528811spice
spike114922841spike
spile75230081spile
spine76534421spine
spire75828691spire
spit65545081spit_
spited94820441spited
spites84127331spites
spits74429551spits
spitz166017971spitz
sprite84421771sprite
suite54829561suite
aplite8316392aplite
aspire8612122aspire
axite125218252axite
bite66547002_bite
blite76225352blite
boite74426322boite
cite65640342_cite
despite10410122despite
dite55547552_dite
elite56230182elite
evite85317682evite
flite85424962flite
gite55438612_gite
kite85338242_kite
lite47054542_lite
mite66249412_mite
nite45943582_nite
ophite11410562ophite
opiate8513462opiate
opine77422462opine
pate65350462_pate
pice84641092_pice
pie55457402_pi_e
pike106335212_pike
pile65649692_pile
pine67755712_pine
pipe86434432_pipe
piste75824602_piste
pit56471922_pit_
pita65436432_pita
pith95432692_pith
pits66348742_pits
pity96031932_pity
quite144621462quite
respite9513032respite
rite45849452_rite
saice75424052saice
saith85826552saith
saithe94713912saithe
samite83020602samite
sapote8314362sapote
sate45556102s_ate
saute55028082saute
scute75520942scute
seine55732872seine
seise54727852seise
seize143819502seize
sente56432882sente
shine85533092shine
shire84727132shire
shit76745942shit_
shits84731172shits
shive114423422shive
shote85526102shote
shute84520352shute
sice65545592s_ice
side55444492s_ide
sike87138782s_ike
sine46560622s_ine
sipe67341042s_ipe
sire46150412s_ire
sit35877752s_it_
sited65130742s_ited
sites56045432s_ites
sith75435152s_ith
sits45050202s_its
sixte126216582sixte
size135630962s_ize
skate94721552skate
skit85437532skit_
skited114313482skited
skites104418042skites
skits94721862skits
skive124614112skive
slate55438282slate
slice74925822slice
slide64725412slide
slime74925752slime
slipe75626132slipe
slit46250102slit_
slits56128852slits
smile74823922smile
smit65138412smit_
smiter83616412smiter
smites83921922smites
smith107818052smith
smote75820282smote
snide64318722snide
snipe75320572snipe
snit46342472snit_
snits54124832snits
somite84519372somite
sopited104211062sopited
sopites93817172sopites
space95325672space
spade84423322spade
spae65034322sp_ae
spait75631602spait_
spaits85017472spaits
spake114322742spake
spale74929212spale
spare75135562spare
spat66548522spat_
spates85028172spates
spathe115115692spathe
spats75031382spats
speise84614252speise
spic85227432spi_c
spica94717942spica
spicae104313702spicae
spicate113214192spicate
spiced115218312spiced
spicer104719312spicer
spices104326032spices
spicey134414232spicey
spick134519072spick
spics94123242spics
spicy125417712spicy
spider94516802spider
spied85427712spied
spiel74623912spiel
spier75728032spier
spies76037622spies
spiff133616402spiff
spik105419712spi_k
spiked134915552spiked
spiker124315662spiker
spikes124520712spikes
spikey155411332spikey
spiks114117472spiks
spiky146014112spiky
spiled94621992spiled
spiles84227912spiles
spill74821162spill
spilt75532222spilt
spilth11469732spilth
spin66231302spi_n
spinate93114812spinate
spined95423942spined
spinel85317332spinel
spines85132032spines
spinet85629752spinet
spins75327982spins
spinto8410662spinto
spiny104921302spiny
spirea84015632spirea
spired94921862spired
spirem104214162spirem
spires84628112spires
spirt75032952spirt
spirted103913072spirted
spirts85317132spirts
spiry105017352spiry
spital83813872spital
spitted103912702spitted
spitter94015182spitter
spittle937922spittle
spitzes1849182spitzes
spiv95917792spi_v
spivs105114242spivs
splice104915102splice
spline86020532spline
split75729012split_
splits85416412splits
spode84617702spode
spoke114818662spoke
spore75428592spore
spot65540692spot_
spots74424112spots
spree74830862spree
sprit76736402sprit_
sprites94220332sprites
sprits85122532sprits
spritz174714422spritz
sprue74717632sprue
spue66025522sp_ue
spume95817312spume
sputa74612962sputa
state56237332state
stile54931572stile
stime76521802stime
stipe76523372stipe
suit45649872suit_
suited74019422suited
suiter64121812suiter
suites63727402suites
suits55028052suits
supine84216692supine
swine85625302swine
swipe105217082swipe
swith115917402swith
swithe124010682swithe
swive115316192swive
trite54730032trite
unite54828382unite
white114920302white
wite75443272_wite
write85522832write

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.346516448.0
2DLD Change Limit538002161.62333148.5
3Display Results2162160.0633428.6
 (SQL Overall)1786912162.03287938.5
 
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.