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

265 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
spare7513556(None) 
pare66760841_pare
scare75334461scare
share86437081share
snare54429981snare
space95325671space
spade84423321spade
spae65034321spa_e
spake114322741spake
spale74929211spale
spar65433301spar_
spared95427491spared
sparer84524961sparer
spares84834551spares
sparge94216051sparge
spark114920891spark
spars75431541spars
sparse84516341sparse
spate74731581spate
spire75828691spire
spore75428591spore
stare54440261stare
sware85828211sware
apace94718382apace
apart74330672apart
are37874572__are
aspire8612122aspire
aware86420022aware
bare65460522_bare
blare75826232blare
care66968372_care
chare105231982chare
dare55848862_dare
fare76354462_fare
flare84823632flare
glare65222962glare
hare76255732_hare
mare64759332_mare
pace86345772_pace
padre86018162_padre
page76036102_page
pale66055012_pale
pane64950292_pane
par57467022_par_
para65242182_para
parae76335712_parae
pard76441322_pard
pared86946762_pared
pareo74632602_pareo
parer75839902_parer
pares77164482_pares
pareu74928742_pareu
parge85831852_parge
park105237492_park
parle75836162_parle
parr65731152_parr
pars67560792_pars
parse75236992_parse
part65967462_part
parve109824852_parve
pase65346862_pase
pate65350462_pate
pave96133892_pave
pere66450262_pere
pore66451262_pore
pure65543332_pure
pyre94925552_pyre
quare143920542quare
rare45348432_rare
sabe66140572s_abe
sabre74821502sabre
sade55544482s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sale44959702s_ale
same65245642s_ame
sane45954342s_ane
sard55344242s_ard
saree55044662s_aree
sarge65531132s_arge
sari45444042s_ari
sark84938972s_ark
sate45556102s_ate
save75741362s_ave
scale74629142scale
scape96921842scape
scar66434202scar_
scarce104013632scarce
scared95227292scared
scarer84524612scarer
scares85033002scares
scarey115016982scarey
scarf105427142scarf
scarp95724102scarp
scars75433532scars
scart76139772scart
scary105222592scary
score75526742score
sear47353842sear_
seared75232842seared
searer65432022searer
sears54744912sears
sere46153472s_ere
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
shard96125962shard
shared105829062shared
sharer95025482sharer
shares95236412shares
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shave114425892shave
shire84727132shire
shore85432652shore
sire46150422s_ire
skate94721552skate
slake93724052slake
slate55438282slate
slave84224032slave
smarm95517602smarm
smart75834092smart
smaze165012932smaze
snake94821112snake
snared74824552snared
snarer64620842snarer
snares65329032snares
snarf86525422snarf
snark95419942snark
snarl54921082snarl
snore55424952snore
soar46838672soar_
soared74324292soared
soarer64522242soarer
soars54732512soars
soave84219052soave
sore47059532s_ore
spa55730812spa__
spaced114517252spaced
spacer104917792spacer
spaces104722632spaces
spacey136212532spacey
spacy125415622spacy
spaded103816752spaded
spader94317132spader
spades94222582spades
spado83713702spado
spaed85522272spaed
spaes76029972spaes
spahee11313442spahee
spahi10311142spahi
spail74921552spail
spait75631602spait
spales84728102spales
spall74919302spall
spam85930042spa_m
spams94922192spams
span65234662spa_n
spang84919732spang
spank115919572spank
spans74528732spans
sparely123410672sparely
sparers94519612sparers
sparest94616432sparest
sparged113512762sparged
sparger103613082sparger
sparges104016342sparges
sparid94016932sparid
sparked143513142sparked
sparker133914362sparker
sparkle133710212sparkle
sparks124616362sparks
sparky154511522sparky
sparred104512862sparred
sparry115111302sparry
sparser94311482sparser
spas67036722spa_s
spasm94514172spasm
spat66548522spa_t
spates85028172spates
spathe115115692spathe
spats75031382spats
spavie113611382spavie
spawn107811712spawn
spay96631662spa_y
spayed124213612spayed
spays105520512spays
spaz155626162spa_z
spazz155811132spazz
spear75821062spear_
speared104314422speared
spearer93913662spearer
spears84019472spears
speer74623902speer
sperm93216022sperm
sphere113313662sphere
spice95528812spice
spier75728032spier
spike114922842spike
spile75230082spile
spine76534422spine
spirea84015632spirea
spired94921862spired
spirem104214162spirem
spires84628112spires
spirt75032952spirt
spiry105017352spiry
spite75430662spite
splake1259782splake
splore81611302splore
spode84617702spode
spoke114818662spoke
spored94821792spored
spores84726612spores
sport75935982sport
sprag86418692sprag
sprat76635972sprat
spray106720062spray
spree74830862spree
sprue74717632sprue
spry96819122sp_ry
spue66025522sp_ue
spume95817312spume
spur65321192spur_
spurge93711322spurge
spurn74815452spurn
spurs74621522spurs
spurt77227982spurt
square154513362square
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
star48037762star_
stared75429872stared
starer64027362starer
stares66038752stares
stark95425622stark
stars55836572stars
start55642312start
starve94613742starve
state56237332state
stave85324992stave
stere55328542stere
store56333812store
suave83519872suave
sucre75019102sucre
sure45447412s_ure
swage94919562swage
swale85221592swale
sward94221462sward
swarf115324652swarf
swarm106218842swarm
swart86234642swart
swore84920822swore
tare45957622_tare
urare56322552urare
ware76254722_ware
yare75636942_yare

Search took 2 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 Limit538002651.54634799.5
3Display Results2652650.0763486.8
 (SQL Overall)1786912651.93592346.8
 
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.