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

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

37 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
concussions	15	12	530	(None)
concessions	15	12	808	1	concessions
concussion	14	15	557	1	concussion_
concession	14	14	810	2	concession_
concisions	14	4	824	2	conc_isions
conclusions	15	4	488	2	conclusions
concussing	15	4	614	2	concussi_ng
confessions	16	13	660	2	confessions
confusions	15	4	628	2	confu_sions
contusions	12	4	698	2	contu_sions
convulsions	16	4	430	2	convulsions
collusions	12	4	596	3	collu_sions
combustions	17	4	450	3	combustions
commissions	17	4	526	3	commissions
compassions	17	4	576	3	compassions
compulsions	17	4	458	3	compulsions
conceptions	17	4	1054	3	conceptions
concessional	16	19	536	3	concessional
concessioner	16	5	366	3	concessioner
concessioners	17	5	304	3	concessioners
concision	13	4	849	3	conc_ision_
conclusion	14	4	522	3	conclusion_
concoctions	14	4	823	3	concoctions
concretions	15	4	926	3	concretions
concusses	13	4	634	3	concuss__es
concussive	17	4	420	3	concussi_ve
conductions	16	4	964	3	conductions
confession	15	12	646	3	confession_
confusion	14	4	647	3	confu_sion_
congestions	14	4	929	3	congestions
contusion	11	4	706	3	contu_sion_
conversions	16	4	825	3	conversions
convulsion	15	4	443	3	convulsion_
discussions	14	4	423	3	discussions
incursions	12	4	483	3	_incursions
percussions	15	4	487	3	percussions
pincushions	18	5	168	3	pincushions

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	121633	0.140	1276364.3
2	DLD Change Limit	121633	37	8.640	14077.9
3	Display Results	37	37	0.046	804.3
	(SQL Overall)	178691	37	8.826	20246.0