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

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

112 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
altos	5	58	2295	(None)
alto	4	78	3126	1	alto_
alts	4	66	3990	1	alt_s
autos	5	65	2332	1	autos
abos	6	77	3441	2	a_bos
actor	7	11	1607	2	actor
actors	8	10	1675	2	actors
acts	6	69	2986	2	act_s
adios	6	58	2286	2	adios
ados	5	76	3351	2	a_dos
aftosa	9	9	657	2	aftosa
agios	6	59	1986	2	agios
aits	4	63	5553	2	ait_s
alamos	8	4	1500	2	alamos
alans	5	56	3617	2	alans
alas	4	63	5812	2	al_as
alates	6	48	3396	2	alates
albas	7	59	2539	2	albas
albs	6	86	2857	2	al_bs
aldol	6	12	1233	2	aldol
aldols	7	10	971	2	aldols
aldose	7	3	1109	2	aldose
alecs	7	66	2073	2	alecs
alefs	8	73	1966	2	alefs
ales	4	70	6710	2	al_es
alfas	8	72	1904	2	alfas
algas	6	56	2493	2	algas
algor	6	5	1305	2	algor
algors	7	3	1255	2	algors
alias	5	58	3460	2	alias
alifs	8	61	2126	2	alifs
aliyos	9	34	953	2	aliyos
allod	6	44	1837	2	allod
allods	7	36	1508	2	allods
allot	5	49	3387	2	allot
allots	6	40	1917	2	allots
allow	8	54	2066	2	allow
allows	9	45	1768	2	allows
alloy	8	55	1997	2	alloy
alloys	9	40	1456	2	alloys
alls	4	67	4092	2	al_ls
almas	7	66	2977	2	almas
almes	7	51	2654	2	almes
almost	8	10	1443	2	almost
alms	6	58	3492	2	al_ms
aloe	4	55	4019	2	al_oe
aloes	5	49	3367	2	aloes
aloof	8	35	2157	2	aloof
alow	7	53	2859	2	al_ow
alps	6	55	2924	2	al_ps
als	3	66	6302	2	al__s
also	4	64	2344	2	also_
alt	3	64	6796	2	alt__
altar	5	55	2064	2	altar
altars	6	45	1815	2	altars
alter	5	48	2850	2	alter
alters	6	49	2422	2	alters
altho	8	63	1260	2	altho
altoist	7	3	1339	2	altoist
alums	7	57	2060	2	alums
ambos	9	53	2124	2	ambos
ammos	9	48	1582	2	ammos
antas	5	54	3203	2	antas
antes	5	63	3432	2	antes
antis	5	50	3331	2	antis
ants	4	72	4347	2	ant_s
apos	6	54	3382	2	a_pos
arts	4	96	5026	2	art_s
arvos	8	60	1566	2	arvos
askos	9	50	1177	2	askos
ates	4	50	4792	2	a_tes
atlas	5	58	2158	2	atlas
atom	6	78	2452	2	a_tom
atoms	7	68	1756	2	a_toms
atop	6	61	2475	2	a_top
auto	4	74	3208	2	auto_
avos	7	72	2701	2	a_vos
blots	7	56	2617	2	blots
calos	7	44	3190	2	cal_os
cantos	8	48	2697	2	cantos
clots	7	56	2764	2	clots
dalton	7	3	1127	2	dalton
daltons	8	3	1040	2	daltons
datos	6	52	2278	2	datos
dattos	7	43	1190	2	dattos
hallos	9	54	2510	2	hallos
halos	8	52	3025	2	hal_os
halts	8	52	3010	2	halt_s
jatos	12	51	1682	2	jatos
kotos	9	57	1769	2	kotos
laths	8	60	2240	2	laths
lats	4	59	6270	2	lat_s
loos	4	90	5112	2	_loos
lotos	5	47	2463	2	lotos
lots	4	76	5209	2	_lots
maltol	8	3	1084	2	maltol
maltols	9	3	940	2	maltols
maltose	9	3	978	2	maltose
malts	7	63	3175	2	malt_s
oleos	5	54	1968	2	oleos
olios	5	45	2085	2	olios
ottos	5	47	1432	2	ottos
pantos	8	52	2274	2	pantos
plots	7	50	2567	2	plots
ratos	5	55	2876	2	ratos
rialtos	7	3	661	2	rialtos
rotos	5	60	2788	2	rotos
salts	5	54	3188	2	salt_s
salvos	9	46	1338	2	salvos
santos	6	44	2183	2	santos
slots	5	48	3052	2	slots
smaltos	9	40	819	2	smaltos

Search took 3 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.173	1032896.0
2	DLD Change Limit	53800	112	1.780	30224.7
3	Display Results	112	112	0.033	3393.9
	(SQL Overall)	178691	112	1.986	89975.3