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

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

64 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
ingestion	10	13	748	(None)
ingestions	11	9	759	1	ingestions
congestion	13	4	904	2	congestion
digestion	11	4	657	2	digestion
egestion	9	4	686	2	_egestion
inception	13	4	869	2	inception
indention	10	4	951	2	indention
indigestion	13	5	375	2	indigestion
infection	14	4	1047	2	infection
ingesting	11	12	962	2	ingesting
ingestive	13	4	739	2	ingestive
ingression	11	4	551	2	ingression
inhesion	11	11	637	2	inhes_ion
injection	18	3	865	2	injection
insertion	9	4	1059	2	insertion
intention	9	4	1201	2	intention
invention	12	4	833	2	invention
congestions	14	4	931	3	congestions
digestions	12	4	640	3	digestions
egestions	10	4	670	3	_egestions
ideation	9	3	1049	3	i_deation
ignition	9	4	653	3	i_gnition
inaction	10	3	962	3	in_action
inanition	9	4	729	3	inanition
incaution	11	4	658	3	incaution
inceptions	14	4	853	3	inceptions
incision	10	4	760	3	incis_ion
incretion	11	4	905	3	incretion
indentions	11	4	906	3	indentions
indexation	18	4	634	3	indexation
indiction	12	3	981	3	indiction
indigestions	14	5	364	3	indigestions
induction	12	4	898	3	induction
infections	15	5	1023	3	infections
infestation	14	4	704	3	infestation
infesting	13	10	951	3	infesting
inflation	12	3	1109	3	inflation
inflection	15	4	763	3	inflection
infusion	11	4	652	3	infus_ion
ingest	7	31	1900	3	ingest___
ingesta	8	35	786	3	ingest__a
ingested	10	25	900	3	ingest_ed
ingestible	13	4	633	3	ingestible
ingests	8	32	1098	3	ingest__s
ingressions	12	4	549	3	ingressions
inhesions	12	11	612	3	inhes_ions
injections	19	4	866	3	injections
insertions	10	4	1034	3	insertions
inspection	14	4	666	3	inspection
intension	9	4	849	3	intension
intentions	10	4	1140	3	intentions
intestine	9	4	1185	3	intestine
intuition	9	4	762	3	intuition
inunction	11	4	689	3	inunction
invasion	11	11	547	3	invas_ion
inventions	13	4	831	3	inventions
inversion	12	4	721	3	inversion
invertin	11	9	1023	3	inverti_n
investing	13	11	939	3	investing
investor	11	24	741	3	invest_or
lineation	9	3	1076	3	lin_eation
negation	9	29	1302	3	_negation
question	17	4	582	3	_question
suggestion	12	5	301	3	suggestion

Search took 8 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	148641	0.420	425454.8
2	DLD Change Limit	148641	64	7.343	20242.5
3	Display Results	64	64	0.033	1939.4
	(SQL Overall)	178691	64	7.796	22920.9