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

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

66 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
facilitating	18	5	400	(None)
facilitation	17	4	657	2	facilitation
facilitations	18	4	576	2	facilitations
facilitative	20	5	288	2	facilitative
habilitating	18	5	337	2	habilitating
acclimating	18	4	528	3	_acclimating
affiliating	18	4	416	3	affili_ating
debilitating	16	5	411	3	debilitating
facelifting	20	5	211	3	faceli_fting
facilitate	15	4	457	3	facilitat__e
facilitated	17	5	364	3	facilitat_ed
facilitates	16	4	430	3	facilitat_es
facilitator	16	5	298	3	facilitat_or
facilitators	17	5	278	3	facilitators
facilitatory	20	6	229	3	facilitatory
felicitating	18	5	332	3	felicitating
filiating	13	3	924	3	f__ili_ating
militating	13	4	882	3	__militating
vacillating	17	4	461	3	vacil_lating
acidulating	15	4	428	4	_acidulating
acierating	13	4	831	4	_aci_erating
acquitting	22	4	365	4	_acquit_ting
activating	16	4	785	4	_ac_tivating
acuminating	16	4	580	4	_acuminating
acylating	15	4	756	4	_acyl__ating
agitating	11	3	885	4	_a__gitating
backfitting	23	5	307	4	backfit_ting
backlighting	25	5	247	4	backlighting
backlisting	20	4	386	4	backli_sting
capacitating	19	5	255	4	capacitating
cavitating	16	4	690	4	__cavitating
cogitating	14	4	721	4	__cogitating
conciliating	17	7	561	4	concili_ating
decapitating	18	5	495	4	decapitating
excogitating	23	5	246	4	excogitating
fabricating	19	4	503	4	fa_bricating
fabulating	16	4	551	4	fabul__ating
facetting	15	3	528	4	fac__et_ting
facilities	15	4	982	4	facili__ties
facultative	19	5	256	4	facul_tative
fascinating	17	4	524	4	fa_scinating
filtrating	14	4	597	4	f__iltrating
flitting	12	30	1088	4	f___lit_ting
foliating	13	3	925	4	f__oli_ating
habilitation	17	9	551	4	habilitation
habilitations	18	8	486	4	habilitations
humiliating	17	4	407	4	humili_ating
imitating	12	3	876	4	___imitating
jacklighting	30	5	172	4	jacklighting
jaculating	20	4	729	4	jacul__ating
lactating	12	3	918	4	lac___tating
machinating	19	4	561	4	mac_hinating
maculating	15	4	954	4	macul__ating
nictitating	14	4	438	4	nic_titating
oscillating	14	4	397	4	oscil_lating
palliating	13	4	788	4	pa_lli_ating
palpitating	16	4	465	4	pa_lpitating
precipitating	20	7	403	4	precipitating
rehabilitating	20	6	185	4	rehabilitating
sailboating	14	5	345	4	sa_ilboating
salivating	14	4	743	4	sa__livating
sanitating	11	4	964	4	sa__nitating
tailgating	12	4	490	4	ta_il_gating
vaccinating	19	4	518	4	vac_cinating
validating	15	4	583	4	va__lidating
vaticinating	18	5	355	4	vaticinating

Search took 9 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	124790	0.390	458182.1
2	DLD Change Limit	124790	66	7.766	16068.8
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	8.186	21828.9