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

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

70 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
cessations	12	5	647	(None)
cassations	12	7	687	1	cassations
cessation	11	7	685	1	cessation_
caseations	12	5	830	2	caseations
cassation	11	9	791	2	cassation_
causations	12	6	814	2	causations
cessions	10	3	985	2	cess__ions
gestations	11	3	977	2	gestations
restations	10	3	1584	2	restations
sensations	10	5	985	2	sensations
accusations	15	4	600	3	accusations
aerations	9	3	1790	3	ae_rations
carnations	12	3	1135	3	carnations
caseation	11	9	951	3	caseation_
castrations	13	4	1005	3	castrations
cations	9	45	2414	3	c___ations
caudations	13	10	822	3	caudations
causation	11	9	952	3	causation_
ceratins	10	28	1873	3	ce_rati_ns
cesarians	11	4	636	3	ce_sarians
cession	9	3	981	3	cess__ion_
chelations	15	3	907	3	chelations
ciliations	12	11	1100	3	ciliations
citations	11	3	1250	3	c_itations
clavations	15	4	618	3	clavations
cognations	13	3	959	3	cognations
collations	12	3	1285	3	collations
conations	11	13	1890	3	c_onations
connations	12	3	1294	3	connations
creations	11	26	1454	3	c_reations
cremations	14	4	1071	3	cremations
crenations	12	5	1169	3	crenations
dealations	11	3	1137	3	dealations
decussations	15	4	367	3	decussations
deflations	14	3	971	3	deflations
delations	10	26	1659	3	de_lations
dentations	11	4	1363	3	dentations
desertions	11	3	988	3	desertions
desolations	12	3	1059	3	desolations
deviations	14	3	1116	3	deviations
elations	8	37	1912	3	_e_lations
enations	8	33	1690	3	_e_nations
equations	18	3	949	3	_equations
fellations	13	3	806	3	fellations
fetations	12	5	1138	3	fe_tations
gelations	10	25	1309	3	ge_lations
gemmations	15	4	500	3	gemmations
gestation	10	3	1066	3	gestation_
gustations	11	4	723	3	gustations
hesitations	14	4	854	3	hesitations
legations	10	27	1192	3	le_gations
mediations	13	3	1098	3	mediations
mentations	12	3	1258	3	mentations
negations	10	28	1196	3	ne_gations
nervations	13	5	948	3	nervations
peltations	12	3	1155	3	peltations
pulsations	12	3	637	3	pulsations
reflations	13	3	1123	3	reflations
relations	9	24	1833	3	re_lations
resections	12	15	1303	3	resections
restation	9	3	1691	3	restation_
sedations	10	3	1125	3	se_dations
sensation	9	5	1058	3	sensation_
seriations	10	3	1668	3	seriations
serrations	10	3	1309	3	serrations
sessions	8	3	972	3	sess__ions
stations	8	24	1522	3	__stations
venations	12	3	1172	3	ve_nations
vernations	13	3	1033	3	vernations
vexations	19	3	775	3	ve_xations

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.156	1145455.1
2	DLD Change Limit	140603	70	6.453	21788.8
3	Display Results	70	70	0.033	2121.2
	(SQL Overall)	178691	70	6.642	26903.2