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) 
site47052421s_ite
skite95120061skite
smite75224871smite
sopite84917711sopite
spate74731581spate
spice95528811spice
spike114922841spike
spile75230081spile
spine76534421spine
spire75828691spire
spit65545081spit_
spited94820441spited
spites84127331spites
spits74429551spits
spitz166017971spitz
sprite84421771sprite
suite54829561suite
aplite8316392aplite
aspire8612122aspire
axite125218252axite
bite66547012_bite
blite76225352blite
boite74426322boite
cite65640352_cite
despite10410122despite
dite55547562_dite
elite56230182elite
evite85317682evite
flite85424962flite
gite55438622_gite
kite85338252_kite
lite47054552_lite
mite66249422_mite
nite45943592_nite
ophite11410562ophite
opiate8513462opiate
opine77422462opine
pate65350462_pate
pice84641102_pice
pie55457412_pi_e
pike106335222_pike
pile65649702_pile
pine67755722_pine
pipe86434442_pipe
piste75824602_piste
pit56471932_pit_
pita65436442_pita
pith95432702_pith
pits66348752_pits
pity96031942_pity
quite144621462quite
respite9513032respite
rite45849462_rite
saice75424052saice
saith85826552saith
saithe94713912saithe
samite83020602samite
sapote8314362sapote
sate45556102s_ate
saute55028082saute
scute75520942scute
seine55732872seine
seise54727852seise
seize143819502seize
sente56432882sente
shine85533092shine
shire84727132shire
shit76745942shit_
shits84731172shits
shive114423422shive
shote85526102shote
shute84520352shute
sice65545602s_ice
side55444502s_ide
sike87138792s_ike
sine46560632s_ine
sipe67341052s_ipe
sire46150422s_ire
sit35877762s_it_
sited65130742s_ited
sites56045432s_ites
sith75435162s_ith
sits45050212s_its
sixte126216582sixte
size135630972s_ize
skate94721552skate
skit85437542skit_
skited114313482skited
skites104418042skites
skits94721872skits
skive124614122skive
slate55438282slate
slice74925822slice
slide64725422slide
slime74925752slime
slipe75626132slipe
slit46250102slit_
slits56128852slits
smile74823922smile
smit65138412smit_
smiter83616412smiter
smites83921922smites
smith107818052smith
smote75820282smote
snide64318732snide
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
wite75443282_wite
write85522832write

Search took 4 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.360496363.9
2DLD Change Limit538002161.93627789.3
3Display Results2162160.0762842.1
 (SQL Overall)1786912162.37275333.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.