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

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

118 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
atom	6	78	2452	(None)
atoms	7	68	1756	1	atoms
atomy	10	74	1519	1	atomy
atop	6	61	2475	1	atop
tom	5	143	5805	1	_tom
abo	5	90	4596	2	abo_
abohm	12	4	797	2	abohm
aboma	9	11	1460	2	aboma
abos	6	77	3441	2	abos
actor	7	11	1608	2	actor
ado	4	91	4688	2	ado_
ados	5	76	3351	2	ados
aeon	4	56	3461	2	aeon
ago	4	88	4552	2	ago_
agog	6	80	1900	2	agog
agon	5	65	3188	2	agon
ahem	9	72	2536	2	ahem
ahoy	10	19	1918	2	ahoy
aim	5	78	5822	2	a_im
aloe	4	55	4019	2	aloe
alow	7	53	2859	2	alow
alto	4	78	3126	2	alto_
altos	5	58	2295	2	altos
alum	6	52	2761	2	alum
am	4	118	7556	2	a__m
ammo	8	55	2013	2	ammo
amok	10	2	1740	2	amok
anoa	4	56	3447	2	anoa
anomy	10	51	1339	2	anomy
anon	4	61	3485	2	anon
apo	5	111	4212	2	apo_
apod	7	81	2318	2	apod
apos	6	54	3382	2	apos
arm	5	84	4962	2	a_rm
aroma	7	12	2014	2	aroma
arum	6	61	2903	2	arum
at	2	123	9340	2	at__
atap	6	67	2245	2	atap
ate	3	70	5924	2	at_e
ates	4	50	4792	2	ates
atma	6	81	2177	2	atma
atoll	5	79	1392	2	atoll
atomic	10	41	1560	2	atomic
atone	5	65	2798	2	atone
atony	8	72	1885	2	atony
atopy	10	68	1339	2	atopy
att	3	54	5465	2	at_t
auto	4	74	3208	2	auto_
autos	5	65	2332	2	autos
avo	6	89	3623	2	avo_
avos	7	72	2701	2	avos
avow	10	78	1646	2	avow
awol	7	56	2067	2	awol
axiom	14	39	1359	2	axiom
axon	11	55	2430	2	axon
azo	12	82	3339	2	azo_
azon	13	57	2505	2	azon
baton	7	58	2242	2	baton
boom	8	74	3567	2	boom
carom	9	50	2556	2	carom
dato	5	61	2994	2	dato_
datos	6	52	2278	2	datos
datum	8	3	1063	2	datum
diatom	9	3	945	2	diatom
dom	6	97	5244	2	_dom
doom	7	64	3007	2	doom
fantom	11	21	1080	2	fantom
fathom	14	3	747	2	fathom
from	9	69	2392	2	from
gator	6	44	1604	2	gator
glom	7	54	2438	2	glom
item	6	56	2038	2	item
jato	11	58	2268	2	jato_
jatos	12	51	1682	2	jatos
loom	6	70	3505	2	loom
madtom	11	3	802	2	madtom
mom	7	88	5316	2	_mom
nom	5	104	5064	2	_nom
om	4	85	5300	2	__om
pom	7	82	4991	2	_pom
prom	8	76	3170	2	prom
rato	4	54	3697	2	rato_
ratos	5	55	2876	2	ratos
rom	5	98	5563	2	_rom
room	6	62	3508	2	room
satem	7	60	2146	2	satem
som	5	91	5381	2	_som
stem	6	106	2825	2	stem
stoa	4	54	2591	2	stoa
stob	6	67	2461	2	stob
stoma	7	59	1827	2	stoma
stomp	9	56	1666	2	stomp
stop	6	65	3203	2	stop
storm	7	65	2040	2	storm
stot	4	63	4733	2	stot
stow	7	73	2574	2	stow
stum	6	55	2602	2	stum
tam	5	86	6342	2	_tam
tao	3	83	5895	2	tao_
taos	4	55	4100	2	taos
to	2	188	5898	2	_to_
tod	4	94	5708	2	_tod
toe	3	101	6685	2	_toe
tog	4	102	5504	2	_tog
tomb	8	90	2965	2	_tomb
tome	6	75	4319	2	_tome
toms	6	83	4349	2	_toms
ton	3	102	6510	2	_ton
too	3	89	6542	2	_too
toom	6	65	3293	2	toom
top	5	105	6068	2	_top
tor	3	92	6168	2	_tor
tot	3	88	8477	2	_tot
tow	6	105	5736	2	_tow
toy	6	96	5519	2	_toy
whom	12	70	1818	2	whom
yom	8	80	4344	2	_yom
zoom	15	67	2210	2	zoom

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.296	603685.8
2	DLD Change Limit	29872	118	1.000	29872.0
3	Display Results	118	118	0.033	3575.8
	(SQL Overall)	178691	118	1.329	134455.2