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

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

80 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
infiltrated	15	5	343	(None)
infiltrate	13	5	411	1	infiltrate_
infiltrates	14	6	394	1	infiltrates
filtrated	13	4	596	2	__filtrated
infiltrator	14	5	302	2	infiltrator
filtrate	11	4	822	3	__filtrate_
filtrates	12	4	773	3	__filtrates
incinerated	14	4	503	3	incinerated
infatuated	14	4	392	3	inf_atuated
infiltrating	16	5	325	3	infiltrating
infiltration	15	5	452	3	infiltration
infiltrative	18	5	281	3	infiltrative
infiltrators	15	5	274	3	infiltrators
inflated	12	4	1086	3	inf_l__ated
initiated	10	5	1011	3	in_i_tiated
invigorated	16	13	373	3	invigorated
nitrated	9	22	1315	3	_n_i_trated
affiliated	17	4	419	4	affil_iated
arbitrated	13	12	552	4	arbi_trated
citrated	11	27	1225	4	__ci_trated
cultrated	12	4	822	4	__cultrated
denitrated	12	9	803	4	deni_trated
enculturated	15	5	337	4	enculturated
enfiladed	14	4	299	4	enfil__aded
exhilarated	22	5	174	4	exhilarated
filiated	12	6	1008	4	__fil_iated
illustrated	12	6	273	4	illustrated
imitated	11	3	826	4	i_mi_t_ated
immigrated	16	4	331	4	immi_grated
impetrated	15	4	436	4	i_mpetrated
inaugurated	13	5	324	4	inaugurated
incinerate	12	4	646	4	incinerate_
incinerates	13	4	603	4	incinerates
inculcated	15	4	617	4	incul_cated
inculpated	15	4	573	4	incul_pated
indicated	13	3	1095	4	indi__cated
indurated	11	3	901	4	in__durated
infarcted	15	4	424	4	inf__arcted
infatuate	12	4	477	4	inf_atuate_
infatuates	13	4	449	4	inf_atuates
infiltrations	16	5	390	4	infiltrations
infirmed	14	20	534	4	infi__r_med
inflamed	14	4	603	4	inf_l__amed
inflate	10	3	1231	4	inf_l__ate_
inflater	11	4	989	4	inf_l__ater
inflates	11	5	1219	4	inf_l__ates
inflected	15	4	605	4	inf_l_ected
inflicted	15	4	553	4	inf_l_icted
infracted	15	4	636	4	inf___racted
infrared	12	3	619	4	inf___rared
infuriated	14	4	598	4	inf_uriated
ingratiated	13	5	402	4	ingratiated
initialed	10	6	535	4	in_i_tialed
initiate	8	4	1269	4	in_i_tiate_
initiates	9	4	1118	4	in_i_tiates
insinuated	11	4	481	4	insi_nuated
insolated	10	3	971	4	insol__ated
instated	9	16	1334	4	in__st_ated
insulated	10	3	1071	4	insul__ated
integrated	12	8	929	4	in_tegrated
intenerated	12	4	701	4	intenerated
intimated	12	10	1089	4	inti__mated
intimidated	15	12	492	4	intimidated
intreated	10	3	1266	4	in___treated
invalidated	16	5	361	4	invalidated
invigilated	16	5	400	4	invigilated
invigorate	14	13	437	4	invigorate_
invigorates	15	12	424	4	invigorates
irritated	10	7	613	4	irri_t_ated
itinerated	11	12	493	4	i_tinerated
nictated	11	3	779	4	_n_ict_ated
nitrate	7	20	1701	4	_n_i_trate_
nitrates	8	25	1622	4	_n_i_trates
titrated	9	26	1168	4	__ti_trated
uncastrated	14	4	538	4	uncastrated
unciliated	13	4	805	4	uncil_iated
undistracted	16	5	326	4	undistracted
unfiltered	14	4	356	4	unfilt_ered
unfitted	12	3	816	4	unfi_t__ted
unliberated	14	4	425	4	unliberated

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.170	1051123.5
2	DLD Change Limit	148819	80	9.393	15843.6
3	Display Results	80	80	0.046	1739.1
	(SQL Overall)	178691	80	9.609	18596.2