Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “spas” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

400 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
spas	6	70	3672	(None)
pas	5	87	7574	1	_pas
saps	6	53	4637	1	saps
seas	4	57	5527	1	seas
skas	8	53	2571	1	skas
spa	5	57	3081	1	spa_
spae	6	50	3432	1	spae
spaes	7	60	2997	1	spaes
spam	8	59	3004	1	spam
spams	9	49	2219	1	spams
span	6	52	3466	1	span
spans	7	45	2873	1	spans
spar	6	54	3330	1	spar
spars	7	54	3154	1	spars
spasm	9	45	1417	1	spasm
spat	6	65	4852	1	spat
spats	7	50	3138	1	spats
spay	9	66	3166	1	spay
spays	10	55	2051	1	spays
spaz	15	56	2616	1	spaz
upas	6	83	2238	1	upas
aas	3	109	7539	2	_aas
abas	6	86	4208	2	abas
agas	5	59	3884	2	agas
alas	4	63	5812	2	alas
amas	6	77	4629	2	amas
anas	4	66	4986	2	anas
apes	6	60	4743	2	apes
apos	6	54	3382	2	apos
apps	8	63	1969	2	apps
as	2	110	8307	2	__as
aspis	7	46	1814	2	aspis
asps	6	56	2209	2	asp_s
baas	6	68	4467	2	baas
baps	8	60	4084	2	baps
bas	5	86	8175	2	_bas
bias	6	47	3815	2	bias
boas	6	61	5083	2	boas
bras	6	57	4645	2	bras
caps	8	71	4789	2	caps
daps	7	72	3916	2	daps
dopas	8	50	1906	2	dopas
ephas	10	3	1154	2	ephas
epos	6	67	2373	2	epos
eras	4	54	4150	2	eras
etas	4	64	3227	2	etas
eyas	7	64	2743	2	eyas
fas	6	82	6293	2	_fas
gaps	7	60	4297	2	gaps
gas	4	88	7025	2	_gas
goas	5	52	3994	2	goas
haps	9	64	4346	2	haps
has	6	73	7265	2	_has
isbas	7	10	1039	2	isbas
kaas	8	65	3184	2	kaas
kapas	11	60	2173	2	kapas
kas	7	70	5858	2	_kas
keas	8	63	3709	2	keas
koas	8	56	3509	2	koas
kvas	11	70	1594	2	kvas
laps	6	68	4887	2	laps
las	3	72	8147	2	_las
leas	4	59	5418	2	leas
maps	8	61	4104	2	maps
mas	5	81	7581	2	_mas
moas	6	55	4534	2	moas
napas	7	59	2435	2	napas
naps	6	62	3858	2	naps
nipas	7	71	1667	2	nipas
obas	6	57	3093	2	obas
ocas	6	67	2963	2	ocas
odas	5	72	3026	2	odas
okas	8	52	2539	2	okas
opah	9	62	1840	2	opah
opahs	10	54	1198	2	opahs
opal	6	69	2352	2	opal
opals	7	57	1835	2	opals
opes	6	59	4261	2	opes
ops	5	66	4125	2	op_s
opts	6	81	2474	2	opts
opus	6	64	2059	2	opus
pa	4	104	5648	2	_pa_
pac	7	90	5408	2	_pac
pacs	8	58	4218	2	_pacs
pad	6	80	5732	2	_pad
pads	7	67	4295	2	_pads
pah	8	88	5359	2	_pah
pal	5	67	6167	2	_pal
pals	6	69	5135	2	_pals
pam	7	78	5839	2	_pam
pams	8	56	4176	2	_pams
pan	5	84	6644	2	_pan
pans	6	58	5572	2	_pans
pap	7	67	5840	2	_pap
papas	9	49	2749	2	papas
paps	8	64	4345	2	_paps
par	5	74	6702	2	_par
pars	6	75	6079	2	_pars
pase	6	53	4686	2	_pase
pash	9	56	3813	2	_pash
pass	6	52	3995	2	_pass
past	6	59	5901	2	_past
pat	5	80	8946	2	_pat
pats	6	64	6085	2	_pats
paw	8	76	5117	2	_paw
paws	9	60	3818	2	_paws
pax	12	73	4685	2	_pax
pay	8	84	6118	2	_pay
pays	9	59	4022	2	_pays
peas	6	57	5506	2	peas
pes	5	72	5978	2	_pes
pias	6	65	4255	2	pias
pis	5	63	6203	2	_pis
psis	6	81	2034	2	psis
psoas	7	50	1298	2	psoas
pupas	9	52	1928	2	pupas
pus	5	55	4784	2	_pus
pyas	9	62	2570	2	pyas
raps	6	62	4773	2	raps
ras	3	75	7539	2	_ras
rias	4	55	4059	2	rias
ryas	7	72	2461	2	ryas
sab	5	65	6320	2	s_ab
sabs	6	66	4374	2	sabs
sac	5	74	5286	2	s_ac
sacs	6	57	3907	2	sacs
sad	4	74	5920	2	s_ad
sae	3	83	6518	2	s_ae
sag	4	61	6340	2	s_ag
sagas	6	60	2588	2	sagas
sags	5	59	4840	2	sags
sal	3	64	6288	2	s_al
salpas	8	51	1692	2	salpas
sals	4	68	5167	2	sals
sans	4	51	5335	2	sans
sap	5	64	6323	2	s_ap
sash	7	72	3530	2	s_ash
sass	4	50	3562	2	sass
sat	3	62	8848	2	s_at
sau	3	63	5657	2	s_au
saw	6	82	5535	2	s_aw
saws	7	58	3948	2	saws
sax	10	74	4764	2	s_ax
say	6	72	6476	2	s_ay
says	7	59	4210	2	says
scab	8	59	2671	2	scab
scabs	9	48	1864	2	scabs
scad	7	57	2576	2	scad
scads	8	54	1995	2	scads
scag	7	66	2689	2	scag
scags	8	55	2097	2	scags
scam	8	59	3235	2	scam
scams	9	44	2397	2	scams
scan	6	55	3045	2	scan
scans	7	46	2510	2	scans
scar	6	64	3420	2	scar
scars	7	54	3353	2	scars
scat	6	58	4837	2	scat
scats	7	59	3060	2	scats
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seals	5	48	3969	2	seals
seam	6	66	4597	2	seam
seams	7	57	3166	2	seams
sear	4	73	5384	2	sear
sears	5	47	4491	2	sears
seat	4	75	7556	2	seat
seats	5	48	4434	2	seats
secs	6	50	3389	2	secs
sees	4	53	6105	2	sees
segs	5	49	3388	2	segs
seis	4	55	4239	2	seis
sels	4	63	4598	2	sels
sepal	7	77	2300	2	sepal
sepals	8	52	1737	2	sepals
sepias	8	36	1610	2	sepias
septs	7	54	2060	2	septs
sers	4	57	4665	2	sers
sets	4	55	4950	2	sets
sews	7	58	3602	2	sews
sha	6	98	3778	2	sha_
shad	8	62	3091	2	shad
shads	9	51	2448	2	shads
shag	8	64	3056	2	shag
shags	9	51	2386	2	shags
shah	10	56	2778	2	shah
shahs	11	59	1951	2	shahs
sham	9	64	3635	2	sham
shams	10	58	2941	2	shams
shat	7	64	5659	2	shat
shaw	10	81	3255	2	shaw
shaws	11	62	2626	2	shaws
shay	10	71	3334	2	shay
shays	11	60	2143	2	shays
sheas	8	63	3179	2	sheas
shes	7	57	3435	2	shes
shwas	11	64	1510	2	shwas
sial	4	59	3883	2	sial
sials	5	42	2724	2	sials
sibs	6	59	3353	2	sibs
sics	6	52	3409	2	sics
sikas	9	46	1702	2	sikas
simas	7	57	2755	2	simas
sims	6	57	3717	2	sims
sins	4	67	5527	2	sins
sipes	7	60	3695	2	sipes
sips	6	57	4010	2	sips
sirs	4	43	3833	2	sirs
sis	3	73	6054	2	s_is
sits	4	50	5020	2	sits
ska	7	69	2586	2	ska_
skag	9	63	2151	2	skag
skags	10	43	1607	2	skags
skat	8	70	3789	2	skat
skats	9	46	2153	2	skats
skis	8	48	2528	2	skis
skuas	9	56	1173	2	skuas
slab	6	71	3376	2	slab
slabs	7	53	2264	2	slabs
slag	5	59	3435	2	slag
slags	6	65	2590	2	slags
slam	6	77	3797	2	slam
slams	7	49	2790	2	slams
slap	6	64	3404	2	slap
slaps	7	60	2571	2	slaps
slash	8	47	1968	2	slash
slat	4	69	5902	2	slat
slats	5	54	3690	2	slats
slaw	7	79	3071	2	slaw
slaws	8	52	2271	2	slaws
slay	7	64	3638	2	slay
slays	8	57	2368	2	slays
smash	10	48	1443	2	smash
snag	5	58	2787	2	snag
snags	6	44	2131	2	snags
snap	6	57	2703	2	snap
snaps	7	47	1956	2	snaps
snash	8	48	1567	2	snash
snaw	7	89	2307	2	snaw
snaws	8	61	1636	2	snaws
soak	8	72	2766	2	soak
soaks	9	52	2029	2	soaks
soap	6	58	3113	2	soap
soaps	7	51	2071	2	soaps
soar	4	68	3867	2	soar
soars	5	47	3251	2	soars
sobas	7	44	2425	2	sobas
sobs	6	49	4175	2	sobs
socas	7	40	2618	2	socas
sodas	6	41	2354	2	sodas
sods	5	49	4021	2	sods
sofas	8	53	2071	2	sofas
sojas	12	47	1639	2	sojas
sols	4	54	4816	2	sols
somas	7	60	3037	2	somas
soms	6	62	3937	2	soms
sons	4	60	4955	2	sons
sophs	10	49	1602	2	sophs
sops	6	52	4456	2	sops
soras	5	50	4101	2	soras
sos	3	77	6160	2	s_os
sots	4	55	5244	2	sots
sous	4	69	4721	2	sous
sows	7	53	4249	2	sows
soyas	8	45	2091	2	soyas
soys	7	52	3393	2	soys
space	9	53	2567	2	space
spaces	10	47	2263	2	spaces
spacy	12	54	1562	2	spacy
spade	8	44	2332	2	spade
spades	9	42	2258	2	spades
spado	8	37	1370	2	spado
spaed	8	55	2227	2	spaed
spahi	10	3	1114	2	spahi
spahis	11	3	1038	2	spahis
spail	7	49	2155	2	spail
spails	8	48	1782	2	spails
spait	7	56	3160	2	spait
spaits	8	50	1747	2	spaits
spake	11	43	2274	2	spake
spale	7	49	2921	2	spale
spales	8	47	2810	2	spales
spall	7	49	1930	2	spall
spalls	8	42	1734	2	spalls
spang	8	49	1973	2	spang
spank	11	59	1957	2	spank
spanks	12	45	1412	2	spanks
spare	7	51	3556	2	spare
spares	8	48	3455	2	spares
spark	11	49	2089	2	spark
sparks	12	46	1636	2	sparks
sparse	8	45	1634	2	sparse
spasms	10	41	897	2	spasms
spate	7	47	3158	2	spate
spates	8	50	2817	2	spates
spawn	10	78	1171	2	spawn
spawns	11	57	792	2	spawns
spazz	15	58	1113	2	spazz
speak	11	46	1867	2	speak
speaks	12	51	1458	2	speaks
spean	7	46	2051	2	spean
speans	8	54	1714	2	speans
spear	7	58	2106	2	spear
spears	8	40	1947	2	spears
spec	8	58	2197	2	spec
specs	9	69	1667	2	specs
sped	7	60	3149	2	sped
spew	9	54	2187	2	spew
spews	10	50	1592	2	spews
spic	8	52	2743	2	spic
spicas	10	47	1582	2	spicas
spics	9	41	2324	2	spics
spies	7	60	3762	2	spies
spik	10	54	1971	2	spik
spiks	11	41	1747	2	spiks
spin	6	62	3130	2	spin
spins	7	53	2798	2	spins
spit	6	55	4508	2	spit
spits	7	44	2955	2	spits
spiv	9	59	1779	2	spiv
spivs	10	51	1424	2	spivs
splash	11	6	882	2	splash
splat	7	61	2934	2	splat
splats	8	48	1730	2	splats
splay	10	58	1604	2	splay
splays	11	49	1087	2	splays
spot	6	55	4068	2	spot
spots	7	44	2410	2	spots
sprag	8	64	1869	2	sprag
sprags	9	57	1582	2	sprags
sprat	7	66	3597	2	sprat
sprats	8	58	1993	2	sprats
spray	10	67	2006	2	spray
sprays	11	59	1364	2	sprays
spry	9	68	1912	2	spry
spud	7	58	1849	2	spud
spuds	8	51	1367	2	spuds
spue	6	60	2552	2	spue
spues	7	50	2538	2	spues
spun	6	62	2146	2	spun
spur	6	53	2119	2	spur
spurs	7	46	2152	2	spurs
spy	8	60	2374	2	sp_y
sris	4	54	3415	2	sris
stab	6	73	2993	2	stab
stabs	7	62	2138	2	stabs
stag	5	73	3200	2	stag
stags	6	62	2674	2	stags
star	4	80	3776	2	star
stars	5	58	3657	2	stars
stash	8	49	1697	2	stash
stat	4	73	5269	2	stat
stats	5	59	3336	2	stats
staw	7	86	2769	2	staw
stay	7	83	3372	2	stay
stays	8	60	2202	2	stays
stoas	5	51	2602	2	stoas
stupas	8	39	1088	2	stupas
subas	7	47	2407	2	subas
subs	6	60	3712	2	subs
suds	5	61	3529	2	suds
sues	4	62	4765	2	sues
suks	8	59	2712	2	suks
sums	6	58	3758	2	sums
suns	4	58	4190	2	suns
supes	7	56	2830	2	supes
sups	6	48	3443	2	sups
suqs	13	43	1965	2	suqs
suras	5	53	3632	2	suras
suss	4	52	2930	2	suss
swab	9	68	2531	2	swab
swabs	10	58	1727	2	swabs
swag	8	75	2673	2	swag
swags	9	49	2125	2	swags
swam	9	63	2998	2	swam
swan	7	66	3131	2	swan
swans	8	46	2501	2	swans
swap	9	59	2543	2	swap
swaps	10	48	1920	2	swaps
swash	11	63	1675	2	swash
swat	7	72	4444	2	swat
swats	8	57	2686	2	swats
sway	10	71	2823	2	sway
sways	11	55	1846	2	sways
syphs	13	51	945	2	syphs
tapas	7	46	2771	2	tapas
taps	6	60	5067	2	taps
tas	3	84	7710	2	_tas
teas	4	58	5149	2	teas
tepas	7	65	2168	2	tepas
twas	7	68	2408	2	twas
ups	5	56	2905	2	up_s
utas	4	59	2495	2	utas
vas	6	77	5577	2	_vas
waps	9	66	4208	2	waps
was	6	87	6756	2	_was
yaps	9	59	3352	2	yaps
yeas	7	86	3842	2	yeas
zaps	15	68	2689	2	zaps
zas	12	69	4683	2	_zas

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	29872	0.076	2351197.4
2	DLD Change Limit	29872	400	1.000	29872.0
3	Display Results	400	400	0.093	4301.1
	(SQL Overall)	178691	400	1.169	152858.0