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

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

59 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
ansae	5	57	2097	(None)
ansa	4	59	2777	1	ansa_
ansate	6	45	1786	1	ansate
antae	5	68	2829	1	antae
abase	7	60	2348	2	abase
aisle	5	52	2319	2	aisle
alae	4	56	4375	2	a_lae
algae	6	53	1962	2	algae
ana	3	95	5982	2	an_a_
anal	4	80	3752	2	an_al
anas	4	66	4986	2	an_as
ane	3	78	6694	2	an__e
anear	5	54	2032	2	anear
anele	5	56	2883	2	anele
anga	5	68	3135	2	anga_
angas	6	58	2798	2	angas
angle	6	45	2887	2	angle
anile	5	46	3446	2	anile
anime	7	54	2320	2	anime
anise	5	51	2970	2	anise
ankle	9	52	2025	2	ankle
anlace	8	25	1392	2	anlace
anlage	7	25	1422	2	anlage
anlas	5	56	2693	2	anlas
anna	4	55	2901	2	anna_
annal	5	65	2076	2	annal
annas	5	58	2488	2	annas
anoa	4	56	3447	2	anoa_
anoas	5	72	2649	2	anoas
anode	6	50	2103	2	anode
anole	5	53	3037	2	anole
ansated	8	42	1400	2	ansated
answer	9	3	689	2	answer
anta	4	68	3958	2	anta_
antas	5	54	3203	2	antas
ante	4	65	3890	2	an_te
antre	5	52	2452	2	antre
apse	6	77	2538	2	aps_e
aquae	14	22	1271	2	aquae
areae	5	52	2974	2	areae
arse	4	65	3927	2	ars_e
asea	4	63	2718	2	a_sea
assai	5	7	1154	2	assai
assay	8	7	1028	2	assay
aurae	5	41	2811	2	aurae
ensue	5	40	1383	2	ensue
hansa	8	54	1678	2	hansa_
hansas	9	46	1604	2	hansas
hanse	8	57	2279	2	hans_e
insane	6	3	1488	2	insane
manse	7	55	2822	2	mans_e
mensae	8	41	1404	2	mensae
nae	3	59	5274	2	_n_ae
nasal	5	62	1759	2	nasal
sae	3	83	6518	2	__sae
sansar	6	36	1339	2	sansar
unsafe	9	3	1069	2	unsafe
unsay	8	32	1284	2	unsay
ursae	5	52	1445	2	ursae

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	59	1.873	28724.0
3	Display Results	59	59	0.016	3687.5
	(SQL Overall)	178691	59	1.982	90156.9