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

Here are the results of your fuzzy-string dictionary search for “exempt” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

116 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
exempt	17	3	745	(None)
exempts	18	4	402	1	exempts
benempt	13	4	626	2	benempt
coempt	12	3	1103	2	coempt
except	17	9	765	2	except
excerpt	18	4	594	2	excerpt
exempla	18	4	297	2	exempla
exempted	20	4	414	2	exempted
exert	12	46	2414	2	exe_rt
exeunt	13	3	870	2	exeunt
kempt	13	43	1846	2	_kempt
tempt	9	51	2484	2	_tempt
adept	8	12	1964	3	ade_pt
attempt	11	4	537	3	attempt
axeman	15	3	810	3	axeman
axemen	15	4	749	3	axemen
beleapt	11	3	1025	3	beleapt
bewept	13	4	1032	3	bewe_pt
clept	9	57	2577	3	cle_pt
coempts	13	3	568	3	coempts
compt	11	63	2822	3	_compt
crept	9	51	2589	3	cre_pt
demit	8	48	3230	3	_demit
edema	8	6	1055	3	edem_a
edemas	9	3	1050	3	edemas
edemata	10	4	600	3	edemata
egest	6	52	2234	3	ege_st
eject	14	50	1604	3	eje_ct
elect	7	43	2703	3	ele_ct
elegit	7	12	1289	3	elegit
element	9	3	1780	3	element
elemi	7	3	1250	3	elem_i
elemis	8	3	1238	3	elemis
emit	6	54	3842	3	__emit
emmet	9	42	2138	3	e_mmet
empty	12	4	776	3	__empty
enema	7	6	1274	3	enem_a
enemas	8	8	1200	3	enemas
enemata	9	4	801	3	enemata
enemy	10	5	999	3	enem_y
enrapt	8	3	1301	3	enrapt
erect	7	41	2933	3	ere_ct
eremite	9	3	1283	3	eremite
erupt	7	42	2006	3	e_rupt
event	8	59	2444	3	eve_nt
evert	8	49	2951	3	eve_rt
exact	14	35	1693	3	ex_act
exalt	12	30	1853	3	ex_alt
exam	13	25	1462	3	exam__
examen	15	3	828	3	examen
example	18	4	428	3	example
exams	14	19	908	3	exam_s
excepts	18	8	520	3	excepts
excerpts	19	4	374	3	excerpts
exec	13	53	1394	3	exe__c
execs	14	53	972	3	exe_cs
execute	16	3	678	3	execute
exed	12	54	2059	3	exe__d
exedra	14	3	450	3	exedra
exegete	15	4	577	3	exegete
exemplar	19	4	233	3	exemplar
exemplum	21	5	166	3	exemplum
exempting	21	4	422	3	exempt~~ing~~
exemption	20	6	494	3	exempt~~ion~~
exemptive	23	4	383	3	exempt~~ive~~
exequy	25	4	252	3	exequy
exerts	13	37	1229	3	exerts
exes	11	65	3081	3	exe__s
exhort	16	4	1080	3	exhort
exist	12	46	1894	3	ex_ist
exit	11	44	2867	3	ex__it
expat	14	3	1381	3	ex_pat
expect	17	5	890	3	expect
expert	15	5	1535	3	expert
expo	13	4	918	3	ex__po
export	15	4	1218	3	export
exsect	15	5	850	3	exsect
exsert	13	4	1436	3	exsert
extant	13	27	1475	3	extant
extent	13	27	1491	3	extent
extort	13	5	1397	3	extort
exult	12	28	1412	3	ex_ult
eyelet	9	5	1453	3	eyelet
eyespot	12	6	541	3	eyespot
gemot	8	40	2423	3	_gemot
hemp	11	57	2562	3	_hemp_
hemps	12	69	1733	3	_hemps
hempy	15	49	1276	3	_hempy
inept	7	36	2215	3	ine_pt
kemp	12	64	1876	3	_kemp_
kemps	13	50	1252	3	_kemps
kept	10	62	3294	3	_ke_pt
leapt	7	50	2747	3	_leapt
lept	6	64	4088	3	_le_pt
lexeme	15	3	649	3	lexem_e
lexemes	16	3	567	3	lexemes
lexemic	18	4	428	3	lexemic
nonexempt	20	5	248	3	~~non~~exempt
preempt	13	3	772	3	preempt
preexempt	22	5	190	3	~~pre~~exempt
prompt	12	3	1301	3	prompt
receipt	11	5	925	3	receipt
recept	10	33	1907	3	rece_pt
reemit	8	7	1722	3	reemit
remet	7	48	4372	3	_remet
remit	7	57	3722	3	_remit
sept	6	58	4436	3	_se_pt
slept	7	57	2810	3	sle_pt
swept	10	57	2060	3	swe_pt
temp	8	53	2333	3	_temp_
tempi	9	49	1220	3	_tempi
tempo	9	52	1497	3	_tempo
temps	9	54	1713	3	_temps
tempts	10	43	945	3	_tempts
unkempt	15	4	476	3	unkempt
wept	9	56	3505	3	_we_pt

Search took 6 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	112716	0.373	479064.3
2	DLD Change Limit	112716	116	4.970	22679.3
3	Display Results	116	116	0.030	3866.7
	(SQL Overall)	178691	116	5.373	33257.2