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

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

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

329 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
stanza	15	3	707	(None)
stanzas	16	3	636	1	stanzas
kwanza	22	3	247	2	kwanza
sanga	6	60	2380	2	s_anga
stadia	7	3	1214	2	stadia
stance	8	43	1691	2	stance
stanch	11	38	1237	2	stanch
stand	6	59	2328	2	stan_d
stands	7	51	1805	2	stands
stane	5	59	3300	2	stan_e
staned	7	48	2464	2	staned
stanes	6	49	3340	2	stanes
stang	6	64	2469	2	stan_g
stangs	7	50	1817	2	stangs
stank	9	58	2330	2	stan_k
stanks	10	49	1770	2	stanks
stanol	6	3	1072	2	stanol
stanzaed	18	4	387	2	stanzaed
stanzaic	19	4	336	2	stanzaic
tanga	6	49	2371	2	_tanga
tanka	9	38	1749	2	_tanka
tazza	13	3	808	2	_tazza
zanza	13	7	870	2	_zanza
ana	3	95	5983	3	__an_a
anga	5	68	3136	3	__anga
anna	4	55	2901	3	__anna
anoa	4	56	3447	3	__anoa
ansa	4	59	2777	3	__ansa
anta	4	68	3958	3	__anta
asana	5	3	1548	3	asan_a
astasia	7	3	1093	3	astasia
ataxia	13	17	959	3	ataxia
atonia	6	38	1651	3	atonia
baiza	16	48	1322	3	_baiza
banda	8	52	2311	3	_banda
banzai	17	3	765	3	_banzai
bonanza	18	4	384	3	bonanza
braza	16	52	1425	3	bra_za
bwana	10	3	1024	3	bwan_a
canna	7	59	1933	3	_canna
crania	8	24	1843	3	crania
estancia	10	4	488	3	estancia
etna	4	64	1526	3	et_n_a
fanga	9	61	1963	3	_fanga
ganja	13	14	1000	3	_ganja
goanna	7	3	665	3	goanna
grana	6	57	2209	3	gran_a
hamza	19	13	977	3	_hamza
hansa	8	54	1678	3	_hansa
jnana	12	15	904	3	jnan_a
kana	8	59	2853	3	_kan_a
kanzu	18	4	759	3	_kanzu
kwanzas	23	4	205	3	kwanzas
liana	5	39	1589	3	lian_a
mana	6	53	4196	3	_man_a
manga	8	50	2621	3	_manga
mania	7	56	3415	3	_mania
manna	7	55	2254	3	_manna
manta	7	56	2991	3	_manta
matza	16	3	1181	3	_matza
nana	4	66	3290	3	_nan_a
organza	17	9	346	3	organza
panda	8	50	2261	3	_panda
panga	8	53	2354	3	_panga
piazza	16	4	382	3	piazza
plaza	16	43	1106	3	pla_za
quanta	15	39	1133	3	quanta
ruana	5	3	1242	3	ruan_a
sabra	7	53	1785	3	s_abra
sacra	7	45	1699	3	s_acra
saga	5	53	3117	3	s_a_ga
saiga	6	47	1793	3	s_aiga
salpa	7	50	1835	3	s_alpa
salsa	5	67	1892	3	s_alsa
samba	9	56	1877	3	s_amba
sancta	8	3	983	3	s_ancta
sand	5	53	3847	3	s_an_d
sandal	7	33	1728	3	s_andal
sands	6	52	2858	3	s_ands
sandy	9	42	2113	3	s_andy
sane	4	59	5434	3	s_an_e
saned	6	56	3627	3	s_aned
saner	5	43	3432	3	s_aner
sanes	5	56	4907	3	s_anes
sang	5	54	4124	3	s_an_g
sangar	7	36	1769	3	s_angar
sangas	7	52	2266	3	s_angas
sangh	9	55	1746	3	s_angh
sanjak	17	3	569	3	s_anjak
sank	8	52	3683	3	s_an_k
sans	4	51	5336	3	s_an_s
sansar	6	36	1339	3	s_ansar
santo	5	62	2728	3	s_anto
satang	7	57	1156	3	satan_g
satangs	8	47	971	3	satangs
satanic	9	3	993	3	satanic
satara	6	3	1553	3	satara
sauna	5	41	1755	3	s_auna
savanna	10	4	371	3	savanna
scan	6	55	3045	3	scan__
scandal	10	3	867	3	scandal
scandia	10	3	806	3	scandia
scans	7	46	2510	3	scan_s
scant	7	97	3507	3	scan_t
scants	8	52	1972	3	scants
scanty	11	40	1466	3	scanty
scena	7	48	1578	3	scen_a
seance	8	37	1669	3	seance
senna	5	46	1798	3	s_enna
sensa	5	41	1747	3	s_ensa
shandy	13	47	1003	3	shandy
shank	12	54	2219	3	shan_k
shanks	13	53	1558	3	shanks
shanny	12	41	1009	3	shanny
shanti	9	40	1409	3	shanti
shanty	12	47	1512	3	shanty
sharia	9	31	1673	3	sharia
shazam	20	4	662	3	sha_zam
sienna	6	4	719	3	sienna
signa	6	61	1470	3	sign_a
skank	8	44	1558	3	skan_k
skanks	9	47	1083	3	skanks
skanky	12	47	696	3	skanky
slang	6	63	2402	3	slan_g
slangs	7	56	1534	3	slangs
slangy	10	54	1139	3	slangy
slank	9	58	2277	3	slan_k
slant	5	52	3870	3	slan_t
slants	6	48	1908	3	slants
slanty	9	51	1484	3	slanty
smaze	16	50	1293	3	sma_ze
snazzy	17	3	401	3	snazzy
sonata	6	3	1322	3	sonata
span	6	52	3466	3	span__
spang	8	49	1973	3	span_g
spank	11	59	1957	3	span_k
spanks	12	45	1412	3	spanks
spans	7	45	2873	3	span_s
spaz	15	56	2616	3	spa_z_
spazz	15	58	1113	3	spa_zz
sradha	10	8	533	3	sradha
stab	6	73	2993	3	sta__b
stable	8	39	2164	3	stable
stably	11	33	1412	3	stably
stabs	7	62	2138	3	sta_bs
stack	11	44	2169	3	sta_ck
stacks	12	43	1726	3	stacks
stacte	8	21	1391	3	stacte
stade	6	48	2530	3	sta_de
stades	7	46	2624	3	stades
stadias	8	4	1111	3	stadias
staff	11	38	1771	3	sta_ff
staffs	12	34	975	3	staffs
stag	5	73	3200	3	sta__g
stage	6	53	3019	3	sta_ge
staged	8	45	2156	3	staged
stager	7	48	2134	3	stager
stages	7	56	2949	3	stages
stagey	10	59	1558	3	stagey
staggy	11	55	1039	3	staggy
stags	6	62	2674	3	sta_gs
stagy	9	66	1889	3	sta_gy
staid	6	67	2208	3	sta_id
staig	6	55	1964	3	sta_ig
staigs	7	54	1481	3	staigs
stain	5	57	2794	3	sta_in
stained	8	42	1534	3	stained
stainer	7	36	1492	3	stainer
stains	6	49	2365	3	stains
stair	5	47	1994	3	sta_ir
stairs	6	54	1633	3	stairs
stake	9	59	2753	3	sta_ke
staked	11	46	2194	3	staked
stakes	10	39	2729	3	stakes
stalag	7	3	1002	3	stalag
stale	5	56	3710	3	sta_le
staled	7	47	2810	3	staled
staler	6	40	2582	3	staler
stales	6	55	3829	3	stales
stalk	9	45	1800	3	sta_lk
stalks	10	46	1455	3	stalks
stalky	13	49	930	3	stalky
stall	5	47	2235	3	sta_ll
stalls	6	40	1993	3	stalls
stamen	8	41	1594	3	stamen
stamina	9	3	1079	3	stamina
stamp	9	52	1736	3	sta_mp
stamps	10	56	1402	3	stamps
stances	9	37	1596	3	stances
standard	10	4	625	3	standard
standby	13	3	442	3	standby
standee	8	35	1451	3	standee
stander	8	43	1616	3	stander
standpat	11	4	572	3	standpat
standup	10	3	435	3	standup
stanged	9	41	1385	3	stanged
stanine	7	34	1707	3	stanine
staning	8	39	2224	3	staning
stannary	11	4	461	3	stannary
stannic	9	3	666	3	stannic
stannum	9	4	464	3	stannum
stanols	7	3	973	3	stanols
stapes	8	50	2873	3	stapes
staph	10	43	1465	3	sta_ph
staphs	11	44	1103	3	staphs
staple	8	44	1582	3	staple
star	4	80	3776	3	sta__r
starch	11	30	1320	3	starch
stare	5	44	4026	3	sta_re
stared	7	54	2987	3	stared
starer	6	40	2736	3	starer
stares	6	60	3875	3	stares
stark	9	54	2562	3	sta_rk
starry	9	49	1167	3	starry
stars	5	58	3657	3	sta_rs
start	5	56	4231	3	sta_rt
starts	6	54	2312	3	starts
starve	9	46	1374	3	starve
stases	6	42	2556	3	stases
stash	8	49	1697	3	sta_sh
stasima	9	5	563	3	stasima
stasis	6	31	1687	3	stasis
stat	4	73	5269	3	sta__t
statal	6	16	1322	3	statal
state	5	62	3733	3	sta_te
stated	7	54	2783	3	stated
stater	6	44	2756	3	stater
states	6	43	3708	3	states
static	8	31	1868	3	static
statin	6	39	2147	3	statin
stator	6	40	1548	3	stator
stats	5	59	3336	3	sta_ts
statue	6	60	1532	3	statue
status	6	55	1521	3	status
staunch	12	4	427	3	staunch
stave	8	53	2499	3	sta_ve
staved	10	39	1805	3	staved
staves	9	45	2519	3	staves
staw	7	86	2769	3	sta__w
stay	7	83	3372	3	sta__y
stayed	10	48	1727	3	stayed
stayer	9	45	1648	3	stayer
stays	8	60	2202	3	sta_ys
stela	5	40	1904	3	st_ela
stella	6	36	1297	3	stella
stemma	10	32	813	3	stemma
stench	11	41	1116	3	stench
stengah	11	4	456	3	stengah
steno	5	47	1686	3	sten_o
stenos	6	39	1577	3	stenos
stent	5	56	3451	3	sten_t
stents	6	50	1945	3	stents
sterna	6	37	1276	3	sterna
sthenia	10	5	850	3	sthenia
stigma	9	22	676	3	stigma
sting	6	53	3024	3	stin_g
stingo	7	42	1216	3	stingo
stings	7	62	2018	3	stings
stingy	10	52	1320	3	stingy
stink	9	51	2250	3	stin_k
stinko	10	49	939	3	stinko
stinks	10	56	1683	3	stinks
stinky	13	46	1107	3	stinky
stint	5	70	3766	3	stin_t
stints	6	51	1976	3	stints
stoa	4	54	2591	3	st__oa
stoma	7	59	1827	3	st_oma
stone	5	54	3118	3	ston_e
stoned	7	59	2314	3	stoned
stoner	6	58	2320	3	stoner
stones	6	51	3003	3	stones
stoney	9	62	1735	3	stoney
stony	8	58	1864	3	ston_y
strand	7	45	1482	3	stran_d
strands	8	37	1195	3	strands
strang	7	57	1831	3	stran_g
strange	8	54	1634	3	strange
strata	6	36	1628	3	strata
stria	5	57	2321	3	st_ria
stroma	8	43	1307	3	stroma
struma	8	43	1327	3	struma
stun	4	56	2345	3	stun__
stung	6	54	1715	3	stun_g
stunk	9	46	1629	3	stun_k
stuns	5	47	1949	3	stun_s
stunt	5	53	2817	3	stun_t
stunts	6	56	1525	3	stunts
stupa	7	41	1231	3	st_upa
sultana	7	25	780	3	sultan_a
sunna	5	50	1606	3	s_unna
swan	7	66	3131	3	swan__
swang	9	55	1972	3	swan_g
swank	12	53	1823	3	swan_k
swanks	13	48	1156	3	swanks
swanky	16	44	797	3	swanky
swanny	12	33	682	3	swanny
swanpan	12	4	369	3	swanpan
swans	8	46	2501	3	swan_s
tabla	7	33	1836	3	_tabla
taenia	6	3	1319	3	_taenia
tafia	8	42	1549	3	_tafia
taiga	6	41	1567	3	_taiga
taka	8	76	2359	3	_ta_ka
tala	4	59	3805	3	_ta_la
tan	3	71	6758	3	_tan__
tang	5	61	3869	3	_tan_g
tango	6	69	2119	3	_tango
tangs	6	50	2836	3	_tangs
tangy	9	45	1995	3	_tangy
tank	8	51	3403	3	_tan_k
tankas	10	46	1377	3	_tankas
tanks	9	46	2474	3	_tanks
tans	4	61	5483	3	_tan_s
tansy	8	45	1494	3	_tansy
tanto	5	57	2495	3	_tanto
tantra	6	37	1336	3	_tantra
tapa	6	51	2915	3	_ta_pa
tarzan	15	29	1075	3	_tarzan
taxa	11	68	2009	3	_ta_xa
tazzas	14	3	628	3	_tazzas
tazze	13	3	957	3	_tazze
tenia	5	53	2448	3	_tenia
tinea	5	49	2316	3	_tinea
titania	7	3	829	3	titania
tonga	6	56	1970	3	_tonga
tuna	4	51	2784	3	_tun_a
urania	6	25	1612	3	urania
vanda	9	45	1592	3	_vanda
zanzas	14	8	705	3	_zanzas

Search took 9 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	112716	0.750	238254.7
2	DLD Change Limit	112716	329	7.970	14142.5
3	Display Results	329	329	0.106	3103.8
	(SQL Overall)	178691	329	8.826	20246.0