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

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

179 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
exsect	15	5	850	(None)
expect	17	5	890	1	expect
exsects	16	5	557	1	exsects
exsert	13	4	1436	1	exsert
bisect	10	3	1287	2	bisect
effect	14	3	744	2	effect
eject	14	50	1604	2	e_ject
elect	7	43	2703	2	e_lect
erect	7	41	2933	2	e_rect
exact	14	35	1693	2	ex_act
except	17	9	765	2	except
exec	13	53	1394	2	ex_ec_
execs	14	53	972	2	ex_ecs
exert	12	46	2414	2	ex_ert
expects	18	6	688	2	expects
expert	15	5	1535	2	expert
exsecant	17	9	475	2	exsecant
exsected	18	3	567	2	exsected
exserts	14	6	701	2	exserts
extent	13	27	1491	2	extent
insect	8	39	1658	2	insect
resect	8	44	2470	2	resect
sect	6	74	4362	2	__sect
abject	17	13	770	3	abject
absent	8	40	1699	3	absent
advect	12	30	912	3	advect
affect	14	4	890	3	affect
aspect	10	6	1282	3	aspect
assent	6	51	1995	3	assent
assert	6	49	2258	3	assert
asset	5	59	3226	3	asse_t
axseed	14	5	699	3	axseed
basest	8	47	2049	3	basest
beset	7	67	3913	3	bese_t
bisects	11	3	713	3	bisects
cosec	9	63	2018	3	cosec_
cosecs	10	50	1521	3	cosecs
coset	7	57	4884	3	cose_t
cusec	9	46	1490	3	cusec_
cusecs	10	50	915	3	cusecs
defect	12	48	1617	3	defect
deflect	13	39	997	3	deflect
deject	16	45	1284	3	deject
densest	8	31	1247	3	densest
desert	7	27	2549	3	desert
dessert	8	29	1645	3	dessert
detect	9	42	1740	3	detect
direct	9	38	1733	3	direct
disject	17	26	867	3	disject
dissect	10	36	1413	3	dissect
ease	4	50	4233	3	ease__
eased	6	54	3040	3	ease_d
easel	5	45	2111	3	ease_l
easels	6	59	1455	3	easels
eases	5	60	4161	3	ease_s
easiest	7	23	1877	3	easiest
east	4	66	5910	3	eas__t
ebbet	9	35	1729	3	ebbe_t
edict	8	47	2228	3	e_dict
educt	8	50	1710	3	e_duct
effects	15	3	528	3	effects
egest	6	52	2234	3	e_gest
egret	6	33	2731	3	egre_t
ejecta	15	33	739	3	e_jecta
ejects	15	40	995	3	e_jects
eldest	7	29	1268	3	eldest
elects	8	33	1500	3	e_lects
else	4	59	2308	3	else__
eluent	6	3	1548	3	eluent
emmet	9	42	2138	3	emme_t
enact	7	35	2536	3	e_nact
enserf	9	3	1076	3	enserf
epact	9	49	2153	3	e_pact
erects	8	41	1618	3	e_rects
erses	5	58	2680	3	erse_s
erst	4	74	3643	3	ers__t
eruct	7	40	2235	3	e_ruct
escot	7	53	2008	3	e_scot
eses	4	53	3610	3	e_se_s
essence	9	4	767	3	essence
esses	5	64	2297	3	esse_s
event	8	59	2444	3	e_vent
evert	8	49	2951	3	e_vert
evict	10	44	1714	3	e_vict
exacta	15	33	739	3	ex_acta
exacts	15	35	961	3	ex_acts
exalt	12	30	1853	3	ex_alt
exarch	18	19	617	3	exarch
exceed	16	3	617	3	exceed
excel	14	3	774	3	exce_l
excels	15	3	666	3	excels
excepts	18	8	520	3	excepts
excerpt	18	4	594	3	excerpt
excess	15	4	605	3	excess
execute	16	3	678	3	ex_ecute
exed	12	54	2059	3	ex_e_d
exempt	17	3	745	3	exempt
exerts	13	37	1229	3	ex_erts
exes	11	65	3081	3	ex_e_s
exeunt	13	3	870	3	exeunt
exhort	16	4	1080	3	exhort
exigent	15	3	951	3	exigent
exist	12	46	1894	3	ex_ist
existent	15	4	826	3	existent
exit	11	44	2867	3	ex__it
expat	14	3	1381	3	ex_pat
expected	20	3	674	3	expected
expecter	19	3	651	3	expecter
expel	14	4	823	3	expe_l
expels	15	4	717	3	expels
expend	16	24	750	3	expend
experts	16	5	906	3	experts
export	15	4	1218	3	export
exsecants	18	9	340	3	exsecants
exsecting	19	3	593	3	exsect~~ing~~
exsection	18	4	749	3	exsect~~ion~~
exserted	16	3	621	3	exserted
extant	13	27	1475	3	extant
extend	14	26	752	3	extend
extents	14	26	1017	3	extents
extern	13	4	847	3	extern
extinct	16	4	689	3	extinct
extort	13	5	1397	3	extort
extract	16	3	1101	3	extract
exult	12	28	1412	3	ex_ult
infect	11	34	1344	3	infect
inject	15	32	1023	3	inject
insects	9	37	1084	3	insects
insert	6	43	2525	3	insert
inset	5	44	3086	3	inse_t
inspect	11	3	846	3	inspect
keyset	13	4	1153	3	keyse_t
misact	10	3	1668	3	misact
miseat	8	29	2570	3	miseat
neglect	10	4	736	3	neglect
object	17	13	580	3	object
obtect	10	12	963	3	obtect
onset	5	47	3017	3	onse_t
perfect	14	10	1083	3	perfect
prosect	11	3	1339	3	prosect
reeject	16	34	962	3	reeject
reelect	9	115	1563	3	reelect
reerect	9	29	1588	3	reerect
refect	11	43	1933	3	refect
reflect	12	39	1371	3	reflect
reject	15	41	1628	3	reject
reseat	6	41	3149	3	reseat
resects	9	41	1559	3	resects
resent	6	38	3362	3	resent
reset	5	50	5186	3	rese_t
respect	11	4	1203	3	respect
roset	5	59	4524	3	rose_t
seat	4	75	7556	3	__seat
sec	5	59	4532	3	__sec_
secs	6	50	3389	3	__secs
sects	7	56	2289	3	__sects
select	8	26	2117	3	select
sent	4	69	6301	3	__sent
sept	6	58	4436	3	__sept
set	3	66	8125	3	__se_t
sett	4	59	4905	3	__sett
sexiest	14	21	1222	3	sexiest
sext	11	73	3809	3	__sext
sextet	13	9	1687	3	sexte_t
subsect	11	26	1184	3	subsect
suspect	11	5	851	3	suspect
tensest	7	27	1331	3	tensest
tersest	7	17	1399	3	tersest
trisect	9	3	973	3	trisect
unseat	6	42	2102	3	unseat
unsent	6	38	2096	3	unsent
unset	5	45	3243	3	unse_t
upsent	8	33	1406	3	upsent
upset	7	32	2259	3	upse_t
verset	9	43	2732	3	verse_t
wisent	9	35	1634	3	wisent
wisest	9	50	1644	3	wisest
xebec	16	37	829	3	xebec_
xebecs	17	35	536	3	xebecs

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.403	443402.0
2	DLD Change Limit	112716	179	4.986	22606.5
3	Display Results	179	179	0.063	2841.3
	(SQL Overall)	178691	179	5.452	32775.3