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

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

78 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
recensions	12	4	848	(None)
recension	11	4	886	1	recension_
recessions	12	4	893	1	recessions
ascensions	12	4	461	2	ascensions
declensions	14	4	333	2	declensions
descensions	14	4	437	2	descensions
precessions	15	4	855	2	precessions
prehensions	16	4	594	2	prehensions
pretensions	13	4	708	2	pretensions
recensors	11	7	613	2	recens_ors
receptions	14	4	974	2	receptions
recession	11	4	910	2	recession_
recisions	11	3	991	2	rec_isions
reclusions	12	4	624	2	reclusions
reconsigns	13	4	441	2	reconsigns
recursions	12	4	540	2	recursions
retentions	10	16	1111	2	retentions
reversions	13	4	757	2	reversions
secessions	12	4	646	2	secessions
accessions	14	4	525	3	accessions
ascension	11	4	470	3	ascension_
cessions	10	3	985	3	__cessions
deceptions	15	4	786	3	deceptions
decisions	12	4	838	3	dec_isions
declension	13	4	351	3	declension_
descension	13	4	454	3	descension_
detentions	11	14	880	3	detentions
dimensions	13	4	461	3	dimensions
eclosions	11	4	620	3	_eclosions
emersions	11	4	728	3	_emersions
eversions	12	3	836	3	_eversions
extensions	17	4	613	3	extensions
intensions	10	4	840	3	intensions
pensions	10	3	1169	3	__pensions
precensors	14	4	546	3	precens_ors
precession	14	4	882	3	precession_
precisions	14	4	937	3	prec_isions
preclusions	15	4	466	3	preclusions
prehension	15	4	631	3	prehension_
pretension	12	4	753	3	pretension_
preventions	16	4	853	3	preventions
processions	15	4	815	3	processions
reaccessions	16	5	276	3	reaccessions
rebellions	12	4	420	3	rebellions
recautions	12	4	781	3	recautions
recencies	13	3	1225	3	recenci_es
recensor	10	4	554	3	recens_o_r
reception	13	4	1032	3	reception_
recessing	12	6	1101	3	recessi_ng
recessional	13	5	498	3	recessional
recessionals	14	5	361	3	recessionals
recessives	15	4	567	3	recessives
recision	10	3	1027	3	rec_ision_
reclusion	11	4	650	3	reclusion_
reconsign	12	4	524	3	reconsign_
recreations	13	4	1225	3	recreations
recursion	11	4	615	3	recursion_
redesigns	11	4	407	3	rede_signs
refections	15	18	1164	3	refections
regressions	12	4	710	3	regressions
rejections	19	15	1010	3	rejections
remissions	12	4	661	3	remissions
repressions	13	4	896	3	repressions
repulsions	12	4	479	3	repulsions
rescissions	13	4	459	3	rescissions
reseasons	9	4	487	3	reseas_ons
resections	12	15	1303	3	resections
responsions	13	6	377	3	responsions
retention	9	16	1148	3	retention_
retorsions	10	4	571	3	retorsions
reunions	8	3	727	3	re_un_ions
reversion	12	4	809	3	reversion_
revisions	12	3	859	3	re_visions
revulsions	13	4	426	3	revulsions
scansions	11	4	532	3	_scansions
secession	11	4	670	3	secession_
seclusions	12	4	463	3	seclusions
tensions	8	3	1022	3	__tensions

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	140603	0.156	1145455.1
2	DLD Change Limit	140603	78	7.173	19601.7
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	7.375	24229.3