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

Here are the results of your fuzzy-string dictionary search for “collected” with Change Limit: [1] [2] [3]

(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
collected	14	4	797	(None)
colleted	11	30	1166	1	colle_ted
coerected	14	4	764	2	coerected
collated	11	36	1506	2	coll_ated
collect	11	33	1459	2	collect__
collectedly	19	8	301	2	collectedly
collector	13	4	639	2	collector
collects	12	27	978	2	collect_s
collocated	15	4	616	2	collocated
complected	19	29	586	2	complected
confected	17	3	907	2	confected
connected	14	3	875	2	connected
convected	17	3	878	2	convected
corrected	14	3	811	2	corrected
recollected	16	4	385	2	recollected
uncollected	16	5	367	2	uncollected
billeted	11	3	764	3	bille_ted
bulleted	11	3	839	3	bulle_ted
cathected	17	4	454	3	cathected
cleated	10	34	1784	3	c__leated
clefted	13	32	675	3	c__lefted
closeted	11	3	561	3	close_ted
coacted	12	36	1161	3	co__acted
coalesced	14	4	455	3	coalesced
cocreated	14	27	1009	3	cocreated
codirected	16	5	300	3	codirected
coenacted	14	4	580	3	coenacted
coexerted	19	4	476	3	coexerted
coinfected	18	4	382	3	coinfected
coleseed	11	4	740	3	co_leseed
collaged	12	27	997	3	coll_aged
collapsed	14	4	322	3	collapsed
collared	11	32	1114	3	coll_ared
collate	9	29	1968	3	coll_ate_
collates	10	30	1914	3	coll_ates
collectanea	15	5	279	3	collectanea
collecting	15	4	828	3	collecting
collection	14	4	820	3	collection
collective	17	4	712	3	collective
collectives	18	4	603	3	collectives
collectors	14	4	659	3	collectors
colleen	9	3	954	3	colle__en
college	10	24	1044	3	colle_ge_
colleger	11	22	793	3	colle_ger
colleges	11	24	1052	3	colle_ges
collet	8	40	3036	3	colle_t__
collets	9	35	1790	3	colle_t_s
collided	12	30	980	3	coll_ided
collied	10	33	1667	3	coll__ied
colligated	14	4	627	3	colligated
collimated	15	5	608	3	collimated
collocate	13	4	867	3	collocate_
collocates	14	4	812	3	collocates
collogued	13	4	407	3	collogued
colluded	12	29	646	3	coll_uded
colocated	14	3	961	3	colocated
commented	16	12	961	3	commented
compacted	18	29	736	3	compacted
competed	15	41	1359	3	compe_ted
completed	16	28	1027	3	comple_ted
conceited	14	3	1042	3	conceited
concerted	14	3	1211	3	concerted
concocted	13	4	676	3	concocted
conducted	15	4	731	3	conducted
conflicted	18	4	405	3	conflicted
congested	13	3	867	3	congested
connecter	13	4	905	3	connecter
consented	12	3	1194	3	consented
contacted	14	13	909	3	contacted
contented	12	3	1304	3	contented
contested	12	3	1069	3	contested
convented	15	4	1075	3	convented
converted	15	3	1156	3	converted
convicted	17	4	631	3	convicted
coplotted	14	4	479	3	coplotted
coquetted	21	5	482	3	coquetted
corelated	12	4	1182	3	corelated
correcter	13	4	810	3	correcter
corseted	11	3	1147	3	corse_ted
cosseted	11	7	834	3	cosse_ted
coveted	13	30	1152	3	co_ve_ted
deflected	16	3	598	3	deflected
elected	10	28	1261	3	__elected
filleted	12	3	660	3	fille_ted
galleted	10	3	822	3	galle_ted
hollered	12	3	760	3	holle_red
inflected	15	4	605	3	inflected
molested	11	17	824	3	mo_lested
neglected	13	5	469	3	neglected
nonelected	13	5	569	3	nonelected
objected	20	4	349	3	_objected
obtected	13	4	455	3	_obtected
palleted	11	3	987	3	palle_ted
pelleted	11	3	820	3	pelle_ted
pollenated	13	4	501	3	pollenated
pollened	11	5	778	3	polle_ned
polluted	11	3	543	3	poll_uted
prelected	14	3	913	3	prelected
reelected	12	3	831	3	reelected
reflected	15	4	798	3	reflected
rollicked	16	4	303	3	rollicked
rouletted	10	4	505	3	rouletted
selected	11	5	978	3	_selected
toileted	9	3	699	3	toile_ted
unelected	12	3	782	3	unelected
volleyed	15	4	353	3	volle_yed

Search took 7 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	148641	0.420	425454.8
2	DLD Change Limit	148641	106	6.220	23897.3
3	Display Results	106	106	0.046	2304.3
	(SQL Overall)	178691	106	6.686	26726.1