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

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

64 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
vanitory	14	4	573	(None)
janitor	14	3	648	2	janitor_
janitors	15	3	685	2	janitors
monitory	13	4	785	2	monitory
punitory	13	4	560	2	punitory
sanitary	11	4	675	2	sanitary
vanity	12	3	1194	2	vanit__y
vomitory	16	4	441	2	vomitory
additory	13	4	426	3	additory
amatory	12	3	864	3	_amatory
anatomy	12	4	623	3	_anatomy
antistory	12	4	827	3	_antistory
auditory	12	4	570	3	auditory
banditry	14	4	412	3	bandit_ry
cantor	8	56	2152	3	can_tor_
cantors	9	46	2075	3	can_tors
carnivory	17	4	243	3	carnivory
cavitary	16	6	496	3	cavitary
damnatory	15	4	414	3	damnatory
enactory	13	4	615	3	enactory
factory	15	10	835	3	fa_ctory
fumitory	16	4	389	3	fumitory
gantry	10	38	1011	3	gan_t_ry
genitor	8	3	727	3	genitor_
genitors	9	3	742	3	genitors
ignitor	8	12	526	3	ignitor_
ignitors	9	13	551	3	ignitors
janiform	20	4	472	3	janiform
janisary	18	4	362	3	janisary
janizary	27	4	248	3	janizary
laniary	10	6	801	3	lani_ary
lavatory	14	4	570	3	lavatory
mandatory	15	4	525	3	mandatory
manito	8	5	1869	3	manito__
manitos	9	3	1405	3	manito_s
manitou	9	3	846	3	manito_u
manitous	10	3	917	3	manitous
minatory	13	3	855	3	minatory
monitor	9	3	1072	3	monitor_
monitors	10	3	1082	3	monitors
natatory	11	4	661	3	natatory
nitery	9	44	1217	3	__nitery
nonstory	11	4	810	3	nonstory
pantry	11	50	1410	3	pan_t_ry
sanitoria	9	4	667	3	sanitoria
sanity	9	3	1620	3	sanit__y
tanistry	11	4	454	3	tanistry
transitory	13	5	569	3	transitory
unitary	10	3	861	3	_unitary
vagotomy	17	4	216	3	vagotomy
vainglory	16	4	111	3	vainglory
vanitied	12	13	821	3	vanitied
vanities	11	14	1449	3	vanities
vanitories	13	4	691	3	vanitories
vapory	14	39	876	3	va__pory
variform	16	4	500	3	variform
varistor	11	4	639	3	varistor_
varistors	12	4	653	3	varistors
vasiform	16	4	423	3	vasiform
vasotomy	16	4	267	3	vasotomy
victory	15	32	698	3	v_ictory
visitor	10	4	620	3	visitor_
visitors	11	4	643	3	visitors
yakitori	15	4	242	3	yakitori

Search took 8 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.420	425454.8
2	DLD Change Limit	146162	64	7.330	19940.2
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	7.780	22968.0