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

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

63 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
temperate	13	4	851	(None)
desperate	12	4	1084	2	desperate
emeerate	10	4	1010	2	_emeerate
intemperate	15	5	577	2	intemperate
reoperate	11	4	1018	2	reoperate
tempera	11	32	904	2	tempera__
temperable	16	4	581	2	temperable
temperance	16	4	480	2	temperance
temperas	12	27	823	2	tempera_s
temperately	18	5	320	2	temperately
temperature	15	5	254	2	temperature
template	12	3	843	2	temp_late
ameerate	10	3	963	3	_ameerate
amperage	13	4	774	3	_amperage
asperate	10	3	1237	3	_asperate
cooperate	13	7	1014	3	cooperate
deaerate	9	3	1417	3	de_aerate
depurate	11	3	998	3	de_purate
deuterate	10	4	951	3	deuterate
distemperate	17	6	249	3	~~dis~~temperate
emeerates	11	4	937	3	_emeerates
emigrate	11	4	960	3	_emigrate
emirate	9	10	1583	3	_em_irate
federate	12	3	1088	3	fe_derate
generate	9	3	1290	3	ge_nerate
impetrate	13	4	572	3	_impetrate
numerate	10	16	1039	3	num_erate
operate	9	6	1573	3	__operate
perpetrate	14	7	665	3	perpetrate
recuperate	14	4	593	3	recuperate
reiterate	9	4	1293	3	reiterate
remigrate	12	4	922	3	remigrate
remunerate	12	6	625	3	remunerate
reoperated	13	4	815	3	reoperated
reoperates	12	4	966	3	reoperates
separate	10	3	1078	3	se_parate
subtemperate	18	6	129	3	~~sub~~temperate
temerity	13	4	690	3	tem_erity
temper	10	39	1409	3	temper___
temperament	17	5	486	3	temperament
temperances	17	5	473	3	temperances
temperatures	16	5	228	3	temperatures
tempered	13	24	822	3	temper_ed
temperer	12	22	772	3	temper_er
temperers	13	24	702	3	temperers
tempering	14	3	873	3	tempering
tempers	11	35	1301	3	temper__s
tempest	11	3	922	3	tempe_st_
tempested	14	4	403	3	tempe_sted
tempests	12	3	444	3	tempe_sts
templates	13	4	827	3	temp_lates
temporal	12	4	633	3	tempora_l
temporals	13	4	529	3	temporals
temporary	16	5	320	3	temporary
temporise	13	4	740	3	temporise
temporize	22	4	687	3	temporize
tempura	11	29	525	3	tempura__
tempuras	12	29	506	3	tempura_s
tephrite	13	4	659	3	te_phrite
tesselate	9	4	418	3	tesselate
tesserae	8	4	479	3	tessera_e
tolerate	8	3	1232	3	t_olerate
venerate	11	3	1290	3	ve_nerate

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	148641	0.420	425454.8
2	DLD Change Limit	148641	63	6.610	22487.3
3	Display Results	63	63	0.033	1909.1
	(SQL Overall)	178691	63	7.063	25299.6