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

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

57 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
decongestion	16	5	392	(None)
decongestions	17	5	356	1	decongestions
congestion	13	4	904	2	__congestion
decongesting	17	5	373	2	decongesting
decongestive	19	5	239	2	decongestive
congestions	14	4	931	3	__congestions
decondition	15	4	541	3	decon_dition
decongest	13	4	563	3	decongest___
decongestant	16	6	246	3	decongestant
decongested	16	6	307	3	decongest_ed
decongests	14	4	324	3	decongest__s
reconception	18	5	564	3	reconception
reconnection	16	5	599	3	reconnection
conception	16	4	1045	4	__conception
concession	14	14	813	4	__concession
confection	17	4	1118	4	__confection
confession	15	12	650	4	__confession
congelation	14	4	1034	4	__congelation
congesting	14	4	1011	4	__congesting
congestive	16	4	761	4	__congestive
connection	14	4	1053	4	__connection
contention	12	4	1222	4	__contention
convection	17	4	1112	4	__convection
convention	15	4	1056	4	__convention
decantation	14	4	894	4	decan_tation
deception	14	4	832	4	dec___eption
decoction	14	4	752	4	deco___ction
decollation	14	4	819	4	deco_llation
decommission	19	5	299	4	decommission
decompensation	21	9	336	4	decompensation
decomposition	20	5	307	4	decomposition
decompression	20	10	276	4	decompression
deconditions	16	4	528	4	decon_ditions
decongestants	17	7	189	4	decongestants
deconsecration	19	5	478	4	deconsecration
decoration	13	3	1442	4	deco__ration
deionization	22	4	988	4	deionization
delineation	12	4	776	4	delin_eation
demonization	24	4	1094	4	demonization
denegation	12	4	941	4	de__negation
derogation	12	4	1039	4	dero_g_ation
detonation	11	3	1094	4	deton__ation
digestion	11	4	657	4	d___igestion
disconnection	18	5	420	4	disconnection
egestion	9	4	686	4	_e___gestion
elongation	11	4	535	4	_elong_ation
ingestion	10	13	748	4	___ingestion
preconception	21	5	428	4	preconception
preconvention	20	7	400	4	preconvention
recognition	14	4	520	4	reco_gnition
recollection	16	5	485	4	recollection
reconceptions	19	6	512	4	reconceptions
recondition	14	4	712	4	recon_dition
reconnections	17	6	575	4	reconnections
reconversion	17	5	402	4	reconversion
reconviction	19	5	508	4	reconviction
redigestion	13	8	415	4	re_digestion

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	124790	0.393	454684.5
2	DLD Change Limit	124790	57	6.653	18757.0
3	Display Results	57	57	0.033	1727.3
	(SQL Overall)	178691	57	7.079	25242.4