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

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

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.

97 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
invitation	13	4	1002	(None)
incitation	12	3	1222	1	incitation
invitations	14	4	905	1	invitations
cavitation	15	4	913	2	cavitation
imitation	11	5	1085	2	i_mitation
incitations	13	3	1088	2	incitations
indication	13	3	1203	2	indication
infixation	20	4	753	2	infixation
initiation	10	4	1210	2	in_itiation
intimation	12	4	1304	2	intimation
invitational	15	5	490	2	invitational
invocation	15	4	754	2	invocation
irritation	10	4	897	2	irritation
levitation	13	4	944	2	levitation
agitation	10	3	1122	3	_agitation
animation	11	3	1368	3	an_imation
annotation	10	4	775	3	annotation
aviation	11	3	1274	3	_avi_ation
capitation	14	3	1136	3	capitation
cavitations	16	4	784	3	cavitations
citation	10	3	1436	3	__citation
cogitation	13	4	1008	3	cogitation
deviation	13	3	1239	3	devi_ation
divination	14	13	923	3	divination
dubitation	13	7	733	3	dubitation
equitation	19	4	834	3	equitation
excitation	19	4	1017	3	excitation
gravitation	15	4	551	3	gravitation
habitation	15	4	791	3	habitation
hesitation	13	4	963	3	hesitation
imitations	12	5	996	3	i_mitations
imputation	14	4	712	3	imputation
incantation	13	4	705	3	incantation
inclination	13	4	973	3	inclination
incubation	14	4	836	3	incubation
indagation	12	4	615	3	indagation
indentation	12	4	837	3	indentation
indexation	18	4	634	3	indexation
indications	14	3	1097	3	indications
indiction	12	3	981	3	indi_ction
indignation	13	4	653	3	indignation
induration	11	4	1061	3	induration
infatuation	14	4	493	3	infatuation
infestation	14	4	704	3	infestation
infiltration	15	5	452	3	infiltration
infixations	21	4	669	3	infixations
inflation	12	3	1109	3	in_flation
inhabitation	17	5	432	3	inhabitation
inhalation	13	10	766	3	inhalation
inhibition	15	4	534	3	inhibition
inhumation	15	6	705	3	inhumation
initiations	11	4	1072	3	in_itiations
innovation	13	4	564	3	innovation
insanitation	12	12	718	3	insanitation
insinuation	11	13	726	3	insinuation
insolation	10	4	1021	3	insolation
inspiration	13	4	837	3	inspiration
instigation	12	4	924	3	instigation
institution	11	4	529	3	institution
insulation	10	3	1166	3	insulation
intimations	13	4	1188	3	intimations
intinction	12	4	778	3	intinction
intonation	10	4	1026	3	intonation
intubation	12	4	777	3	intubation
inundation	11	11	617	3	inundation
invagination	16	4	564	3	invagination
invalidation	16	4	604	3	invalidation
invasion	11	11	547	3	inv__asion
invention	12	4	833	3	inv_ention
invigilation	16	5	514	3	invigilation
invigoration	16	5	459	3	invigoration
invitationals	16	5	274	3	invitation~~als~~
invitatory	16	4	478	3	invitatory
invocations	16	4	706	3	invocations
involution	13	4	594	3	involution
iodination	11	5	998	3	iodination
ionization	19	4	1127	3	ionization
irrigation	11	4	780	3	irrigation
irritations	11	4	783	3	irritations
levigation	14	4	702	3	levigation
levitations	14	4	829	3	levitations
limitation	12	4	915	3	limitation
meditation	13	4	1074	3	meditation
miscitation	15	4	777	3	miscitation
natation	8	15	1393	3	_n_atation
navigation	14	4	600	3	navigation
nictation	11	8	927	3	_nictation
nidation	9	4	1058	3	_n_idation
nitration	9	3	1344	3	_n_itration
notation	8	14	1460	3	_n_otation
nutation	8	15	1310	3	_n_utation
obviation	14	4	609	3	obvi_ation
recitation	12	3	1594	3	recitation
sanitation	10	4	1204	3	sanitation
vindication	17	4	635	3	vindication
visitation	13	4	859	3	visitation
vitiation	12	3	956	3	__vitiation

Search took 7 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	140603	0.406	440125.6
2	DLD Change Limit	140603	97	5.720	24580.9
3	Display Results	97	97	0.046	2108.7
	(SQL Overall)	178691	97	6.172	28951.9