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

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

53 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
distantnesses	14	5	383	(None)
distantness	12	5	433	2	distantne_s_s
distinctnesses	17	5	256	2	distinctnesses
instantnesses	13	5	406	2	instantnesses
dismalnesses	15	5	398	3	disma_lnesses
intactnesses	14	4	457	3	_intactnesses
intentnesses	12	7	712	3	_intentnesses
militantnesses	16	6	187	3	militantnesses
piquantnesses	24	5	203	3	piquantnesses
scantnesses	13	7	653	3	__scantnesses
abstractnesses	18	6	229	4	abstractnesses
daftnesses	14	3	638	4	d___aftnesses
danknesses	15	3	625	4	d___anknesses
directnesses	15	9	528	4	di_rectnesses
dirtinesses	12	3	988	4	dirt__inesses
discreetnesses	17	6	243	4	discreetnesses
discretenesses	17	5	338	4	discretenesses
disparatenesses	18	12	288	4	disparatenesses
distinctness	15	5	303	4	distinctne_s_s
distresses	11	4	885	4	dis___tresses
ditsinesses	12	10	876	4	di_t_sinesses
ditzinesses	21	12	621	4	di_t_zinesses
dustinesses	12	11	1035	4	dust__inesses
fittingnesses	17	7	340	4	fittingnesses
giantesses	11	4	351	4	gi__ant_esses
inanenesses	11	4	952	4	_i_nanenesses
inaptnesses	13	8	563	4	_i_naptnesses
insanenesses	12	4	687	4	_insanenesses
instantness	11	5	408	4	instantne_s_s
lastingnesses	14	4	413	4	lastingnesses
liltingnesses	14	5	357	4	liltingnesses
mistinesses	13	13	1062	4	mist__inesses
pliantnesses	14	4	445	4	_pliantnesses
saltnesses	10	3	1016	4	__s_altnesses
sanenesses	10	4	1269	4	__s_anenesses
scantinesses	14	3	731	4	__scantinesses
silentnesses	12	7	544	4	si_lentnesses
smartnesses	13	3	714	4	__smartnesses
staginesses	12	3	846	4	__staginesses
staidnesses	12	3	719	4	__staidnesses
stalenesses	11	3	1110	4	__stalenesses
starknesses	15	4	588	4	__starknesses
stoninesses	11	3	825	4	__stoninesses
stoutnesses	11	4	697	4	__stoutnesses
straitnesses	12	4	621	4	__straitnesses
swartnesses	14	3	671	4	__swartnesses
tartnesses	10	11	1071	4	___tartnesses
tautnesses	10	11	828	4	___tautnesses
titanesses	10	3	725	4	ti_ta__nesses
vacantnesses	17	4	297	4	_vacantnesses
valiantnesses	16	5	272	4	valiantnesses
vitalnesses	14	5	627	4	vi_ta_lnesses
wistfulnesses	19	5	554	4	wistfulnesses

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	95024	0.360	496363.9
2	DLD Change Limit	95024	53	6.046	15716.8
3	Display Results	53	53	0.030	1766.7
	(SQL Overall)	178691	53	6.436	27764.3