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

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

86 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
acridity	14	4	691	(None)
acidity	13	3	859	1	ac_idity
aridity	11	5	1011	1	a_ridity
acidify	16	4	524	2	ac_idify
acridine	11	3	955	2	acridine
acridly	13	39	653	2	acrid_ly
activity	16	4	759	2	activity
algidity	13	4	528	2	algidity
avidity	14	3	648	2	a_vidity
crudity	13	3	604	2	_crudity
viridity	15	4	591	2	viridity
ability	12	3	1144	3	a_bility
accidia	12	4	700	3	accidi_a
accidias	13	4	633	3	accidias
accidie	12	4	773	3	accidi_e
accidies	13	3	804	3	accidies
acclivity	19	4	326	3	acclivity
accredit	13	4	484	3	accredit_
accredits	14	4	343	3	accredits
acerbity	15	4	427	3	acerbity
acidic	11	36	1213	3	ac_idi_c
acidly	12	52	1179	3	ac_id_ly
acidy	11	72	1489	3	ac_id__y
acrid	8	69	2010	3	acrid___
acrider	10	3	862	3	acrid_er
acridest	11	3	814	3	acridest
acridines	12	4	773	3	acridines
acridities	13	4	829	3	acridities
acrimony	15	4	356	3	acrimony
acrolith	13	4	845	3	acrolith
acuity	11	3	937	3	ac__uity
affinity	17	4	499	3	affinity
agility	11	4	865	3	a_gility
aminity	12	3	1051	3	a_minity
anility	10	3	1272	3	a_nility
anticity	13	3	1360	3	anticity
apriority	14	4	474	3	apriority
aridly	10	55	1370	3	a_rid_ly
assiduity	13	5	223	3	assiduity
atrocity	13	4	721	3	atrocity
aurality	11	3	922	3	aurality
bifidity	17	4	371	3	bifidity
caninity	13	3	806	3	caninity
cariosity	14	4	621	3	cariosity
credit	9	3	1519	3	_credit_
credits	10	3	997	3	_credits
criminy	14	26	845	3	_criminy
crinite	9	5	1363	3	_crinite
cupidity	16	4	488	3	cupidity
facility	16	3	825	3	fac_ility
facticity	19	4	596	3	facticity
fervidity	19	4	303	3	fervidity
fetidity	15	4	586	3	fetidity
flaccidity	21	6	167	3	flaccidity
floridity	16	4	424	3	floridity
fluidity	15	4	492	3	fluidity
gelidity	13	4	557	3	gelidity
heredity	15	4	649	3	heredity
humidity	17	4	523	3	humidity
hybridity	21	7	280	3	hybridity
lividity	15	4	509	3	lividity
lucidity	14	4	550	3	lucidity
morbidity	17	4	414	3	morbidity
mucidity	16	4	553	3	mucidity
placidity	17	4	424	3	plac_idity
privity	15	26	832	3	_privity
putridity	15	4	419	3	putridity
rabidity	14	4	658	3	rabidity
rancidity	15	4	431	3	rancidity
rapidity	14	4	627	3	rapidity
rigidity	13	4	526	3	rigidity
sacristy	13	4	510	3	sacri_sty
sapidity	14	4	643	3	sapidity
solidity	12	4	811	3	solidity
tactility	14	4	683	3	tactility
tepidity	14	4	560	3	tepidity
timidity	14	4	542	3	timidity
torpidity	15	4	383	3	torpidity
torridity	13	4	424	3	torridity
trinity	10	3	1084	3	_trinity
tumidity	14	4	496	3	tumidity
turbidity	15	14	429	3	turbidity
turgidity	14	15	331	3	turgidity
validity	15	4	599	3	validity
vapidity	17	4	519	3	vapidity
virility	14	4	774	3	virility

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	146162	0.406	440125.6
2	DLD Change Limit	146162	86	8.080	18089.4
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	8.516	20983.0