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

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

79 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
terminates	12	4	1000	(None)
germinates	13	4	776	1	germinates
terminate	11	4	1120	1	terminate_
terminated	13	4	816	1	terminated
deaminates	13	4	938	2	deaminates
exterminates	21	5	429	2	exterminates
geminates	12	3	1004	2	ge_minates
germinate	12	4	863	2	germinate_
germinated	14	4	656	2	germinated
terminals	11	4	746	2	termina_ls
terminator	12	4	663	2	terminator
terminators	13	4	603	2	terminators
terminuses	12	4	406	2	terminuses
termites	10	3	1369	2	termi__tes
turbinates	12	4	577	2	turbinates
abominates	14	4	651	3	abominates
acuminates	14	4	688	3	acuminates
aluminates	12	4	836	3	aluminates
brominates	14	4	801	3	brominates
criminates	14	4	800	3	criminates
culminates	14	4	705	3	culminates
deaminases	13	4	528	3	deaminases
deaminate	12	4	1017	3	deaminate_
deaminated	14	4	801	3	deaminated
delaminates	14	5	690	3	delaminates
denominates	14	16	720	3	denominates
deracinates	14	4	586	3	deracinates
derivates	13	3	1009	3	der_ivates
determinate	14	4	662	3	determinate_
dominates	12	3	1174	3	_dominates
eliminates	12	4	697	3	eliminates
emanates	10	3	1133	3	_e_manates
emirates	10	12	1485	3	_e_mirates
ermines	9	4	1667	3	_ermin__es
exterminate	20	5	454	3	exterminate_
exterminated	22	5	360	3	exterminated
festinates	13	4	894	3	festinates
fulminates	15	4	588	3	fulminates
geminate	11	4	1181	3	ge_minate_
geminated	13	3	855	3	ge_minated
hermitages	16	4	390	3	hermitages
herniates	12	4	733	3	herni_ates
laminates	11	27	1290	3	_laminates
marginates	13	16	874	3	marginates
marinates	11	25	1638	3	mar_inates
nominates	11	3	1105	3	_nominates
ordinates	10	4	900	3	_ordinates
pepsinates	14	4	637	3	pepsinates
perennates	12	5	676	3	perennates
permeates	13	3	1177	3	perm_eates
personates	12	25	1069	3	personates
recriminates	16	5	488	3	recriminates
renominates	13	13	780	3	renominates
resinates	9	3	1476	3	re_sinates
ruinates	8	3	1188	3	__ruinates
ruminates	11	4	1019	3	_ruminates
seriates	8	26	2067	3	ser_i_ates
teammates	13	4	567	3	team_mates
templates	13	4	827	3	te_mplates
teosintes	9	4	455	3	teosin_tes
tergites	9	3	1054	3	tergi__tes
terminable	14	7	660	3	terminable
terminably	17	5	555	3	terminably
terminal	10	3	973	3	termina__l
terminally	15	6	702	3	terminally
terminating	14	4	735	3	terminating
termination	13	13	1116	3	termination
terminations	14	14	976	3	terminations
terminative	16	5	613	3	terminative
terminus	10	3	739	3	termin__us
termitaries	13	4	569	3	termitaries
termite	9	3	1389	3	termi__te_
ternate	7	4	1548	3	ter__nate_
terrines	8	21	1755	3	terrin__es
thermites	14	3	804	3	thermi__tes
turbinate	11	4	667	3	turbinate_
turbinated	13	4	441	3	turbinated
urinates	8	3	1413	3	_ur_inates
veritates	12	3	1097	3	ver_itates

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	140603	0.423	422437.4
2	DLD Change Limit	140603	79	7.140	19692.3
3	Display Results	79	79	0.046	1717.4
	(SQL Overall)	178691	79	7.609	23484.2