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

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

57 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
investigates	16	10	421	(None)
investigate	15	10	430	1	investigate_
investigated	17	11	391	1	investigated
instigates	11	4	842	2	in__stigates
investigator	16	5	276	2	investigator
investigators	17	5	246	2	investigators
reinvestigates	18	6	186	2	reinvestigates
instigate	10	4	861	3	in__stigate_
instigated	12	4	769	3	in__stigated
intestates	10	15	943	3	intest__ates
investigating	18	5	334	3	investigating
investigation	17	5	408	3	investigation
investigations	18	5	372	3	investigations
investigative	20	6	263	3	investigative
investigatory	20	6	223	3	investigatory
investitures	15	7	259	3	investitures
reinvestigate	17	6	205	3	reinvestigate_
reinvestigated	19	6	173	3	reinvestigated
aestivates	13	10	736	4	__aestivates
castigates	13	4	755	4	__castigates
coinvestigator	20	9	146	4	coinvestigator
coinvestigators	21	10	138	4	coinvestigators
domesticates	17	5	354	4	domesticates
estimates	11	9	1136	4	___estimates
estivates	12	10	975	4	___estivates
festinates	13	4	894	4	__festinates
fustigates	14	4	514	4	__fustigates
inactivates	16	4	504	4	in_activates
inebriates	12	4	606	4	in_ebri_ates
ingratiates	12	5	441	4	ingrati_ates
initiates	9	4	1118	4	in__iti_ates
inseminates	13	4	589	4	inse_minates
instates	8	16	1583	4	in__st__ates
instigator	11	4	641	4	in__stigator
instigators	12	4	592	4	in__stigators
institutes	10	4	605	4	in__stitutes
interrogates	13	8	710	4	interrogates
interstates	11	7	1020	4	interst__ates
intestate	9	15	987	4	intest__ate_
intestines	10	4	1025	4	intesti__nes
intimates	11	10	1331	4	in___timates
invaginates	15	4	484	4	inv_aginates
invalidates	15	5	406	4	inv_alidates
invectives	18	8	590	4	invecti__ves
inveigles	13	4	302	4	inve__ig_les
invertases	13	4	578	4	invert__ases
invertebrates	18	6	203	4	invertebrates
investiture	14	7	254	4	investiture_
investments	16	6	590	4	investment_s
inveterate	13	4	525	4	inve_terate_
invigilates	15	5	450	4	inv_igilates
misestimates	16	6	356	4	misestimates
reestimates	13	4	635	4	_reestimates
unventilated	16	5	351	4	unventilated
ventilates	13	4	760	4	__ventilates
vesicates	14	11	903	4	__ves_icates
vestiges	12	3	824	4	__vestig__es

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	124790	0.736	242786.7
2	DLD Change Limit	124790	57	6.983	17870.5
3	Display Results	57	57	0.030	1900.0
	(SQL Overall)	178691	57	7.749	23059.9