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

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

53 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
interactants	14	6	450	(None)
interactant	13	5	704	1	interactant_
attractants	13	5	285	3	_attractants
injectants	19	4	328	3	inje__ctants
interabangs	14	5	312	3	intera_bangs
interacting	14	4	1171	3	interactin_g
interactions	14	4	1046	3	interactions
interacts	11	3	1212	3	interac___ts
interplants	13	11	675	3	inter_plants
attractant	12	5	415	4	_attractant_
infectant	14	4	683	4	infe__ctant_
infestants	13	4	450	4	infe__stants
injectant	18	4	529	4	inje__ctant_
integrants	11	4	669	4	inte__grants
intendants	11	4	525	4	inte__ndants
interabang	13	4	448	4	intera_ban_g
interact	10	3	1647	4	interac___t_
interacted	13	4	1121	4	interact__ed
interaction	13	4	1181	4	interact_ion
interactional	15	5	700	4	interactional
interactive	16	5	963	4	interact_ive
intercalate	13	11	770	4	intercala_te
intercalates	14	11	726	4	intercalates
intercaste	12	4	928	4	inter_c_aste
intercepts	14	4	863	4	inter_c_epts
interchange	17	10	458	4	inter_change
interchanges	18	9	426	4	inter_changes
interclan	11	4	860	4	inter_clan__
interclass	12	4	699	4	inter_cla_ss
intercounty	16	5	469	4	inter_county
intercuts	11	4	878	4	inter_c__uts
interfacings	18	5	435	4	interfac_ings
intergrafts	15	4	441	4	inter_grafts
interlacements	18	6	266	4	interlacements
interloans	10	4	826	4	inter_loan_s
intermats	11	14	1245	4	inter__ma_ts
interments	12	7	1621	4	inter__ments
internments	13	5	1028	4	inter_nments
interocean	12	4	648	4	interocean__
interoceanic	16	5	387	4	interoceanic
interplant	12	11	957	4	inter_plant_
interrobangs	15	5	268	4	interrobangs
interstate	10	7	1097	4	inter_sta_te
interstates	11	7	1020	4	inter_states
intoxicants	20	6	304	4	intoxic_ants
intractable	15	5	736	4	int_ractable
intractably	18	5	666	4	int_ractably
intrants	8	3	1286	4	int_r___ants
intrastate	10	5	571	4	int_rasta_te
intrigants	11	4	505	4	int_r_igants
intriguants	12	5	282	4	int_riguants
reactants	11	4	662	4	__re_actants
retreatants	11	5	255	4	retrea_tants

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.393	454684.5
2	DLD Change Limit	124790	53	8.170	15274.2
3	Display Results	53	53	0.030	1766.7
	(SQL Overall)	178691	53	8.593	20794.9