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

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

106 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
unto	4	58	2428	(None)
into	4	50	2615	1	into
junto	12	51	1456	1	junto
onto	4	61	2766	1	onto
punto	7	51	2132	1	punto
unco	6	60	2140	1	unco
undo	5	56	2015	1	undo
alto	4	78	3126	2	alto
ant	3	72	7079	2	ant_
anta	4	68	3958	2	anta
ante	4	65	3890	2	ante
anti	4	55	3636	2	anti
ants	4	72	4347	2	ants
aunt	4	65	5365	2	aunt_
aunts	5	52	2763	2	aunts
aunty	8	59	1981	2	aunty
auto	4	74	3208	2	auto
bento	7	59	2295	2	bento
bunco	9	46	1608	2	bunco
bunko	11	55	1451	2	bunko
bunt	6	58	5085	2	bunt_
bunts	7	57	2980	2	bunts
canto	7	49	3101	2	canto
cento	7	66	2517	2	cento
conto	7	60	2717	2	conto
cunt	6	62	4367	2	cunt_
cunts	7	61	2512	2	cunts
dato	5	61	2994	2	dato
dunt	5	57	4687	2	dunt_
dunts	6	58	2841	2	dunts
fungo	9	44	1313	2	fungo
gusto	6	54	1464	2	gusto
hunt	7	64	4549	2	hunt_
hunts	8	68	2617	2	hunts
info	7	56	1735	2	info
inro	4	59	2079	2	inro
inti	4	66	2608	2	inti
intro	5	49	1585	2	intro
jato	11	58	2268	2	jato
junco	14	46	1220	2	junco
junta	12	37	1367	2	junta
juntos	13	41	1084	2	juntos
keto	8	62	2345	2	keto
knot	8	56	3050	2	knot
koto	8	63	2347	2	koto
lento	5	72	2339	2	lento
lunt	4	61	4884	2	lunt_
lunts	5	58	2690	2	lunts
mungo	8	49	1605	2	mungo
no	2	93	5324	2	_n_o
noo	3	71	5404	2	_noo
not	3	94	7466	2	_not
nth	6	63	2059	2	_nth
nut	3	66	5196	2	nut_
nuts	4	50	3267	2	nuts
ono	3	68	3803	2	on_o
otto	4	52	2064	2	otto
panto	7	61	2941	2	panto
pinto	7	56	2575	2	pinto
punt	6	57	4720	2	punt_
puntos	8	59	1579	2	puntos
punts	7	58	2800	2	punts
punty	10	60	2161	2	punty
putto	7	56	1766	2	putto
rato	4	54	3697	2	rato
roto	4	59	3505	2	roto
runt	4	66	4799	2	runt_
runts	5	59	2763	2	runts
runty	8	61	1904	2	runty
santo	5	62	2728	2	santo
snot	4	47	4545	2	snot
tanto	5	57	2495	2	tanto
to	2	188	5898	2	__to
udo	4	90	2730	2	u_do
umbo	8	55	1666	2	umbo
un	2	83	4114	2	un__
unai	4	48	2478	2	unai
unau	4	39	2415	2	unau
unbe	6	53	1927	2	unbe
unbox	14	3	875	2	unbox
unci	6	50	1946	2	unci
uncos	7	41	1703	2	uncos
uncoy	10	41	1141	2	uncoy
unde	5	58	2548	2	unde
undy	8	50	1516	2	undy
ungot	6	17	1806	2	ungot
union	5	45	1979	2	union
unit	4	51	4007	2	unit
unite	5	48	2838	2	unite
units	5	49	2343	2	units
unity	8	49	1849	2	unity
uns	3	59	3676	2	un_s
unstop	8	3	747	2	unstop
untie	5	44	2549	2	untie
until	5	35	1774	2	until
untold	7	14	968	2	untold
untorn	6	30	1234	2	untorn
untrod	7	6	985	2	untrod
unwon	8	45	1234	2	unwon
updo	7	67	1288	2	updo
upo	5	89	2586	2	u_po
ut	2	86	4703	2	u_t_
uta	3	74	2558	2	u_ta
ute	3	53	3588	2	u_te
uts	3	55	3437	2	u_ts
veto	7	66	2299	2	veto

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.266	671770.7
2	DLD Change Limit	29872	106	0.860	34734.9
3	Display Results	106	106	0.030	3533.3
	(SQL Overall)	178691	106	1.156	154577.0