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

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

155 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
exsects	16	5	557	(None)
expects	18	6	688	1	expects
exsect	15	5	850	1	exsect_
exserts	14	6	701	1	exserts
bisects	11	3	713	2	bisects
effects	15	3	528	2	effects
ejects	15	40	995	2	e_jects
elects	8	33	1500	2	e_lects
erects	8	41	1618	2	e_rects
exacts	15	35	961	2	ex_acts
excepts	18	8	520	2	excepts
execs	14	53	972	2	ex_ec_s
exerts	13	37	1229	2	ex_erts
expect	17	5	890	2	expect_
experts	16	5	906	2	experts
exsecants	18	9	340	2	exsecants
exsected	18	3	567	2	exsected
exsert	13	4	1436	2	exsert_
extents	14	26	1017	2	extents
insects	9	37	1084	2	insects
resects	9	41	1559	2	resects
sects	7	56	2289	2	__sects
absents	9	35	1072	3	absents
advects	13	27	601	3	advects
affects	15	3	539	3	affects
aspects	11	4	674	3	aspects
assents	7	45	1222	3	assents
asserts	7	43	1179	3	asserts
assets	6	56	1766	3	asse_ts
axseeds	15	3	339	3	axseeds
besets	8	57	1880	3	bese_ts
bisect	10	3	1287	3	bisect_
cosecs	10	50	1521	3	cosec_s
cosets	8	58	2440	3	cose_ts
cusecs	10	50	915	3	cusec_s
defects	13	45	1152	3	defects
deflects	14	33	673	3	deflects
dejects	17	38	922	3	dejects
deserts	8	25	1305	3	deserts
desserts	9	24	792	3	desserts
detects	10	40	1109	3	detects
directs	10	27	1026	3	directs
disjects	18	27	592	3	disjects
dissects	11	27	924	3	dissects
easels	6	59	1455	3	ease_ls
eases	5	60	4161	3	ease__s
easts	5	75	3032	3	eas__ts
ebbets	10	37	683	3	ebbe_ts
edicts	9	49	1170	3	e_dicts
educts	9	43	989	3	e_ducts
effect	14	3	744	3	effect_
egests	7	44	1125	3	e_gests
egrets	7	27	1224	3	egre_ts
eject	14	50	1604	3	e_ject_
ejecta	15	33	739	3	e_jecta
elect	7	43	2703	3	e_lect_
eluents	7	3	870	3	eluents
emmets	10	34	915	3	emme_ts
enacts	8	40	1297	3	e_nacts
enserfs	10	3	548	3	enserfs
epacts	10	50	1039	3	e_pacts
erect	7	41	2933	3	e_rect_
erses	5	58	2680	3	erse__s
eructs	8	36	1079	3	e_ructs
escots	8	42	1174	3	e_scots
eses	4	53	3610	3	e_se__s
essences	10	4	756	3	essences
esses	5	64	2297	3	esse__s
events	9	48	1407	3	e_vents
everts	9	45	1489	3	e_verts
evicts	11	36	855	3	e_victs
exact	14	35	1693	3	ex_act_
exacta	15	33	739	3	ex_acta
exactas	16	33	643	3	ex_actas
exalts	13	32	831	3	ex_alts
exarchs	19	16	519	3	exarchs
exceeds	17	3	384	3	exceeds
excels	15	3	666	3	exce_ls
except	17	9	765	3	except_
excerpts	19	4	374	3	excerpts
excess	15	4	605	3	exce_ss
exec	13	53	1394	3	ex_ec__
execute	16	3	678	3	ex_ecute
executes	17	3	653	3	ex_ecutes
exempts	18	4	402	3	exempts
exert	12	46	2414	3	ex_ert_
exes	11	65	3081	3	ex_e__s
exhorts	17	4	631	3	exhorts
existents	16	4	498	3	existents
exists	13	47	1091	3	ex_ists
exits	12	55	1591	3	ex__its
expats	15	3	768	3	ex_pats
expected	20	3	674	3	expected
expecter	19	3	651	3	expecter
expecters	20	4	547	3	expecters
expels	15	4	717	3	expe_ls
expends	17	21	708	3	expends
expert	15	5	1535	3	expert_
exports	16	4	798	3	exports
exsecant	17	9	475	3	exsecant
exsecting	19	3	593	3	exsecting
exsection	18	4	749	3	exsection
exsections	19	4	763	3	exsect~~ion~~s
exserted	16	3	621	3	exserted
extends	15	22	711	3	extends
extent	13	27	1491	3	extent_
externs	14	3	823	3	externs
extincts	17	4	347	3	extincts
extorts	14	4	775	3	extorts
extracts	17	4	762	3	extracts
exults	13	25	763	3	ex_ults
infects	12	27	971	3	infects
injects	16	25	745	3	injects
insect	8	39	1658	3	insect_
inserts	7	40	1399	3	inserts
insets	6	40	1613	3	inse_ts
inspects	12	5	586	3	inspects
keysets	14	3	434	3	keyse_ts
misacts	11	3	935	3	misacts
miseats	9	28	1578	3	miseats
neglects	11	4	438	3	neglects
objects	18	12	369	3	objects
onsets	6	40	1354	3	onse_ts
perfects	15	10	735	3	perfects
prosects	12	3	947	3	prosects
reejects	17	33	608	3	reejects
reelects	10	31	1088	3	reelects
reerects	10	31	992	3	reerects
refects	12	40	1274	3	refects
reflects	13	28	887	3	reflects
rejects	16	39	1069	3	rejects
reseats	7	43	1958	3	reseats
resect	8	44	2470	3	resect_
resents	7	42	2122	3	resents
resets	6	54	2761	3	rese_ts
respects	12	4	770	3	respects
rosets	6	58	1995	3	rose_ts
seats	5	48	4434	3	__seats
secs	6	50	3389	3	__sec_s
sect	6	74	4362	3	__sect_
selects	9	19	1214	3	selects
septs	7	54	2060	3	__septs
sets	4	55	4950	3	__se_ts
setts	5	51	2432	3	__setts
sextets	14	9	714	3	sexte_ts
sexts	12	51	1838	3	__sexts
subsects	12	26	790	3	subsects
suspects	12	5	486	3	suspects
trisects	10	3	598	3	trisects
unseats	7	30	1285	3	unseats
unsets	6	41	1616	3	unse_ts
upsets	8	40	968	3	upse_ts
versets	10	39	1310	3	verse_ts
wisents	10	24	906	3	wisents
xebecs	17	35	536	3	xebec_s

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	155	5.873	22820.9
3	Display Results	155	155	0.050	3100.0
	(SQL Overall)	178691	155	6.329	28233.7