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

Here are the results of your fuzzy-string dictionary search for “intercession” 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
intercession	14	22	644	(None)
intercessions	15	22	588	1	intercessions
intersession	12	17	581	1	intersession
interception	16	4	940	2	interception
intercessional	16	6	364	2	intercessional
intercessor	13	5	433	2	intercess_or
intermission	14	6	465	2	intermission
intersessions	13	19	528	2	intersessions
antirecession	15	6	267	3	antirecession
ingression	11	4	551	3	in_gr_ession
interceptions	17	5	818	3	interceptions
intercessors	14	5	388	3	intercessors
intercessory	17	5	317	3	intercessory
interfusion	14	6	498	3	inter_fusion
interjection	21	9	892	3	interjection
intermissions	15	9	414	3	intermissions
intersection	14	6	1018	3	intersection
interspersion	15	6	439	3	interspersion
intervention	15	6	838	3	intervention
antecessor	12	5	232	4	ante_cess_or
impression	14	4	709	4	i_mpr_ession
indecision	13	4	441	4	inde_c_ision
ingressions	12	4	549	4	in_gr_essions
intellection	14	6	617	4	intellection
intension	9	4	849	4	int___ension
interaction	13	4	1181	4	inter_action
interbasin	12	4	685	4	inter_basi_n
intercalation	15	5	708	4	intercalation
interceding	15	6	804	4	interce_ding
intercensal	13	5	615	4	intercens_al
intercepting	17	4	888	4	intercepting
interceptor	15	15	655	4	interce_ptor
interchain	15	4	664	4	interc_hai_n
interconversion	20	7	248	4	interc~~onv~~ersion
intercrossing	16	5	314	4	intercrossing
interdiction	15	6	814	4	interdiction
interesting	12	4	1112	4	inter_esting
interferon	13	4	685	4	interfe__ron
interfusions	15	7	439	4	inter_fusions
interjections	22	7	799	4	interjections
interleukin	15	5	445	4	interleuki_n
intermedin	13	4	744	4	interme_di_n
intermeshing	18	5	505	4	intermeshing
interneuron	11	5	407	4	interne_uron
interposition	15	8	605	4	interposition
interrelation	13	5	873	4	interrelation
interruption	14	6	640	4	interruption
intersections	15	9	896	4	intersections
interspersions	16	6	387	4	interspersions
interstation	12	4	1041	4	interstation
interunion	10	4	625	4	inter__union
interventions	16	5	751	4	interventions
introgression	14	6	305	4	introgression
intromission	14	14	320	4	intromission
introversion	15	5	408	4	introversion
intrusion	9	4	681	4	int_r__usion
inversion	12	4	721	4	inver___sion
percussion	14	4	499	4	__percussion
postrecession	17	6	217	4	postrecession
precession	14	4	882	4	_pre_cession
prerecession	16	8	357	4	_prerecession
recession	11	4	910	4	__re_cession
repercussion	16	5	225	4	repercussion
retrocession	14	9	445	4	retrocession
secession	11	4	670	4	__se_cession
supersession	14	5	484	4	supersession

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.780	229091.0
2	DLD Change Limit	124790	66	7.546	16537.2
3	Display Results	66	66	0.046	1434.8
	(SQL Overall)	178691	66	8.372	21343.9