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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

109 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
facilitates	16	4	430	(None)
facilitate	15	4	457	1	facilitate_
facilitated	17	5	364	1	facilitated
facilitator	16	5	298	2	facilitator
facilitators	17	5	278	2	facilitators
facilities	15	4	982	2	facilit_ies
habilitates	16	7	358	2	habilitates
acclimates	16	4	591	3	_acclimates
affiliates	16	4	489	3	affili_ates
ciliates	10	4	1345	3	__cili_ates
debilitates	14	4	447	3	debilitates
facilitating	18	5	400	3	facilitating
facilitation	17	4	657	3	facilitation
facilitations	18	4	576	3	facilitations
facilitative	20	5	288	3	facilitative
facilitatory	20	6	229	3	facilitatory
felicitates	16	4	420	3	felicitates
filiates	11	4	1266	3	f__ili_ates
habilitate	15	7	380	3	habilitate_
habilitated	17	8	293	3	habilitated
militates	11	3	1088	3	__militates
vacillates	15	5	571	3	vacil_lates
abilities	11	7	1414	4	_abilit_ies
acclimate	15	4	623	4	_acclimate_
acclimated	17	4	515	4	_acclimated
acetates	10	20	1306	4	_ac__etates
acidities	12	8	1018	4	_acidit_ies
acidulates	13	21	584	4	_acidulates
acierates	11	3	1081	4	_aci_erates
activates	14	4	968	4	_ac_tivates
acuminates	14	4	688	4	_acuminates
acylates	13	3	974	4	_acyl__ates
affiliate	15	4	532	4	affili_ate_
affiliated	17	4	419	4	affili_ated
agilities	10	8	1097	4	_agilit_ies
agitates	9	3	1088	4	_a__gitates
anilities	9	5	1600	4	_anilit_ies
califates	14	3	1011	4	__califates
capacitates	17	5	301	4	capacitates
cavitates	14	16	896	4	__cavitates
celibates	13	5	863	4	__celibates
ciliate	9	5	1460	4	__cili_ate_
ciliated	11	5	1095	4	__cili_ated
climates	12	3	1197	4	__c_limates
cogitates	12	4	786	4	__cogitates
conciliates	15	4	688	4	concili_ates
debilitate	13	4	486	4	debilitate_
debilitated	15	4	381	4	debilitated
decapitates	16	5	564	4	decapitates
decilitres	13	4	499	4	decilit_res
docilities	13	4	900	4	docilit_ies
excogitates	21	5	260	4	excogitates
fabricates	17	4	646	4	fa_bricates
fabulates	14	4	773	4	fabul__ates
facelifted	19	5	217	4	faceli_fted
facelifts	17	4	286	4	faceli_ft_s
faceplates	17	4	461	4	fac_eplates
facility	16	3	824	4	facili__t_y
facticities	18	4	687	4	facticit_ies
faculties	14	5	514	4	facul_t_ies
familiars	14	6	475	4	famili_a_rs
families	13	3	944	4	famili___es
fasciitises	16	5	256	4	fasci_itises
fascinates	15	4	715	4	fa_scinates
fascioliases	17	13	144	4	fascioli_ases
fatalities	13	4	944	4	fatalit_ies
fayalites	15	4	606	4	fayali__tes
felicitate	15	4	446	4	felicitate_
felicitated	17	4	356	4	felicitated
filiate	10	4	1423	4	f__ili_ate_
filiated	12	6	1008	4	f__ili_ated
filtrates	12	4	773	4	f__iltrates
foliates	11	4	1275	4	f__oli_ates
fragilities	15	4	716	4	fragilit_ies
futilities	13	4	886	4	futilit_ies
gracilities	14	4	768	4	gracilit_ies
humiliates	15	4	462	4	humili_ates
imitates	10	3	1050	4	___imitates
jaculates	18	28	1036	4	jacul__ates
kalifates	16	4	613	4	ka__lifates
labilities	12	7	1223	4	labilit_ies
laciniate	11	5	684	4	lacini_ate_
lactates	10	3	1122	4	lac___tates
machinates	17	4	732	4	mac_hinates
maculates	13	20	1372	4	macul__ates
militate	10	3	1167	4	__militate_
militated	12	4	880	4	__militated
nictitates	12	4	495	4	nic_titates
oscillates	12	4	477	4	oscil_lates
paclitaxel	21	5	98	4	pac_litaxel
paclitaxels	22	5	66	4	pac_litaxels
palliates	11	3	1103	4	pa_lli_ates
palmitates	14	4	545	4	pa_lmitates
palpitates	14	4	530	4	pa_lpitates
precipitates	18	5	463	4	precipitates
raclettes	11	4	701	4	rac_let_tes
rehabilitates	18	5	194	4	rehabilitates
salivates	12	3	929	4	sa__livates
sanitates	9	6	1173	4	sa__nitates
silicates	11	3	1152	4	__silicates
tactilities	13	4	767	4	tactilit_ies
tailgates	10	4	653	4	ta_il_gates
unciliated	13	4	805	4	uncili_ated
vaccinates	17	4	656	4	vac_cinates
vacillate	14	5	684	4	vacil_late_
vacillated	16	5	462	4	vacil_lated
vagilities	14	4	795	4	vagilit_ies
validates	13	3	824	4	va__lidates
vaticinates	16	4	392	4	vaticinates

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.410	435831.7
2	DLD Change Limit	148819	109	9.200	16176.0
3	Display Results	109	109	0.050	2180.0
	(SQL Overall)	178691	109	9.660	18498.0