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

295 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
spae6503432(None) 
sae38365181s_ae
spa55730811spa_
space95325671space
spade84423321spade
spaed85522271spaed
spaes76029971spaes
spake114322741spake
spale74929211spale
spam85930041spam
span65234661span
spar65433301spar
spare75135561spare
spas67036721spas
spat66548521spat
spate74731581spate
spay96631661spay
spaz155626161spaz
spue66025521spue
ae212590292__ae
alae45643752alae
apace94718382apace
ape57251182ap_e
apse67725382apse
blae66134642blae
brae65639112brae
cape87242782cape
epee64628502epee
frae75330472frae
gae46457702_gae
gape75134512gape
hae67364002_hae
jape134923422jape
kae76744542_kae
mae57659112_mae
nae35952742_nae
nape65230802nape
opah96218402opah
opal66923522opal
ope56845242op_e
pa410456482_pa_
pac79054082_pac
pace86345772_pace
pad68057322_pad
page76036102_page
pah88853592_pah
pal56761672_pal
pale66055012_pale
pam77858392_pam
pan58466452_pan
pane64950292_pane
pap76758402_pap
par57467022_par
pare66760842_pare
pas58775742_pas
pase65346862_pase
pat58089462_pat
pate65350462_pate
pave96133892_pave
paw87651172_paw
pax127346852_pax
pay88461182_pay
pe47649032_p_e
pea56657242_pea
pee56066512_pee
pie55457402_pie
psoae74411622psoae
pupae96515642pupae
pye86432502_pye
rape65041632rape
sab56563202s_ab
sabe66140572sabe
sac57452862s_ac
sad47459202s_ad
sade55544472sade
safe75930952safe
sag46163402s_ag
sage55044592sage
sake85244962sake
sal36462882s_al
sale44959702sale
salpae84614272salpae
same65245642same
sane45954342sane
sap56463232s_ap
saps65346372saps
sat36288482s_at
sate45556102sate
sau36356572s_au
save75741362save
saw68255352s_aw
sax107447642s_ax
say67264762s_ay
scab85926712scab
scad75725772scad
scag76626892scag
scale74629142scale
scam85932352scam
scan65530452scan
scape96921842scape
scar66434202scar
scare75334462scare
scat65848372scat
sea36161292sea_
seal45654372seal
seam66645972seam
sear47353842sear
seas45755272seas
seat47575562seat
see35772262s_ee
seme65836652seme
sene46848052sene
sepal77723002sepal
sere46153472sere
setae56026222setae
sha69837782sha_
shad86230912shad
shade95125582shade
shag86430562shag
shah105627782shah
shake124726402shake
shale85332832shale
sham96436362sham
shame105726702shame
shape105125112shape
share86437082share
shat76456602shat
shave114425892shave
shaw108132552shaw
shay107133342shay
she66837692s_he
shea76031572shea
shoe75933442shoe
sial45938832sial
sice65545592sice
side55444492side
sike87138782sike
sine46560622sine
sipe67341042sipe
sire46150412sire
site47052412site
size135630962size
ska76925862ska_
skag96321512skag
skas85325712skas
skat87037902skat
skate94721552skate
skee85431472skee
slab67133762slab
slag55934352slag
slake93724052slake
slam67737972slam
slap66434042slap
slat46959022slat
slate55438282slate
slave84224032slave
slaw77930712slaw
slay76436382slay
sloe45534952sloe
slue45332192slue
smaze165012932smaze
snag55827872snag
snake94821112snake
snap65727032snap
snare54429982snare
snaw78923072snaw
snye77115492snye
soak87227662soak
soap65831132soap
soar46838672soar
soave84219052soave
soke85436262soke
sole46053672sole
some66040382some
sone46649982sone
sore47059532sore
spaced114517252spaced
spacer104917792spacer
spaces104722632spaces
spacey136212532spacey
spacy125415622spacy
spaded103816752spaded
spader94317132spader
spades94222582spades
spado83713702spado
spahee11313442spahee
spahi10311142spahi
spail74921552spail
spait75631602spait
spales84728102spales
spall74919302spall
spams94922192spams
spang84919732spang
spank115919572spank
spans74528732spans
spared95427492spared
sparer84524962sparer
spares84834552spares
sparge94216052sparge
spark114920892spark
spars75431542spars
sparse84516342sparse
spasm94514172spasm
spates85028172spates
spathe115115692spathe
spats75031382spats
spavie113611382spavie
spawn107811712spawn
spayed124213612spayed
spays105520512spays
spazz155811132spazz
speak114618672speak
spean74620512spean
spear75821062spear
spec85821972spec
sped76031492sped
speed85526622speed
speel74420762speel
speer74623902speer
spew95421872spew
spic85227432spic
spicae104313702spicae
spice95528812spice
spied85427712spied
spiel74623912spiel
spier75728032spier
spies76037622spies
spik105419712spik
spike114922842spike
spile75230082spile
spin66231302spin
spine76534422spine
spire75828692spire
spit65545082spit
spite75430662spite
spiv95917792spiv
splake1259782splake
splat76129342splat
splay105816042splay
spode84617702spode
spoke114818662spoke
spore75428592spore
spot65540692spot
sprag86418692sprag
sprat76635972sprat
spray106720062spray
spree74830862spree
sprue74717632sprue
spry96819122spry
spud75818492spud
spued84918472spued
spues75025382spues
spume95817312spume
spun66221462spun
spur65321192spur
spy86023742sp_y
stab67329932stab
stade64825302stade
stag57332002stag
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
star48037762star
stare54440262stare
stat47352692stat
state56237332state
stave85324992stave
staw78627692staw
stay78333722stay
stoae55024262stoae
stye76218972stye
suave83519872suave
sue35651462s_ue
supe65932762supe
sure45447412sure
swab96825312swab
swag87526732swag
swage94919562swage
swale85221592swale
swam96329982swam
swan76631312swan
swap95925432swap
sware85828212sware
swat77244442swat
sway107128232sway
syce95820282syce
syke115420562syke
syne75725762syne
tae38267052_tae
tape64538142tape
thae76825562thae
twae74719572twae
upas68322382upas
wae67556952_wae

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 Filter178691298720.296603685.8
2DLD Change Limit298722950.89033564.0
3Display Results2952950.0803687.5
 (SQL Overall)1786912951.266141146.1
 
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.