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

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

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
centrifugation	20	6	171	(None)
centrifugations	21	6	148	1	centrifugations
gentrification	20	6	563	3	gentrification
centralization	25	10	815	4	centralization
centrifugal	17	6	199	4	centrifuga___l
centrifugally	22	8	155	4	centrifuga_lly
centrifugals	18	7	150	4	centrifuga__ls
centrifuging	19	5	185	4	centrifug__ing
certification	20	4	860	4	cert_ification
continuation	14	4	819	4	cont_inu_ation
contribution	16	5	509	4	contribu__tion
denitrification	21	18	387	4	denitrification
denticulation	16	5	456	4	dent_iculation
gentrifications	21	7	504	4	gentrifications
petrification	20	4	881	4	pe_trification
acetification	20	4	672	5	ace_t_ification
antiquation	20	4	742	5	_ant_iqu_ation
beatification	20	13	807	5	beat_ification
cantillation	14	4	669	5	cant_i_llation
caprification	22	5	605	5	c_aprification
castigation	14	4	797	5	cast_i__gation
centralizations	26	15	778	5	centralizations
centrifuge	16	5	281	5	centrifug____e
centrifuged	18	5	228	5	centrifug___ed
centrifuges	17	5	287	5	centrifug___es
certifications	21	4	779	5	cert_ifications
citification	19	4	915	5	c_it_ification
clarification	20	4	576	5	c_larification
configuration	19	5	413	5	con_figuration
confutation	16	6	872	5	con___futation
congratulation	17	8	282	5	congratulation
congregation	16	22	676	5	congr__egation
conjugation	21	4	662	5	con___jugation
continuations	15	4	714	5	cont_inu_ations
contributions	17	5	474	5	contribu__tions
contrition	12	4	1141	5	contri____tion
corrugation	14	4	599	5	c__or_rugation
denazification	29	15	443	5	denazification
densification	19	4	733	5	den_sification
denticulations	17	5	391	5	dent_iculations
devitrification	24	13	350	5	devitrification
electrification	22	6	341	5	electrification
esterification	19	9	533	5	_esterification
extrication	20	4	979	5	_extri__cation
gesticulation	16	9	469	5	gest_iculation
identification	20	5	499	5	ident_ification
matriculation	17	12	538	5	_matriculation
menstruation	14	5	522	5	menstr__u_ation
metrication	15	4	1065	5	me_tri__cation
nitrification	18	7	706	5	_nitrification
petrifaction	19	5	372	5	pe_trif_action
petrifications	21	4	802	5	pe_trifications
pontification	20	8	900	5	pont_ification
rectification	20	4	951	5	rect_ification
restimulation	15	5	537	5	rest_imulation
reticulation	14	4	805	5	re_t_iculation
retribution	13	11	498	5	re_tribu__tion
stridulation	13	5	477	5	__stridulation
tribulation	13	4	649	5	___tribulation
trifurcation	17	5	327	5	___trifurcation
trituration	11	4	665	5	___trituration
ventilation	14	4	816	5	vent_i__lation
verification	20	18	1064	5	ve__rification
vitrification	21	6	646	5	_vitrification

Search took 8 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	95024	0.123	1452772.4
2	DLD Change Limit	95024	64	7.283	13047.4
3	Display Results	64	64	0.046	1391.3
	(SQL Overall)	178691	64	7.452	23978.9