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

323 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
spars7543154(None) 
pars67560791_pars
scars75433531scars
sears54744911sears
soars54732511soars
spaes76029971spaes
spams94922191spams
spans74528731spans
spar65433301spar_
spare75135561spare
spares84834551spares
spark114920891spark
sparks124616361sparks
sparse84516341sparse
spas67036721spa_s
spats75031381spats
spays105520511spays
spears84019471spears
spurs74621521spurs
stars55836571stars
afars85716512afars
agars66120642agars
apart74330672apart
apers76629132apers
ars37670932__ars
aspers86220312aspers
bars66564092_bars
bears75739042bears
boars75229602boars
cars67364762_cars
chars105936642chars
czars164812912czars
dears65736882dears
ears46356592_ears
escars83913132escars
eskars10357592eskars
fears84829392fears
fiars86720832fiars
gars55750742_gars
gears64628692gears
gnars66718852gnars
guars65021052guars
haars85620472haars
hears86737372hears
hoars85925552hoars
izars145112932izars
jars117338352_jars
kbars114612602kbars
knars94416112knars
kyars124813962kyars
lars46956572_lars
lears55938732lears
liars54723162liars
maars74621632maars
mars66261872_mars
nears55529422nears
oars46846032_oars
opahs105411982opahs
opals75718352opals
pacs85842182_pacs
pads76742952_pads
pairs75325832_pairs
pals66951352_pals
pams85641762_pams
pans65855732_pans
paps86443452_paps
par57467022_par_
para65242172_para
paras76143042_paras
pard76441322_pard
pards85634332_pards
pare66760842_pare
pares77164482_pares
paris75145942_paris
park105237492_park
parks116134462_parks
parr65731152_parr
parrs75928672_parrs
parse75236992_parse
part65967462_part
parts77743372_parts
pas58775742_pa_s
pass65239952_pass
pats66460852_pats
paws96038182_paws
pays95940222_pays
pears75138612pears
purs65641042_purs
rears54739652rears
roars55622242roars
sabs66643742s_abs
sacs65739072s_acs
sags55948402s_ags
sals46851672s_als
sans45153362s_ans
sapors84118812sapors
saps65346372s_aps
sard55344242s_ard
sards64736182s_ards
sari45444042s_ari
saris54544952s_aris
sark84938972s_ark
sarks96632462s_arks
saros55238062s_aros
sass45035622s_ass
saws75839482s_aws
says75942102s_ays
scabs94818642scabs
scads85419962scads
scags85520972scags
scams94423972scams
scans74625102scans
scar66434202scar_
scare75334462scare
scares85033002scares
scarf105427142scarf
scarfs114714682scarfs
scarp95724102scarp
scarps104718602scarps
scart76139772scart
scarts85321492scarts
scary105222592scary
scats75930602scats
scaurs85512052scaurs
seals54839702seals
seams75731662seams
sear47353842sear_
seas45755272sea_s
seats54844342seats
secpars1138412secpars
seers55136382seers
sepals85217382sepals
sers45746652s_ers
sewars94018632sewars
shads95124482shads
shags95123862shags
shahs115919512shahs
shams105829412shams
shard96125962shard
shards104319172shards
share86437082share
shares95236412shares
shark126225022shark
sharks135019722sharks
sharn84823702sharn
sharns95516982sharns
sharp104922532sharp
sharps115516082sharps
shaws116226262shaws
shays116021432shays
shears93820902shears
sials54227242sials
simars84916932simars
sirs44338332s_irs
sitars65417592sitars
sizars154812622sizars
skags104316072skags
skas85325712ska_s
skats94621542skats
slabs75322642slabs
slags66525902slags
slams74927902slams
slaps76025712slaps
slats55436902slats
slaws85222712slaws
slays85723682slays
slurs54123372slurs
smarm95517602smarm
smarms105712532smarms
smart75834092smart
smarts86218002smarts
smears84714432smears
snags64421312snags
snaps74719562snaps
snare54429982snare
snares65329032snares
snarf86525422snarf
snarfs95113422snarfs
snark95419942snark
snarks104815732snarks
snarl54921082snarl
snarls64016872snarls
snaws86116362snaws
soaks95220292soaks
soaps75120712soaps
soar46838672soar_
sofars94712782sofars
sonars64818972sonars
sopors85215202sopors
soras55041012soras
sours55230502sours
sowars94318012sowars
spa55730812spa__
space95325672space
spacers113813872spacers
spaces104722632spaces
spacy125415622spacy
spade84423322spade
spaders104214472spaders
spades94222582spades
spado83713702spado
spae65034322spa_e
spaed85522272spaed
spahi10311142spahi
spahis11310382spahis
spail74921552spail
spails84817822spails
spait75631602spait
spaits85017472spaits
spake114322742spake
spale74929212spale
spales84728102spales
spall74919302spall
spalls84217342spalls
spam85930042spa_m
span65234662spa_n
spang84919732spang
spank115919572spank
spanks124514122spanks
spared95427492spared
sparer84524962sparer
sparers94519612sparers
sparest94616432sparest
sparge94216052sparge
sparges104016342sparges
sparid94016932sparid
sparids103512122sparids
sparky154511522sparky
sparry115111302sparry
sparser94311482sparser
spasm94514172spasm
spasms10418972spasms
spat66548522spa_t
spate74731582spate
spates85028172spates
spawn107811712spawn
spawns11577922spawns
spay96631662spa_y
spaz155626162spa_z
spazz155811132spazz
speaks125114582speaks
speans85417142speans
spear75821062spear_
specs96916672specs
speers85019952speers
speirs85013232speirs
sperm93216022sperm
sperms102512602sperms
spews105015922spews
spics94123242spics
spiers84421742spiers
spies76037622spies
spiks114117472spiks
spins75327982spins
spire75828692spire
spires84628112spires
spirt75032952spirt
spirts85317132spirts
spiry105017352spiry
spits74429552spits
spivs105114242spivs
splats84817302splats
splays114910872splays
spoors84014032spoors
spore75428592spore
spores84726612spores
sport75935982sport
sports84619182sports
spots74424112spots
sprag86418692sprag
sprags95715822sprags
sprat76635972sprat
sprats85819932sprats
spray106720062spray
sprays115913642sprays
spry96819122sp_ry
spuds85113672spuds
spues75025382spues
spur65321192spur_
spurn74815452spurn
spurns84811382spurns
spurt77227982spurt
spurts84814972spurts
stabs76221382stabs
stags66226742stags
stairs65416332stairs
star48037762star_
stare54440262stare
stares66038752stares
stark95425622stark
start55642312start
starts65423122starts
stats55933362stats
stays86022022stays
stirs55921622stirs
suers55128482suers
sugars7312422sugars
supers84622402supers
suras55336332suras
swabs105817272swabs
swags94921252swags
swans84625012swans
swaps104819202swaps
sward94221462sward
swards105415132swards
sware85828212sware
swarf115324652swarf
swarfs125612062swarfs
swarm106218842swarm
swarms116112172swarms
swart86234642swart
swats85726862swats
sways115518462sways
swears94114072swears
tars46763952_tars
tears55436462tears
tsars56717112tsars
tzars144914272tzars
upas68322382upa_s
vars75742072_vars
wars78659802_wars
wears86030302wears
years84527672years

Search took 9 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.640279204.7
2DLD Change Limit538003236.4708315.3
3Display Results3233230.1861736.6
 (SQL Overall)1786913237.29624491.6
 
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.