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

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

37 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
affinities	16	4	571	(None)
aminities	11	3	1291	2	a_minities
infinities	13	6	944	2	infinities
abilities	11	7	1414	3	a_bilities
acidities	12	8	1018	3	a_cidities
acridities	13	4	829	3	acridities
activities	15	4	890	3	activities
affabilities	20	4	694	3	affabilities
affiliates	16	4	489	3	affiliates
affines	13	3	948	3	affin___es
affinity	17	4	498	3	affinit__y
agilities	10	8	1097	3	a_gilities
algidities	12	4	595	3	algidities
amenities	11	3	1043	3	a_menities
anilities	9	5	1600	3	a_nilities
aridities	10	9	1163	3	a_ridities
asininities	11	4	519	3	asininities
avidities	13	10	761	3	a_vidities
bifidities	16	4	445	3	bifidities
bovinities	15	4	601	3	bovinities
caninities	12	4	1049	3	caninities
definitives	18	4	421	3	definitives
definitizes	24	4	468	3	definitizes
divinities	14	4	773	3	divinities
equinities	19	4	737	3	equinities
facilities	15	4	982	3	facilities
felinities	13	4	943	3	felinities
feminities	15	4	967	3	feminities
finites	10	3	1592	3	__finit_es
fixities	18	3	821	3	__fixities
infinites	12	5	869	3	infinit_es
infinitives	17	4	468	3	infinitives
latinities	10	4	1016	3	latinities
raffinates	16	4	436	3	raffinat_es
salinities	10	4	1095	3	salinities
trinities	9	3	1334	3	_trinities
vicinities	15	4	746	3	vicinities

Search took 6 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.403	443402.0
2	DLD Change Limit	140603	37	5.190	27091.1
3	Display Results	37	37	0.013	2846.2
	(SQL Overall)	178691	37	5.606	31875.0