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

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

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.

62 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
appetencies	17	5	373	(None)
appetences	16	4	459	1	appetenc_es
appetence	15	4	499	2	appetenc_e_
advertencies	18	5	302	3	advertencies
appetency	18	5	355	3	appetenc__y
competencies	20	6	497	3	competencies
impotencies	17	5	458	3	impotencies
inappetences	18	5	296	3	inappetenc_es
opponencies	17	5	269	3	opponencies
papeteries	14	4	655	3	papete_ries
patencies	13	4	917	3	__patencies
potencies	13	6	930	3	__potencies
pretences	13	23	1261	3	_pretenc_es
abeyancies	17	4	304	4	a_beyancies
accedences	14	5	416	4	accedenc_es
adherences	16	6	488	4	adherenc_es
adjacencies	23	9	179	4	adjacencies
adjutancies	21	5	196	4	adjutancies
advertences	17	5	405	4	advertenc_es
affluencies	19	10	256	4	affluencies
agencies	11	3	874	4	a___gencies
apetalies	11	4	800	4	a_pet_alies
apostacies	14	4	560	4	apost_acies
appearances	17	5	369	4	appearanc_es
appendices	17	4	346	4	app__endices
appendixes	22	5	244	4	app__endixes
appetent	12	4	808	4	appeten___t
appetites	13	4	751	4	appet__ites
appliances	16	4	397	4	applianc_es
apprentices	17	5	356	4	app_rentices
ardencies	12	4	785	4	a__rdencies
ascendencies	17	10	308	4	ascendencies
clemencies	16	4	473	4	_clemencies
coherencies	18	8	477	4	coherencies
competences	19	5	637	4	competenc_es
decencies	14	4	894	4	__decencies
dependencies	18	5	408	4	dependencies
expectancies	25	6	224	4	expectancies
expediencies	24	5	292	4	expediencies
impotences	16	4	557	4	impotenc_es
impudencies	18	5	363	4	impudencies
inappetence	17	5	324	4	inappetenc_e_
indecencies	16	5	582	4	indecencies
inherencies	16	5	647	4	inherencies
latencies	11	4	777	4	__latencies
opulencies	14	4	356	4	_opulencies
papeterie	13	4	519	4	papete_rie_
pendencies	15	4	702	4	_pendencies
potences	12	7	1069	4	__potenc_es
prepotencies	18	8	429	4	prepotencies
presences	13	21	1379	4	_presenc_es
pretence	12	23	1212	4	_pretenc_e_
pretenses	11	22	1059	4	_preten_ses
pudencies	14	4	578	4	__pudencies
pungencies	15	4	472	4	_pungencies
recencies	13	3	1225	4	__recencies
regencies	12	4	928	4	__regencies
renitencies	13	4	609	4	renitencies
repellencies	16	6	307	4	repellencies
sapiencies	14	4	512	4	sap_iencies
subpotencies	18	5	258	4	subpotencies
vehemencies	21	5	276	4	vehemencies

Search took 10 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	148819	0.436	409841.7
2	DLD Change Limit	148819	62	9.326	15957.4
3	Display Results	62	62	0.033	1878.8
	(SQL Overall)	178691	62	9.795	18243.1