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

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

154 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
effect	14	3	744	(None)
affect	14	4	890	1	affect
effects	15	3	528	1	effects
affects	15	3	539	2	affects
coeffect	18	4	393	2	coeffect
defect	12	48	1617	2	defect
deffest	14	30	881	2	deffest
deflect	13	39	997	2	deflect
efface	14	36	667	2	efface
effected	17	4	499	2	effected
effecter	16	6	477	2	effecter
effector	16	4	487	2	effector
effete	12	3	518	2	effete
effort	12	3	862	2	effort
eject	14	50	1604	2	e_ject
elect	7	43	2703	2	e_lect
erect	7	41	2933	2	e_rect
expect	17	5	890	2	expect
exsect	15	5	850	2	exsect
infect	11	34	1344	2	infect
perfect	14	10	1083	2	perfect
refect	11	43	1933	2	refect
reflect	12	39	1371	2	reflect
abject	17	13	770	3	abject
advect	12	30	912	3	advect
affected	17	4	479	3	affected
affecter	16	4	452	3	affecter
afflict	15	4	704	3	afflict
afreet	9	3	1515	3	afreet
aspect	10	6	1282	3	aspect
befleck	18	4	394	3	befleck
befret	11	3	1596	3	befre_t
bisect	10	3	1287	3	bisect
buffest	15	29	864	3	buffest
buffet	14	31	1378	3	buffe_t
coeffects	19	4	246	3	coeffects
confect	14	36	1427	3	confect
deafest	11	29	1151	3	deafest
defeat	10	38	1716	3	defeat
defects	13	45	1152	3	defects
deffer	13	44	1130	3	deffe_r
deflects	14	33	673	3	deflects
deftest	11	26	1171	3	deftest
defunct	13	4	577	3	defunct
deject	16	45	1284	3	deject
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
eff	9	61	2862	3	eff___
effaced	16	22	557	3	effaced
effacer	15	25	541	3	effacer
effaces	15	27	727	3	effaces
effecters	17	6	432	3	effect~~ers~~
effecting	18	4	558	3	effect~~ing~~
effective	20	7	619	3	effect~~ive~~
effectors	17	5	503	3	effect~~ors~~
effectual	17	5	276	3	effect~~ual~~
effendi	14	4	242	3	effendi
efferent	14	4	720	3	efferent
effigy	16	4	221	3	effigy
effluent	14	13	441	3	effluent
efflux	19	4	200	3	efflux
efforts	13	3	470	3	efforts
effs	10	51	1403	3	eff__s
effuse	12	3	496	3	effuse
eft	6	60	3882	3	e_f__t
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
enact	7	35	2536	3	e_nact
enface	11	25	1035	3	enface
epact	9	49	2153	3	e_pact
erects	8	41	1618	3	e_rects
eruct	7	40	2235	3	e_ruct
event	8	59	2444	3	e_vent
evert	8	49	2951	3	e_vert
evict	10	44	1714	3	e_vict
exact	14	35	1693	3	e_xact
except	17	9	765	3	except
exec	13	53	1394	3	e_xec_
execs	14	53	972	3	e_xecs
exert	12	46	2414	3	e_xert
expects	18	6	688	3	expects
expert	15	5	1535	3	expert
exsects	16	5	557	3	exsects
exsert	13	4	1436	3	exsert
extent	13	27	1491	3	extent
facet	10	60	3852	3	_facet
fact	9	71	4254	3	__fact
feat	7	64	5822	3	__feat
feck	13	49	2343	3	__feck
feet	7	53	5221	3	__feet
felt	7	51	4693	3	__felt
fest	7	49	4944	3	__fest
fet	6	64	7163	3	__fe_t
fewest	12	3	1166	3	fewest
feyest	12	3	1140	3	feyest
fleck	14	82	1359	3	_fleck
fleet	8	59	3233	3	_fleet
fret	7	58	4504	3	_fre_t
haffet	15	3	1170	3	haffe_t
iffiest	13	3	797	3	iffiest
infects	12	27	971	3	infects
infest	9	33	1543	3	infest
inflect	12	4	922	3	inflect
inject	15	32	1023	3	inject
insect	8	39	1658	3	insect
leftest	10	26	946	3	leftest
neglect	10	4	736	3	neglect
object	17	13	580	3	object
obtect	10	12	963	3	obtect
offbeat	15	6	414	3	offbeat
offcut	14	4	470	3	offcut
offed	12	35	916	3	offe_d
offence	15	4	535	3	offence
offend	13	36	566	3	offend
offer	11	43	1138	3	offe_r
offers	12	34	996	3	offers
office	14	3	569	3	office
offset	12	3	837	3	offset
oftest	9	12	1200	3	oftest
perfecta	15	11	520	3	perfecta
perfecto	15	10	574	3	perfecto
perfects	15	10	735	3	perfects
pfft	12	3	1188	3	pff__t
prefect	14	10	1107	3	prefect
redefect	14	4	605	3	redefect
reeject	16	34	962	3	reeject
reelect	9	115	1563	3	reelect
reerect	9	29	1588	3	reerect
refects	12	40	1274	3	refects
refelt	9	45	2142	3	refelt
reffed	13	47	1251	3	reffe_d
reflects	13	28	887	3	reflects
reflet	9	40	2423	3	refle_t
refract	12	13	1160	3	refract
reinfect	13	4	648	3	reinfect
reject	15	41	1628	3	reject
resect	8	44	2470	3	resect
respect	11	4	1203	3	respect
rifest	9	31	1458	3	rifest
safest	9	50	1660	3	safest
sect	6	74	4362	3	__sect
select	8	26	2117	3	select
tuffet	12	26	1208	3	tuffe_t
unfelt	9	24	1346	3	unfelt
webfeet	15	4	459	3	webfeet

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	154	5.046	22337.7
3	Display Results	154	154	0.046	3347.8
	(SQL Overall)	178691	154	5.465	32697.3