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

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

60 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
flagrancies	17	5	297	(None)
flagrances	16	4	418	1	flagranc_es
fragrancies	17	5	330	1	fragrancies
flagrance	15	4	419	2	flagranc_e_
fragrances	16	4	388	2	fragranc_es
vagrancies	16	4	417	2	_vagrancies
blatancies	14	4	438	3	bla_tancies
elegancies	13	4	501	3	eleg_ancies
flagrancy	18	5	294	3	flagranc__y
flippancies	20	5	176	3	flippancies
fragrance	15	4	394	3	fragranc_e_
stagnancies	14	5	266	3	stagnancies
aberrancies	15	9	391	4	aberrancies
adamancies	15	4	377	4	ada_mancies
agencies	11	3	874	4	__ag_encies
anabranches	18	5	216	4	anabranches
clarences	13	4	645	4	cla_renc_es
clearances	14	4	479	4	clearanc_es
coagencies	15	4	562	4	coag_encies
dilatancies	14	5	325	4	dila_tancies
elegances	12	4	618	4	eleg_anc_es
errancies	11	4	796	4	__errancies
fallacies	14	4	683	4	f_alla_cies
fancies	12	40	1878	4	f____ancies
farcies	12	53	1788	4	f_a_r__cies
feasances	14	4	540	4	fea_sanc_es
federacies	16	4	499	4	federa_cies
flagrant	12	4	763	4	flagran___t
flagrantly	17	5	273	4	flagran_tly
flamboyancies	25	6	105	4	flamboyancies
flatulencies	17	5	177	4	flatulencies
flavanones	16	5	206	4	fla_vanones
florences	14	4	689	4	fl_orenc_es
fluencies	14	4	593	4	fl__uencies
fragrancy	18	5	256	4	fragranc__y
francizes	23	4	679	4	f___rancizes
grannies	9	3	1261	4	___grannies
guaranies	10	12	712	4	gua_ran_ies
guaranties	11	4	438	4	gua_ranties
inerrancies	13	5	505	4	inerrancies
laitances	11	4	561	4	_laitanc_es
lambencies	16	4	380	4	_lambencies
latencies	11	4	777	4	_la_tencies
legacies	11	3	904	4	_leg_a_cies
malignancies	17	5	173	4	malignancies
plagiaries	13	14	611	4	plagia_ries
plangencies	16	5	379	4	plangencies
pliancies	13	4	667	4	pl__iancies
poignancies	16	5	270	4	poignancies
pregnancies	16	4	456	4	pregnancies
radiancies	13	4	527	4	_radiancies
rampancies	16	4	404	4	_rampancies
regnancies	13	4	541	4	_regnancies
sergeancies	14	4	439	4	sergeancies
slamdances	15	6	262	4	slamdanc_es
stagnances	13	4	334	4	stagnanc_es
vacancies	16	4	549	4	_va_cancies
valiancies	15	4	528	4	_valiancies
vibrancies	17	4	441	4	_vibrancies
warranties	13	4	468	4	_warranties

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	60	9.050	16444.1
3	Display Results	60	60	0.030	2000.0
	(SQL Overall)	178691	60	9.500	18809.6