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

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

94 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
insertion	9	4	1059	(None)
insertions	10	4	1034	1	insertions
assertion	9	4	672	2	assertion
desertion	10	4	1020	2	desertion
exsertion	16	4	685	2	exsertion
inception	13	4	869	2	inception
incretion	11	4	905	2	incretion
indention	10	4	951	2	indention
infection	14	4	1047	2	infection
ingestion	10	13	748	2	ingestion
injection	18	3	865	2	injection
inserting	10	9	1424	2	inserting
insertional	11	4	746	2	insertional
inspection	14	4	666	2	inspection
intention	9	4	1201	2	intention
invention	12	4	833	2	invention
inversion	12	4	721	2	inversion
invertin	11	9	1023	2	inverti_n
reinsertion	11	4	544	2	reinsertion
assertions	10	4	658	3	assertions
bisection	13	13	698	3	bisection
caseation	11	9	951	3	caseation
desertions	11	3	988	3	desertions
dissection	13	15	861	3	dissection
dissention	11	18	807	3	dissention
exertion	15	3	1008	3	_exertion
exsection	18	4	749	3	exsection
exsertions	17	4	674	3	exsertions
ideation	9	3	1049	3	i_deation
immersion	13	4	428	3	immersion
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
incretions	12	4	865	3	incretions
incursion	11	4	522	3	incursion
indentions	11	4	906	3	indentions
indexation	18	4	634	3	indexation
indiction	12	3	981	3	indiction
induction	12	4	898	3	induction
induration	11	4	1061	3	induration
inertia	7	4	1020	3	in_erti_a
inertiae	8	4	1147	3	in_ertiae
inertial	8	4	1172	3	in_ertial
inertias	8	4	1038	3	in_ertias
infarction	15	4	579	3	infarction
infections	15	5	1023	3	infections
inferior	11	5	642	3	infer_ior
infertile	12	4	867	3	infertile
inflation	12	3	1109	3	inflation
inflection	15	4	763	3	inflection
ingestions	11	9	759	3	ingestions
inheritor	12	4	563	3	inheritor
inhesion	11	11	637	3	inhe_sion
injections	19	4	866	3	injections
innervation	14	4	744	3	innervation
inscription	15	4	495	3	inscription
insectan	10	4	539	3	insect_an
insectile	11	4	711	3	insectile
insentient	10	4	942	3	insentient
insert	6	43	2525	3	insert___
inserted	9	24	1305	3	insert_ed
inserter	8	23	1213	3	insert_er
inserters	9	22	1028	3	inserters
inserts	7	40	1399	3	insert__s
insetting	10	7	928	3	insetting
insolation	10	4	1021	3	insolation
inspections	15	4	642	3	inspections
inspiration	13	4	837	3	inspiration
instruction	13	13	794	3	instruction
insulation	10	3	1166	3	insulation
integration	12	13	1049	3	integration
intension	9	4	849	3	intension
intentions	10	4	1140	3	intentions
interaction	13	4	1181	3	interaction
interior	8	5	1309	3	inter_ior
interjoin	16	4	789	3	interjoin
intertie	8	3	1761	3	interti_e
interties	9	3	2033	3	interties
intertill	9	4	1042	3	intertill
interunion	10	4	625	3	interunion
intuition	9	4	762	3	intuition
inunction	11	4	689	3	inunction
inventions	13	4	831	3	inventions
inversions	13	4	700	3	inversions
inverting	13	10	1322	3	inverting
invertins	12	9	1102	3	invertins
invertor	11	23	897	3	invert_or
iteration	9	5	1503	3	i_teration
lineation	9	3	1076	3	lin_eation
midsection	15	4	443	3	midsection
reinsertions	12	4	527	3	reinsertions
resection	11	16	1327	3	resection
section	9	25	1566	3	__section

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	94	7.360	20195.8
3	Display Results	94	94	0.046	2043.5
	(SQL Overall)	178691	94	7.826	22833.0