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

317 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
spa5573081(None) 
pa410456481_pa
sap56463231sap
sea36161291sea
sha69837781sha
ska76925861ska
spae65034321spae
spam85930041spam
span65234661span
spar65433301spar
spas67036721spas
spat66548521spat
spay96631661spay
spaz155626161spaz
spy86023741spy
aa219179952_aa
aba512850952aba
aga410447232aga
aha611246642aha
ala312463602ala
ama510853302ama
ana39559822ana
ape57251182ape
apo511142122apo
app76827602app
apt57352542apt
asea46327182asea
asp57235342asp_
asps65622092asps
ava610139322ava
awa611939672awa
ba49962342_ba
baa510650422baa
bap76455842bap
boa56954032boa
bra56339462bra
cap76758982cap
dap66652452dap
dopa77220902dopa
epha9310052epha
era35741502era
espy969372espy
eta35834192eta
fa510148452_fa
gap67055612gap
goa47343802goa
ha510259942_ha
hap87360052hap
isba61310882isba
ka69145082_ka
kapa106021292kapa
kea76540912kea
koa76737772koa
la219261632_la
lap58565272lap
lea37660182lea
lipa68425922lipa
ma410060652_ma
map77255112map
moa57249182moa
na28652482_na
nap56753202nap
napa66927262napa
nipa69421632nipa
oba57531552oba
oca56731732oca
oda48133042oda
oka76926802oka
op45850162op_
opah96218402opah
opal66923522opal
ope56845242ope
ops56641252ops
opt57545542opt
ora37250832ora
ossa43714162ossa
ova66823792ova
pac79054082_pac
pad68057322_pad
pah88853592_pah
pal56761672_pal
pam77858392_pam
pan58466442_pan
pap76758402_pap
papa85827142papa
par57467022_par
pas58775742_pas
pat58089462_pat
paw87651172_paw
pax127346852_pax
pay88461182_pay
pe47649032_pe
pea56657242pea
pi48145362_pi
pia56848032pia
psi56621622psi
pst57932512pst
pupa85422812pupa
pya87023752pya
qua124821972qua
rap56261962rap
ria36745502ria
rya67622012rya
sab56563202sab
sac57452862sac
sad47459202sad
sae38365182sae
sag46163402sag
saga55331172saga
sal36462882sal
salpa75018352salpa
saps65346372saps
sat36288482sat
sau36356572sau
saw68255352saw
sax107447642sax
say67264762say
scab85926712scab
scad75725762scad
scag76626892scag
scam85932352scam
scan65530452scan
scar66434202scar
scat65848372scat
seal45654372seal
seam66645972seam
sear47353842sear
seas45755272seas
seat47575562seat
sec55945322sec
see35772262see
seg45544882seg
sei36048932sei
sel38253322sel
sen36058522sen
sepal77723002sepal
sepia75318672sepia
sept65844362sept
septa75518082septa
ser36752402ser
sera46141392sera
set36681252set
seta45637312seta
sew66247262sew
sex107043222sex
sh56828522s_h
shad86230912shad
shag86430562shag
shah105627782shah
sham96436352sham
shat76456592shat
shaw108132552shaw
shay107133342shay
she66837692she
shea76031572shea
shh97121072shh
shwa106014962shwa
shy96728192shy
si29149572s_i
sial45938832sial
sib56850312sib
sic55847872sic
sika86021322sika
sim56553132sim
sima64730782sima
sin36265892sin
sip57656012sip
sipe67341042sipe
sips65740102sips
sir35746672sir
sis37360542sis
sit35877752sit
six105339742six
skag96321512skag
skas85325712skas
skat87037892skat
ski74925682ski
skua86113152skua
sky106420992sky
slab67133762slab
slag55934352slag
slam67737972slam
slap66434042slap
slat46959022slat
slaw77930712slaw
slay76436382slay
sly66228562sly
snag55827872snag
snap65727032snap
snaw78923072snaw
so28855442s_o
soak87227662soak
soap65831132soap
soar46838672soar
sob57857942sob
soba64927922soba
soca66330052soca
sod46053702sod
soda56329382soda
sofa75625602sofa
soja115619512soja
sol37256622sol
sola45541862sola
som59153802som
soma65635292soma
son37761952son
sop57557862sop
soph97024202soph
sops65244562sops
sora45746912sora
sos37761602sos
sot310384292sot
sou37853692sou
sow66554762sow
sox106444192sox
soy67851452soy
soya75724432soya
space95325672space
spacy125415622spacy
spade84423322spade
spado83713702spado
spaed85522272spaed
spaes76029972spaes
spahi10311142spahi
spail74921552spail
spait75631602spait
spake114322742spake
spale74929212spale
spall74919302spall
spams94922192spams
spang84919732spang
spank115919572spank
spans74528732spans
spare75135562spare
spark114920892spark
spars75431542spars
spasm94514172spasm
spate74731582spate
spats75031382spats
spawn107811712spawn
spays105520512spays
spazz155811132spazz
speak114618672speak
spean74620512spean
spear75821062spear
spec85821972spec
sped76031492sped
spew95421872spew
spic85227432spic
spica94717942spica
spik105419712spik
spin66231302spin
spit65545082spit
spiv95917792spiv
splat76129342splat
splay105816042splay
spot65540682spot
sprag86418692sprag
sprat76635972sprat
spray106720062spray
spry96819122spry
spud75818492spud
spue66025522spue
spun66221462spun
spur65321192spur
sputa74612962sputa
sri35634002sri
stab67329932stab
stag57332002stag
star48037762star
stat47352692stat
staw78627692staw
stay78333722stay
stoa45425912stoa
stupa74112312stupa
sty66227312sty
sub55445552sub
suba64926602suba
sue35651462sue
suk75632972suk
sum56346012sum
sun37149032sun
sup57041942sup
supe65932762supe
supra73614252supra
sups64834432sups
suq126228992suq
sura45740292sura
swab96825312swab
swag87526732swag
swam96329982swam
swan76631312swan
swap95925432swap
swat77244442swat
sway107128232sway
syn67024122syn
syph125413272syph
ta211662452_ta
tap57663872tap
tapa65129142tapa
tea37353322tea
tepa66021682tepa
twa67721642twa
up47832822up_
upas68322382upas
upo58925862upo
ups55629052ups
uta37425582uta
via65636242via
wap86553372wap
wha96422072wha
ya510251502_ya
yap85949822yap
yea66445752yea
za1114939202_za
zap145840692zap
zoa128529992zoa

Search took 1 second 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 Filter178691140840.0632836365.1
2DLD Change Limit140843170.51627294.6
3Display Results3173170.0764171.1
 (SQL Overall)1786913170.655272810.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.