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

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

176 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
expect	17	5	890	(None)
expects	18	6	688	1	expects
expert	15	5	1535	1	expert
exsect	15	5	850	1	exsect
aspect	10	6	1282	2	aspect
effect	14	3	744	2	effect
eject	14	50	1604	2	e_ject
elect	7	43	2703	2	e_lect
epact	9	49	2153	2	e_pact
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
expat	14	3	1381	2	exp_at
expected	20	3	674	2	expected
expecter	19	3	651	2	expecter
expel	14	4	823	2	expe_l
expels	15	4	717	2	expels
expend	16	24	750	2	expend
experts	16	5	906	2	experts
export	15	4	1218	2	export
exsects	16	5	557	2	exsects
exsert	13	4	1436	2	exsert
extent	13	27	1491	2	extent
respect	11	4	1203	2	respect
abject	17	13	770	3	abject
advect	12	30	912	3	advect
affect	14	4	890	3	affect
arpent	8	48	2209	3	arpent
aspects	11	4	674	3	aspects
bisect	10	3	1287	3	bisect
copeck	16	3	694	3	copeck
deepest	10	3	1044	3	deepest
defect	12	48	1617	3	defect
deflect	13	39	997	3	deflect
deject	16	45	1284	3	deject
depict	11	35	1479	3	depict
detect	9	42	1740	3	detect
direct	9	38	1733	3	direct
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
eluent	6	3	1548	3	eluent
emmet	9	42	2138	3	emme_t
empery	13	4	868	3	empery
enact	7	35	2536	3	e_nact
epacts	10	50	1039	3	e_pacts
epee	6	46	2850	3	e_pe_e
epees	7	52	1983	3	e_pees
epic	8	69	2130	3	e_pic_
epics	9	50	1428	3	e_pics
epoch	12	4	820	3	e_poch
erects	8	41	1618	3	e_rects
eruct	7	40	2235	3	e_ruct
esprit	8	3	1284	3	esprit
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
exit	11	44	2867	3	ex__it
expand	16	23	657	3	expand
expats	15	3	768	3	expats
expectant	20	4	567	3	expec~~tan~~t
expecters	20	4	547	3	expect~~ers~~
expecting	21	4	669	3	expect~~ing~~
expedite	18	4	726	3	expedite
expends	17	21	708	3	expends
expense	16	12	787	3	expense
experted	18	3	805	3	experted
expertly	20	4	470	3	expertly
expiate	16	9	1059	3	expiate
expire	15	3	802	3	expire
expiry	18	3	465	3	expiry
explant	16	3	1013	3	explant
explicit	19	4	646	3	explicit
exploit	16	4	862	3	exploit
expo	13	4	918	3	exp__o
exponent	17	4	713	3	exponent
exports	16	4	798	3	exports
expos	14	4	920	3	exp_os
expose	15	4	952	3	expose
exposit	16	4	968	3	exposit
express	16	3	749	3	express
exsecant	17	9	475	3	exsecant
exsected	18	3	567	3	exsected
exserts	14	6	701	3	exserts
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	690	3	extinct
extort	13	5	1397	3	extort
extract	16	3	1101	3	extract
exult	12	28	1412	3	ex_ult
henpeck	18	4	308	3	henpeck
heppest	14	22	815	3	heppest
impact	12	23	1045	3	impact
inexpert	17	4	608	3	inexpert
infect	11	34	1344	3	infect
inject	15	32	1023	3	inject
insect	8	39	1658	3	insect
inspect	11	3	846	3	inspect
kopeck	13	3	342	3	kopeck
neglect	10	4	736	3	neglect
object	17	13	580	3	object
obtect	10	12	963	3	obtect
pact	8	66	4872	3	__pact
peat	6	59	6793	3	__peat
pec	7	67	4441	3	__pec_
pech	11	61	2545	3	__pech
peck	12	57	3068	3	__peck
pecs	8	46	3410	3	__pecs
pelt	6	76	5108	3	__pelt
pent	6	65	5907	3	__pent
perfect	14	10	1083	3	perfect
perpent	11	23	1881	3	perpent
pert	6	67	5932	3	__pert
pest	6	55	5529	3	__pest
pet	5	64	7730	3	__pe_t
pipet	9	55	3332	3	pipe_t
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
repeat	8	51	2721	3	repeat
repent	8	47	2887	3	repent
resect	8	44	2470	3	resect
respects	12	4	770	3	respects
respelt	9	3	1214	3	respelt
ripest	8	43	1794	3	ripest
sect	6	74	4362	3	__sect
select	8	26	2117	3	select
serpent	9	29	1628	3	serpent
sexiest	14	21	1222	3	sexiest
sexpot	15	3	954	3	sexp_ot
sextet	13	9	1687	3	sexte_t
spec	8	58	2197	3	_spec_
speck	13	51	1565	3	_speck
specs	9	69	1667	3	_specs
spelt	7	54	3019	3	_spelt
spent	7	55	3283	3	_spent
suspect	11	5	851	3	suspect
tempest	11	3	922	3	tempest
unexpert	17	4	434	3	unexpert
unpent	8	31	1737	3	unpent
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.390	458182.1
2	DLD Change Limit	112716	176	5.376	20966.5
3	Display Results	176	176	0.060	2933.3
	(SQL Overall)	178691	176	5.826	30671.3