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

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

73 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
necessities	13	5	457	(None)
necessaries	13	5	309	2	necessaries
necessitates	14	5	244	2	necessitates
necessitous	13	5	156	2	necessitous
necessitate	13	5	253	3	necessitate
necessitated	15	5	225	3	necessitated
necessity	14	5	341	3	necessit__y
nervosities	14	5	467	3	nervosities
nonnecessities	16	7	126	3	~~non~~necessities
recessives	15	4	567	3	recessi_ves
accessaries	15	17	355	4	accessaries
accessories	15	17	399	4	accessories
acerbities	14	4	497	4	_acerbities
adversities	15	6	435	4	adversities
cecities	12	3	1204	4	__ce_cities
celebrities	15	13	444	4	celebrities
celerities	12	8	977	4	cele_rities
celestites	12	12	596	4	celestit_es
cerussites	12	4	318	4	cerussit_es
decertifies	17	4	457	4	decertifies
declassifies	18	15	262	4	declassifies
declivities	17	4	572	4	declivities
decussates	13	4	324	4	decussat_es
densities	10	3	1079	4	__densities
desensitizes	22	5	404	4	desensitizes
diversities	15	5	587	4	diversities
ecesises	10	3	702	4	_ece_si_ses
eternities	10	4	806	4	_eternities
extensities	18	8	576	4	extensities
fecundities	17	5	333	4	fecundities
generosities	13	5	381	4	generosities
heredities	14	4	722	4	here_dities
hessites	11	3	861	4	__hessit_es
hideosities	15	5	420	4	hideosities
immensities	15	5	479	4	immensities
intensities	11	10	891	4	intensities
jocosities	19	5	516	4	joc_osities
legerities	11	9	688	4	lege_rities
mucosities	14	4	594	4	muc_osities
nebulosities	14	5	250	4	nebulosities
necessarily	16	6	176	4	necessarily
necessitarian	15	7	176	4	necessitarian
necessitarians	16	7	163	4	necessitarians
necessitating	16	6	237	4	necessitating
necessitation	15	12	309	4	necessitation
necessitations	16	12	279	4	necessitations
necessitously	18	6	159	4	necessitously
neckties	14	4	590	4	nec___kties
niceties	10	3	1086	4	nice___ties
nodosities	11	4	585	4	n_odosities
nonentities	11	5	826	4	nonentities
obesities	11	4	584	4	_obe_sities
perversities	17	5	445	4	perversities
preciosities	16	5	537	4	preciosities
recertifies	16	4	470	4	recertifies
recesses	10	3	1232	4	recess___es
recessions	12	4	893	4	recessi_ons
recessive	14	4	726	4	recessi_ve_
reclassifies	17	8	285	4	reclassifies
resensitizes	21	5	440	4	resensitizes
retestifies	14	4	453	4	retestifies
secessions	12	4	646	4	secessi_ons
sectilities	13	4	869	4	sectilities
securities	12	4	855	4	sec_urities
serenities	10	4	1106	4	sere_nities
serosities	10	4	1082	4	se_rosities
severities	13	4	851	4	seve_rities
speciosities	16	5	376	4	speciosities
temerities	12	6	848	4	teme_rities
tensities	9	3	1133	4	__tensities
universities	15	5	345	4	universities
venosities	13	4	747	4	ve_nosities
verbosities	16	4	489	4	verbosities

Search took 9 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	148819	0.406	440125.6
2	DLD Change Limit	148819	73	8.326	17874.0
3	Display Results	73	73	0.046	1587.0
	(SQL Overall)	178691	73	8.778	20356.7