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

Here are the results of your fuzzy-string dictionary search for “precession” 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
precession	14	4	882	(None)
precessions	15	4	855	1	precessions
procession	14	4	841	1	procession
recession	11	4	910	1	_recession
percussion	14	4	499	2	percussion
precessing	15	9	874	2	precessing
precessional	16	5	512	2	precessional
precision	13	4	1005	2	prec_ision
preclusion	14	4	521	2	preclusion
prehension	15	4	631	2	prehension
prerecession	16	8	357	2	prerecession
pretension	12	4	753	2	pretension
processions	15	4	815	2	processions
profession	15	4	659	2	profession
recension	11	4	886	2	_recension
recessions	12	4	893	2	_recessions
secession	11	4	670	2	_secession
accession	13	4	523	3	_accession
cession	9	3	981	3	___cession
concession	14	14	813	3	concession
perception	16	8	861	3	perception
percussions	15	4	487	3	percussions
permission	14	4	571	3	permission
perversion	15	4	585	3	perversion
possession	12	6	484	3	possession
postrecession	17	6	217	3	p~~ost~~recession
preassign	12	4	457	3	pre_assign
precaution	14	4	724	3	precaution
precensor	13	4	525	3	precens_or
precess	11	3	1086	3	precess___
precessed	14	3	752	3	precess_ed
precesses	13	3	1046	3	precess_es
precisian	13	4	781	3	prec_isian
precisions	14	4	937	3	prec_isions
preclusions	15	4	466	3	preclusions
prehensions	16	4	594	3	prehensions
prelection	14	15	1129	3	prelection
prelusion	11	5	660	3	pre_lusion
preseason	11	4	412	3	preseas_on
pretensions	13	4	708	3	pretensions
prevention	15	4	917	3	prevention
prevision	14	4	800	3	pre_vision
processing	15	10	818	3	processing
processional	16	6	539	3	processional
processioned	17	5	397	3	processioned
processor	13	4	623	3	process_or
professions	16	4	663	3	professions
progression	14	5	588	3	progression
reaccession	15	5	295	3	_reaccession
recensions	12	4	848	3	_recensions
reception	13	4	1032	3	_reception
recessing	12	6	1101	3	_recessing
recessional	13	5	498	3	_recessional
recessive	14	4	726	3	_recessive
recision	10	3	1027	3	_rec_ision
reclusion	11	4	650	3	_reclusion
recursion	11	4	615	3	_recursion
regression	11	4	695	3	_regression
remission	11	4	733	3	_remission
repression	12	4	904	3	_repression
rescission	12	4	486	3	_rescission
reversion	12	4	809	3	_reversion
secessions	12	4	646	3	_secessions
succession	14	5	401	3	succession

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	64	6.250	22496.5
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	6.686	26726.1