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

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

85 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
futilities	13	4	886	(None)
utilities	9	6	1080	1	_utilities
ductilities	14	4	620	2	ductilities
facilities	15	4	982	2	facilities
fatalities	13	4	944	2	fatalities
fertilities	14	4	882	2	fertilities
fetidities	14	4	787	2	fetidities
futurities	13	4	542	2	futurities
humilities	15	4	770	2	humilities
inutilities	11	4	818	2	inutilities
motilities	12	4	1058	2	motilities
nubilities	12	4	972	2	nubilities
subtilities	13	4	785	2	subtilities
abilities	11	7	1414	3	_abilities
activities	15	4	890	3	activities
agilities	10	8	1097	3	_agilities
anilities	9	5	1600	3	_anilities
auralities	10	4	1022	3	auralities
brutalities	13	4	544	3	brutalities
civilities	15	4	784	3	civilities
cubicities	16	4	682	3	cubicities
cupidities	15	4	597	3	cupidities
cutabilities	16	4	914	3	cutabilities
debilities	13	4	1129	3	debilities
disutilities	13	5	515	3	disutilities
docilities	13	4	900	3	docilities
dualities	10	3	1044	3	du_alities
facticities	18	4	687	3	facticities
fatuities	12	4	691	3	fat_uities
febrilities	16	4	514	3	febrilities
felicities	15	4	974	3	felicities
felinities	13	4	943	3	felinities
feminities	15	4	967	3	feminities
festivities	17	4	658	3	festivities
feudalities	15	4	534	3	feudalities
fidelities	14	4	593	3	fidelities
finalities	13	4	990	3	finalities
fissilities	14	4	564	3	fissilities
fixities	18	3	821	3	f__ixities
fluidities	14	4	522	3	fluidities
fragilities	15	4	716	3	fragilities
frailties	12	4	585	3	frail_ties
frugalities	15	4	416	3	frugalities
fugacities	16	4	383	3	fugacities
furmities	14	4	754	3	fu_rmities
fusibilities	17	4	623	3	fusibilities
futility	14	4	697	3	futilit__y
gentilities	12	4	913	3	gentilities
hostilities	14	12	765	3	hostilities
humidities	16	4	589	3	humidities
labilities	12	7	1223	3	labilities
latinities	10	4	1016	3	latinities
lucidities	13	4	625	3	lucidities
mobilities	14	4	983	3	mobilities
motivities	15	4	769	3	motivities
mucidities	15	4	623	3	mucidities
mutabilities	16	4	955	3	mutabilities
mutilates	11	3	1095	3	mutilat_es
mutualities	13	9	583	3	mutualities
natalities	10	4	1066	3	natalities
nativities	13	4	843	3	nativities
nihilities	13	4	866	3	nihilities
nobilities	12	4	1064	3	nobilities
nonutilities	12	5	668	3	nonutilities
nullities	9	4	935	3	nu_llities
nuptialities	14	5	478	3	nuptialities
outcities	11	4	951	3	out_cities
outpities	11	4	862	3	out_pities
puerilities	13	4	753	3	puerilities
putridities	14	4	491	3	putridities
qualities	18	3	1122	3	qu_alities
ruralities	10	4	857	3	ruralities
rusticities	13	4	684	3	rusticities
sectilities	13	4	869	3	sectilities
senilities	10	3	1299	3	senilities
suabilities	13	6	1081	3	suabilities
subtilties	12	4	611	3	subtil_ties
tactilities	13	4	767	3	tactilities
totalities	10	12	1078	3	totalities
tumidities	13	4	589	3	tumidities
utilises	8	4	897	3	_utili_ses
utilizes	17	5	812	3	_utili_zes
vagilities	14	4	795	3	vagilities
virilities	13	7	912	3	virilities
vitalities	13	4	909	3	vitalities

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.423	422437.4
2	DLD Change Limit	140603	85	6.076	23140.7
3	Display Results	85	85	0.046	1847.8
	(SQL Overall)	178691	85	6.545	27301.9