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

Here are the results of your fuzzy-string dictionary search for “tenth” 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.

105 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
tenth	8	54	2183	(None)
teeth	8	73	1585	1	teeth
tench	10	56	2000	1	tench
tent	4	61	5986	1	tent_
tenths	9	44	1266	1	tenths
tents	5	64	3421	1	tents
tenty	8	61	2160	1	tenty
teth	7	63	2788	1	te_th
bench	12	56	1950	2	bench
bent	6	77	5991	2	bent_
bento	7	59	2295	2	bento
bents	7	60	3369	2	bents
berth	10	49	1788	2	berth
beth	9	66	2923	2	be_th
cent	6	74	5101	2	cent_
cento	7	66	2517	2	cento
cents	7	47	3033	2	cents
centu	7	61	1941	2	centu
death	9	48	2252	2	death
dent	5	71	5841	2	dent_
dents	6	50	3180	2	dents
depth	11	43	1185	2	depth
eath	7	57	3566	2	_eath
eth	6	66	3098	2	_e_th
gent	5	69	5439	2	gent_
gents	6	57	2961	2	gents
heath	11	57	2428	2	heath
hent	7	66	5638	2	hent_
hents	8	73	3074	2	hents
heth	10	70	2802	2	he_th
kench	14	55	1392	2	kench
kent	8	68	4696	2	kent_
kente	9	58	2106	2	kente
length	10	4	610	2	length
lent	4	63	6053	2	lent_
lento	5	72	2339	2	lento
mensh	10	54	1355	2	mensh
menta	7	44	2442	2	menta
meth	9	58	2784	2	me_th
month	10	48	1842	2	month
neath	8	60	2028	2	neath
ninth	8	3	1458	2	ninth
nth	6	63	2059	2	__nth
pent	6	65	5907	2	pent_
rent	4	66	6124	2	rent_
rente	5	47	3378	2	rente
rents	5	59	3518	2	rents
sent	4	69	6301	2	sent_
sente	5	64	3287	2	sente
senti	5	62	2669	2	senti
stench	11	41	1116	2	stench
stent	5	56	3451	2	stent_
stents	6	50	1945	2	stents
synth	11	37	1182	2	synth
tanto	5	57	2494	2	tanto
teach	10	52	2112	2	teach
teat	4	59	6363	2	teat_
teats	5	56	3681	2	teats
tech	9	59	2544	2	te_ch
tecta	7	42	1552	2	tecta
teethe	9	45	1131	2	teethe
ten	3	58	5611	2	ten__
tend	5	64	3377	2	ten_d
tends	6	54	2558	2	tends
tendu	6	72	1600	2	tendu
tenet	5	55	4221	2	tenet
tenets	6	55	1895	2	tenets
tenge	6	57	2043	2	tenge
tenia	5	53	2448	2	tenia
tenon	5	33	2051	2	tenon
tenor	5	36	2025	2	tenor
tens	4	56	4741	2	ten_s
tense	5	52	2584	2	tense
tented	7	42	2100	2	tented
tenter	6	46	2393	2	tenter
tenthly	13	3	574	2	tenthly
tentie	6	25	2118	2	tentie
tenuti	6	3	897	2	tenuti
tenuto	6	4	874	2	tenuto
test	4	86	5162	2	test_
testa	5	48	2204	2	testa
tests	5	65	3019	2	tests
testy	8	54	1906	2	testy
tet	3	92	7498	2	te_t_
teths	8	54	1851	2	te_ths
tets	4	58	4745	2	te_ts
teuch	10	52	1485	2	teuch
teugh	9	55	1161	2	teugh
text	11	60	3393	2	text_
texts	12	55	1504	2	texts
tilth	8	55	1536	2	tilth
tint	4	67	5886	2	tint_
tints	5	60	3092	2	tints
tooth	8	80	2018	2	tooth
trench	11	42	1161	2	trench
troth	8	56	2220	2	troth
truth	8	52	1415	2	truth
twenty	12	3	622	2	twenty
vent	7	60	4905	2	vent_
vents	8	61	2593	2	vents
wench	13	62	1478	2	wench
went	7	60	5187	2	went_
yenta	8	39	1704	2	yenta
yente	8	62	2004	2	yente
zenith	18	3	907	2	zenith

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	105	1.673	32157.8
3	Display Results	105	105	0.030	3500.0
	(SQL Overall)	178691	105	1.796	99493.9