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

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

69 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
abstinences	15	5	290	(None)
abstinence	14	5	297	1	abstinence_
absences	12	4	767	3	abs___ences
abstinent	11	4	592	3	abstinen__t
abstinently	16	5	224	3	abstinently
continences	15	8	858	3	continences
desinences	13	4	721	3	des_inences
pertinences	15	4	574	3	pertinences
pestilences	15	4	469	3	pestilences
abhorrences	18	7	203	4	abhorrences
abidances	14	4	559	4	ab__idances
absence	11	3	771	4	abs___ence_
absinthes	14	4	267	4	abs_in_thes
absorbances	17	5	294	4	absorbances
absorbencies	18	5	214	4	absorbencies
abstainers	12	4	345	4	abstaine__rs
absterges	12	4	476	4	abst__erges
accidences	14	4	440	4	a_ccidences
ambiences	15	4	525	4	a_mbi_ences
antigenes	10	4	1143	4	a_ntigen_es
antsinesses	11	4	875	4	antsinesses
artinesses	10	8	1521	4	a_rtinesses
artsinesses	11	3	871	4	artsinesses
ascendences	16	12	414	4	a_scendences
ashinesses	13	3	916	4	a_shinesses
assonances	12	4	391	4	a_ssonances
asthenies	12	7	806	4	a_st_henies
astringencies	16	6	208	4	a_stringencies
audiences	12	4	600	4	a_udi_ences
bastinades	13	4	460	4	bastin_ades
bastinadoes	14	5	227	4	bastinadoes
battinesses	13	16	945	4	battinesses
bustinesses	13	13	1009	4	bustinesses
continence	14	8	913	4	continence_
contingences	17	9	499	4	contingences
desinence	12	5	750	4	des_inence_
dissidences	15	16	413	4	dissidences
dustinesses	12	11	1035	4	dustinesses
eminences	13	4	740	4	__eminences
fustinesses	14	12	978	4	fustinesses
gustinesses	12	13	952	4	gustinesses
hastinesses	14	12	1069	4	hastinesses
imminences	16	15	506	4	_imminences
lustinesses	11	9	1042	4	lustinesses
mistinesses	13	13	1062	4	mistinesses
mustinesses	13	10	1041	4	mustinesses
nastinesses	11	11	1074	4	nastinesses
nesciences	14	4	625	4	nesci_ences
obediences	15	4	432	4	obedi_ences
obstinacies	15	7	227	4	obstinacies
pastinesses	13	9	1171	4	pastinesses
patiences	13	6	743	4	_pati_ences
pertinence	14	4	583	4	pertinence_
pertinencies	16	5	457	4	pertinencies
pestilence	14	5	454	4	pestilence_
prominences	17	4	486	4	prominences
residences	13	6	823	4	res_idences
reticences	14	4	745	4	_reticences
retinenes	9	4	1037	4	_retinen_es
rustinesses	11	9	1155	4	rustinesses
sciences	12	3	877	4	__sci_ences
sentiences	12	4	760	4	senti_ences
silences	10	3	1007	4	__s_ilences
stridences	13	4	473	4	__stridences
subsciences	17	6	436	4	subsci_ences
subsidences	16	5	377	4	subs_idences
sustenances	13	5	362	4	sustenances
tastinesses	11	11	1078	4	tastinesses
testinesses	11	12	1032	4	testinesses

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.420	425454.8
2	DLD Change Limit	148819	69	9.390	15848.7
3	Display Results	69	69	0.050	1380.0
	(SQL Overall)	178691	69	9.860	18122.8