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

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

80 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
denigratory	16	5	351	(None)
denigrator	12	4	522	1	denigrator_
denigrators	13	4	452	1	denigrators
designatory	16	5	338	2	designatory
declaratory	17	5	285	3	declaratory
dedicatory	17	4	567	3	dedi_catory
denigrate	11	6	869	3	denigrat__e
denigrated	13	6	697	3	denigrat_ed
denigrates	12	9	811	3	denigrat_es
denigrating	14	14	692	3	denigrating
denigration	13	4	846	3	denigration
denigrations	14	4	735	3	denigrations
denigrative	16	5	548	3	denigrative
depilatory	16	4	574	3	depi_latory
derogatory	15	4	511	3	derog_atory
designator	12	4	471	3	designator_
designators	13	4	430	3	designators
deviatory	16	6	644	3	devi__atory
migratory	15	4	534	3	__migratory
nonmigratory	18	6	225	3	nonmigratory
amelioratory	17	11	206	4	amelioratory
celebratory	18	5	330	4	celebratory
cosignatory	17	5	294	4	cosignatory
deaerator	10	12	811	4	de_aerator_
deaerators	11	10	771	4	de_aerators
decimator	14	4	773	4	deci_mator_
decimators	15	4	750	4	deci_mators
declamatory	19	5	256	4	declamatory
decorator	12	4	857	4	de_corator_
decorators	13	4	787	4	de_corators
decretory	15	4	468	4	de__cretory
dedicator	13	4	825	4	dedi_cator_
dedicators	14	4	774	4	dedi_cators
defamatory	19	4	348	4	de_famatory
dehydrator	18	5	320	4	dehydrator_
dehydrators	19	5	285	4	dehydrators
delegator	11	4	624	4	deleg_ator_
delegators	12	4	563	4	deleg_ators
delineator	11	7	417	4	delineator_
delineators	12	5	396	4	delineators
denitrate	10	8	1053	4	denitrat__e
denitrated	12	9	803	4	denitrat_ed
denitrates	11	6	951	4	denitrat_es
denitrating	13	12	833	4	denitrating
denunciatory	18	5	231	4	denunciatory
depilator	12	4	765	4	depi_lator_
depilators	13	4	733	4	depi_lators
deprecatory	19	5	436	4	deprecatory
depredatory	18	5	316	4	depredatory
depurator	12	4	702	4	de_purator_
depurators	13	4	648	4	de_purators
desecrator	13	4	600	4	desecrator_
desecrators	14	4	523	4	desecrators
desiccator	15	4	399	4	desiccator_
desiccators	16	4	380	4	desiccators
deviator	12	4	831	4	devi__ator_
deviators	13	5	853	4	devi__ators
dilatory	12	27	927	4	d__i_latory
divinatory	17	4	394	4	divi_natory
expiratory	22	4	473	4	_expiratory
generator	10	6	759	4	gen_erator_
generators	11	4	753	4	gen_erators
initiatory	13	12	581	4	_initiatory
libratory	14	25	580	4	__libratory
mediatory	15	4	643	4	medi__atory
meliorator	12	10	522	4	meliorator_
meliorators	13	11	500	4	meliorators
migrator	11	4	787	4	__migrator_
migrators	12	4	754	4	__migrators
mitigatory	16	4	399	4	mitig_atory
nitrator	8	4	955	4	__nitrator_
nitrators	9	4	921	4	__nitrators
nugatory	12	4	527	4	__nug_atory
obligatory	16	16	417	4	oblig_atory
respiratory	16	10	413	4	respiratory
signatory	13	4	462	4	__signatory
venerator	12	4	726	4	ven_erator_
venerators	13	4	706	4	ven_erators
ventilatory	17	11	412	4	ventilatory
vibratory	17	23	556	4	__vibratory

Search took 10 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.420	425454.8
2	DLD Change Limit	148819	80	9.206	16165.4
3	Display Results	80	80	0.046	1739.1
	(SQL Overall)	178691	80	9.672	18475.1