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

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

62 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
congestion	13	4	904	(None)
congestions	14	4	931	1	congestions
conception	16	4	1045	2	conception
concession	14	14	813	2	concession
confection	17	4	1118	2	confection
confession	15	12	650	2	confession
congelation	14	4	1034	2	congelation
congesting	14	4	1011	2	congesting
congestive	16	4	761	2	congestive
connection	14	4	1053	2	connection
contention	12	4	1222	2	contention
convection	17	4	1112	2	convection
convention	15	4	1056	2	convention
decongestion	16	5	392	2	decongestion
ingestion	10	13	748	2	_ingestion
cognation	12	3	1075	3	co_gnation
cognition	12	4	701	3	co_gnition
cohesion	13	4	728	3	co_hes_ion
collection	14	4	820	3	collection
combustion	16	4	456	3	combustion
conation	10	14	2088	3	con__ation
conceptions	17	4	1059	3	conceptions
concertino	14	9	1084	3	concertino
concessions	15	12	810	3	concessions
concision	13	4	849	3	concis_ion
concoction	13	4	823	3	concoction
concretion	14	4	929	3	concretion
concussion	14	15	557	3	concussion
condensation	15	4	678	3	condensation
condition	12	4	1116	3	con_dition
conduction	15	4	996	3	conduction
confections	18	4	1139	3	confections
confessions	16	13	663	3	confessions
conflation	15	4	1208	3	conflation
confusion	14	4	647	3	confus_ion
congelations	15	4	973	3	congelations
congest	10	46	1877	3	congest___
congested	13	3	867	3	congest_ed
congests	11	35	1038	3	congest__s
congregation	16	22	676	3	congregation
connation	11	3	1426	3	con_nation
connections	15	4	1070	3	connections
connexion	18	7	460	3	conne_xion
conniption	14	4	627	3	conniption
consecution	15	4	731	3	consecution
contentions	13	4	1209	3	contentions
contestation	14	4	866	3	contestation
contesting	13	3	1221	3	contesting
contortion	12	4	866	3	contortion
contrition	12	4	1142	3	contrition
contusion	11	4	706	3	contus_ion
convections	18	4	1149	3	convections
conventions	16	4	1053	3	conventions
conversation	17	4	780	3	conversation
conversion	15	4	842	3	conversion
conviction	17	4	818	3	conviction
correction	14	4	881	3	correction
decongestions	17	5	356	3	decongestions
digestion	11	4	657	3	_digestion
egestion	9	4	686	3	__egestion
ingestions	11	9	759	3	_ingestions
suggestion	12	5	301	3	suggestion

Search took 7 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	140603	0.406	440125.6
2	DLD Change Limit	140603	62	6.186	22729.2
3	Display Results	62	62	0.046	1347.8
	(SQL Overall)	178691	62	6.638	26919.4