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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

78 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
theta	8	34	1457	(None)
theca	10	33	1145	1	theca
thetas	9	30	1157	1	thetas
aceta	7	40	1735	2	aceta
beta	6	62	3413	2	_beta
chaeta	11	3	1068	2	chaeta
cheat	10	57	3245	2	cheat
chela	10	39	1680	2	chela
chetah	14	39	958	2	chetah
cheth	13	50	1382	2	cheth
eta	3	58	3419	2	__eta
feta	7	65	2890	2	_feta
geta	5	66	2744	2	_geta
heat	7	70	6142	2	_heat
het	6	76	7431	2	_het_
heth	10	70	2802	2	_heth
hets	7	55	4720	2	_hets
kheda	13	4	653	2	kheda
khet	11	63	2862	2	khet_
kheth	15	50	975	2	kheth
khets	12	49	1343	2	khets
meta	6	59	3241	2	_meta
pieta	7	54	2175	2	pieta
rhea	7	50	1743	2	rhe_a
rhyta	11	3	508	2	rhyta
seta	4	56	3731	2	_seta
shea	7	60	3157	2	she_a
shelta	9	31	1178	2	shelta
tapeta	8	3	1069	2	tapeta
tea	3	73	5332	2	t_e_a
teat	4	59	6363	2	t_eat
tecta	7	42	1552	2	tecta
teeth	8	73	1585	2	teeth
tela	4	55	3297	2	t_ela
tepa	6	60	2168	2	t_epa
testa	5	48	2204	2	testa
tet	3	92	7498	2	t_et_
teth	7	63	2788	2	t_eth
tetra	5	34	1795	2	t_etra
tets	4	58	4745	2	t_ets
that	7	56	3932	2	that_
the	6	74	3605	2	the__
thebe	10	75	1543	2	thebe
thecae	11	29	965	2	thecae
thecal	11	33	1030	2	thecal
thee	7	80	3906	2	the_e
theft	11	41	1813	2	theft
thefts	12	38	792	2	thefts
thegn	9	58	1090	2	thegn
thein	8	59	1902	2	thein
their	8	55	1215	2	their
them	9	74	2704	2	the_m
theme	10	59	2173	2	theme
then	7	84	2969	2	the_n
thenal	9	27	1241	2	thenal
thenar	9	26	999	2	thenar
thens	8	59	2183	2	thens
there	8	75	2739	2	there
therm	10	60	1802	2	therm
these	8	65	1901	2	these
thesp	10	54	1031	2	thesp
thetic	11	4	1288	2	thetic
thew	10	82	2623	2	the_w
thews	11	74	1619	2	thews
thewy	14	63	1185	2	thewy
they	10	72	2375	2	the_y
threat	9	50	2046	2	threat
thuja	15	3	521	2	thuja
thuya	11	3	558	2	thuya
toea	4	67	3233	2	toe_a
torta	5	59	2535	2	torta
treat	5	62	4035	2	treat
tret	4	66	5353	2	tret_
trets	5	59	2802	2	trets
wheat	11	49	2457	2	wheat
whet	10	51	3378	2	whet_
whets	11	50	1961	2	whets
zeta	13	51	2164	2	_zeta

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	53800	0.093	1921408.6
2	DLD Change Limit	53800	78	1.640	32804.9
3	Display Results	78	78	0.016	4875.0
	(SQL Overall)	178691	78	1.749	102167.5