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

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

87 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
banalities	12	4	981	(None)
analities	9	7	1587	1	_analities
anilities	9	5	1600	2	_anilities
banalizes	20	12	1009	2	banali_zes
carnalities	13	4	877	2	carnalities
fatalities	13	4	944	2	fatalities
finalities	13	4	990	2	finalities
nasalities	10	4	856	2	nasalities
natalities	10	4	1066	2	natalities
penalities	12	13	1347	2	penalities
tonalities	10	17	1173	2	tonalities
venalities	13	15	1072	2	venalities
abilities	11	7	1414	3	_abilities
agilities	10	8	1097	3	_agilities
analcites	11	4	748	3	_analcit_es
analogies	10	19	1064	3	_analogies
analytes	11	16	920	3	_analyt_es
analytics	14	4	551	3	_analytics
animalities	13	4	899	3	_animalities
annuities	9	4	746	3	_annuities
atonalities	11	4	840	3	atonalities
auralities	10	4	1022	3	auralities
axialities	17	4	773	3	axialities
bakelites	15	4	599	3	bakelit_es
banality	13	3	876	3	banalit__y
banalize	19	10	1093	3	banali_ze_
banalized	21	11	870	3	banali_zed
banalizing	22	4	814	3	banalizing
banditries	13	4	534	3	ban_ditries
bankabilities	21	4	591	3	bankabilities
banties	9	43	2476	3	ban___ties
barbarities	15	4	499	3	barbarities
basaltes	10	36	768	3	basal_t_es
basicities	14	4	686	3	basicities
brutalities	13	4	544	3	brutalities
calamities	14	4	847	3	calamities
canalises	11	5	1549	3	canali_ses
canalizes	20	11	1378	3	canali_zes
caninities	12	4	1049	3	caninities
canities	10	15	1926	3	can__ities
capacities	16	4	769	3	capacities
causalities	13	4	622	3	causalities
dentalities	12	4	954	3	dentalities
dualities	10	3	1044	3	_dualities
equalities	19	4	901	3	equalities
facilities	15	4	982	3	facilities
fayalites	15	4	606	3	fayalit_es
genialities	12	14	864	3	genialities
idealities	11	4	878	3	idealities
inanities	9	3	1244	3	_inanities
labialities	13	4	703	3	labialities
labilities	12	7	1223	3	labilities
lanosities	10	4	791	3	lanosities
legalities	11	4	891	3	legalities
linealities	11	4	822	3	linealities
localities	12	5	973	3	localities
mammalities	14	4	485	3	mammalities
mentalities	13	4	1002	3	mentalities
minacities	14	4	799	3	minacities
modalities	13	13	881	3	modalities
molalities	12	11	1028	3	molalities
moralities	12	11	1192	3	moralities
nodalities	11	13	858	3	nodalities
oralities	9	12	1412	3	_oralities
ovalities	12	11	980	3	_ovalities
penalties	11	13	951	3	penal_ties
planarities	13	4	532	3	planarities
qualities	18	3	1122	3	_qualities
rapacities	14	4	654	3	rapacities
rascalities	13	4	722	3	rascalities
realities	9	3	1631	3	_realities
regalities	11	4	1059	3	regalities
ruralities	10	4	857	3	ruralities
sagacities	13	4	562	3	sagacities
salacities	12	4	823	3	salacities
sanctities	12	4	755	3	sanctities
sanities	8	12	1977	3	san__ities
senilities	10	3	1299	3	senilities
sodalities	11	13	870	3	sodalities
tantalites	10	9	928	3	tantalit_es
tenacities	12	4	858	3	tenacities
totalities	10	12	1078	3	totalities
vagilities	14	4	795	3	vagilities
vanities	11	14	1449	3	van__ities
venialities	14	16	893	3	venialities
vitalities	13	4	909	3	vitalities
vocalities	15	4	939	3	vocalities

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	87	5.716	24598.1
3	Display Results	87	87	0.046	1891.3
	(SQL Overall)	178691	87	6.168	28970.7