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

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

64 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
malignances	16	5	264	(None)
malignance	15	5	275	1	malignance_
malignancies	17	5	173	1	malignancies
malignancy	18	5	185	2	malignanc_y
malignant	12	4	522	3	malignan__t
malignantly	17	5	188	3	malignantly
malignities	14	6	487	3	malignities
militances	14	4	568	3	mili_tances
poignances	15	4	344	3	_poignances
valiances	14	8	720	3	vali__ances
abidances	14	4	559	4	_abi_dances
alginates	10	3	1012	4	_algina_tes
alienages	10	4	597	4	_aliena_ges
alienates	9	3	1068	4	_aliena_tes
allegiances	14	10	306	4	allegiances
alliances	11	10	709	4	_al_liances
allowances	15	4	382	4	_allowances
ambiances	15	4	571	4	ambi__ances
assonances	12	4	391	4	_assonances
balances	12	7	997	4	bal___ances
benignancies	17	5	199	4	benignancies
cofinances	17	4	530	4	cofi_nances
dalliances	13	4	426	4	dal_liances
diligences	14	4	433	4	dilig_ences
dominances	15	4	568	4	domi_nances
elegances	12	4	618	4	_eleg_ances
faineances	15	5	352	4	fa_ineances
finances	13	3	865	4	__fi_nances
flagrances	16	4	418	4	_flagrances
galingales	12	4	280	4	galinga_les
laitances	11	4	561	4	la_i_tances
lignaloes	10	5	403	4	__lignaloes
lignans	8	39	885	4	__lignan__s
luminances	14	4	447	4	lumi_nances
magnates	11	5	1161	4	ma__gna_tes
mahoganies	16	4	393	4	mahog_anies
maintenances	16	5	195	4	maintenances
malfeasances	19	6	142	4	malfeasances
malices	11	43	1662	4	mali____ces
maligned	12	8	577	4	malig__n_ed
maligner	11	11	533	4	malig__n_er
maligners	12	10	478	4	malig__ners
maligning	13	14	558	4	malignin__g
maligns	10	3	813	4	malig__n__s
malines	9	36	2560	4	mali___n_es
marginates	13	16	874	4	margina_tes
marinades	12	26	897	4	mari_na_des
marinates	11	25	1638	4	mari_na_tes
militance	13	4	611	4	mili_tance_
militancies	15	5	422	4	mili_tancies
naissances	12	4	342	4	na_issances
ordinances	13	4	497	4	ordi_nances
poignance	14	4	359	4	_poignance_
poignancies	16	5	270	4	_poignancies
radiances	12	4	769	4	radi__ances
refinances	15	10	713	4	refi_nances
reliances	11	3	962	4	reli__ances
repugnances	16	9	286	4	repugnances
saliences	11	10	806	4	sali__ences
stagnances	13	4	334	4	_stagnances
valances	13	9	876	4	val___ances
valiance	13	9	738	4	vali__ance_
valiancies	15	4	528	4	vali__ancies
variances	14	11	736	4	vari__ances

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.470	380193.6
2	DLD Change Limit	148819	64	8.796	16918.9
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	9.296	19222.4