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

Here are the results of your fuzzy-string dictionary search for “creativities” with Change Limit: [1] [2] [3] [4] [5]

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.

89 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
creativities	17	5	578	(None)
reactivities	17	5	617	2	_reactivities
relativities	15	5	577	2	_relativities
captivities	18	4	594	3	c_aptivities
coercivities	19	5	424	3	coercivities
creatinines	13	4	404	3	creatini_nes
creatives	14	27	969	3	creativ___es
creativity	18	4	516	3	creativit__y
directivities	19	5	419	3	directivities
erectilities	14	4	712	3	erectilities
festivities	17	4	658	3	_festivities
nativities	13	4	843	3	__nativities
negativities	16	5	487	3	negativities
noncreativities	20	8	276	3	~~non~~creativities
activities	15	4	890	4	__activities
adaptivities	18	5	312	4	adaptivities
additivities	17	5	311	4	additivities
affectivities	24	5	351	4	affectivities
arabilities	13	4	1310	4	ar_abilities
aromaticities	17	5	471	4	aromaticities
bioactivities	20	6	330	4	bioactivities
brevities	14	4	642	4	bre___vities
calvities	14	3	894	4	c__a_lvities
caninities	12	4	1049	4	c__aninities
capabilities	18	4	882	4	capabilities
causticities	16	5	400	4	causticities
cavities	13	14	1261	4	c__a__vities
centricities	16	6	640	4	c_entricities
certainties	13	5	376	4	certai_nties
chromaticities	23	6	284	4	chromaticities
collectivities	21	7	416	4	collectivities
connectivities	21	6	447	4	connectivities
creatines	11	28	1443	4	creat__i_nes
creatinine	12	4	507	4	creatini_ne_
creative	13	28	1280	4	creativ___e_
creativeness	17	4	776	4	creativeness
credibilities	18	5	607	4	credibilities
credulities	14	4	413	4	cre_dulities
curabilities	16	4	940	4	curabilities
cutabilities	16	4	914	4	cutabilities
declivities	17	4	572	4	_declivities
dyeabilities	18	4	787	4	dyeabilities
effectivities	24	5	385	4	effectivities
emotivities	16	4	575	4	_emotivities
erosivities	14	5	591	4	er_osivities
fertilities	14	4	882	4	_fertilities
fetidities	14	4	787	4	_fe_tidities
fragilities	15	4	716	4	fr_agilities
friabilities	17	8	917	4	friabilities
gentilities	12	4	913	4	_gentilities
gracilities	14	4	768	4	gr_acilities
gratuities	11	4	531	4	gr_at_uities
gravidities	16	4	413	4	gr_avidities
gravities	13	3	830	4	gr_a__vities
inactivities	17	5	559	4	inactivities
infectivities	21	5	512	4	infectivities
latinities	10	4	1016	4	__latinities
motivities	15	4	769	4	__motivities
objectivities	27	5	431	4	objectivities
organicities	15	5	488	4	organicities
overactivities	22	7	446	4	overactivities
perceptivities	23	6	326	4	perceptivities
perfectivities	24	8	387	4	perfectivities
positivities	17	5	545	4	positivities
prematurities	17	5	300	4	prematurities
primitivities	20	7	356	4	primitivities
privities	14	3	1204	4	pr___ivities
proclivities	19	6	468	4	proclivities
rabidities	13	4	770	4	_r_abidities
rapidities	13	4	748	4	_r_apidities
reactivates	16	4	561	4	_reactivat_es
realities	9	3	1631	4	_rea__lities
receptivities	20	5	390	4	receptivities
refractivities	22	10	397	4	_refractivities
relativizes	23	5	439	4	_relativi_zes
resistivities	16	9	449	4	_resistivities
retentivities	16	5	454	4	retentivities
retinites	9	3	1350	4	_re_tinit_es
retinitides	12	4	474	4	_re_tinitides
retinitis	9	4	802	4	_re_tiniti_s
retinitises	11	4	598	4	_re_tinitises
revivifies	19	4	455	4	_re_vivifies
rusticities	13	4	684	4	_rusticities
sectilities	13	4	869	4	_sectilities
selectivities	18	5	487	4	selectivities
septicities	15	4	731	4	_septicities
treatabilities	16	5	762	4	treatabilities
versatilities	16	5	608	4	versatilities
volatilities	15	4	651	4	volatilities

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	124790	0.390	458182.1
2	DLD Change Limit	124790	89	7.423	16811.3
3	Display Results	89	89	0.046	1934.8
	(SQL Overall)	178691	89	7.859	22737.1