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

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

174 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
affect	14	4	890	(None)
affects	15	3	539	1	affects
effect	14	3	744	1	effect
abject	17	13	770	2	abject
advect	12	30	912	2	advect
affected	17	4	479	2	affected
affecter	16	4	452	2	affecter
afflict	15	4	704	2	afflict
afreet	9	3	1515	2	afreet
aspect	10	6	1282	2	aspect
defect	12	48	1617	2	defect
effects	15	3	528	2	effects
haffet	15	3	1170	2	haffe_t
infect	11	34	1344	2	infect
refect	11	43	1933	2	refect
abduct	11	10	854	3	abduct
abet	6	105	4794	3	a_be_t
ablest	8	47	2183	3	ablest
abreact	11	3	1082	3	abreact
absent	8	40	1699	3	absent
accent	10	51	1626	3	accent
accept	12	32	1062	3	accept
act	5	95	5784	3	a___ct
addict	10	7	1120	3	addict
adduct	10	8	737	3	adduct
adept	8	12	1964	3	a_dept
advects	13	27	601	3	advects
advent	10	26	1375	3	advent
advert	10	32	1578	3	advert
aff	9	55	3761	3	aff___
affair	12	3	435	3	affair
affecters	17	6	393	3	affect~~ers~~
affecting	18	4	523	3	affect~~ing~~
affection	17	4	589	3	affect~~ion~~
affective	20	13	541	3	affect~~ive~~
afferent	14	4	798	3	afferent
affiant	13	4	843	3	affiant
affiche	18	4	431	3	affiche
affine	12	3	1050	3	affine
affirm	14	3	552	3	affirm
affix	18	3	600	3	aff_ix
afflicts	16	4	400	3	afflicts
affluent	14	9	455	3	affluent
afflux	19	4	279	3	afflux
afford	13	4	649	3	afford
afforest	14	4	634	3	afforest
affray	15	3	497	3	affray
affront	13	5	796	3	affront
afield	10	3	595	3	afield
afloat	9	3	1515	3	afloat
afoot	8	4	2011	3	a_foot
afreets	10	3	701	3	afreets
afresh	12	5	550	3	afresh
afrit	8	3	2317	3	a_frit
aft	6	68	4901	3	a_f__t
after	8	57	1979	3	afte_r
afters	9	47	1707	3	afters
agent	6	58	2964	3	a_gent
aglet	6	55	3414	3	agle_t
airest	6	38	2526	3	airest
albeit	8	3	1434	3	albeit
alec	6	64	3006	3	a_lec_
alecs	7	66	2073	3	a_lecs
alert	5	47	4065	3	a_lert
ament	7	60	3654	3	a_ment
anent	5	49	3184	3	a_nent
apiece	10	5	1008	3	apiece
aptest	8	29	1751	3	aptest
ardent	7	30	2261	3	ardent
areca	7	56	1863	3	a_reca
argent	7	40	2366	3	argent
armet	7	67	3945	3	arme_t
arpent	8	48	2209	3	arpent
arrest	6	37	2263	3	arrest
ascent	8	45	1965	3	ascent
aspects	11	4	674	3	aspects
assent	6	51	1995	3	assent
assert	6	49	2258	3	assert
asset	5	59	3226	3	asse_t
attent	6	28	1832	3	attent
attest	6	26	1861	3	attest
avert	8	60	2949	3	a_vert
avocet	11	4	1268	3	avocet
baffed	15	48	1217	3	baffe_d
bisect	10	3	1287	3	bisect
buffest	15	29	864	3	buffest
buffet	14	31	1378	3	buffe_t
caffein	15	3	533	3	caffein
cathect	14	3	986	3	cathect
coeffect	18	4	393	3	coeffect
confect	14	36	1427	3	confect
daffed	14	42	949	3	daffe_d
daffiest	15	3	785	3	daffiest
daftest	11	24	894	3	daftest
defeat	10	38	1716	3	defeat
defects	13	45	1152	3	defects
deffest	14	30	881	3	deffest
deflect	13	39	997	3	deflect
deject	16	45	1284	3	deject
detect	9	42	1740	3	detect
direct	9	38	1733	3	direct
disaffect	18	7	310	3	~~dis~~affect
efface	14	36	667	3	efface
effected	17	4	499	3	effected
effecter	16	6	477	3	effecter
effector	16	4	487	3	effector
effete	12	3	518	3	effete
effort	12	3	862	3	effort
eject	14	50	1604	3	_eject
elect	7	43	2703	3	_elect
erect	7	41	2933	3	_erect
expect	17	5	890	3	expect
exsect	15	5	850	3	exsect
facet	10	60	3852	3	face_t
fact	9	71	4254	3	__fact
faucet	11	58	1655	3	faucet
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
fleck	14	82	1359	3	_fleck
fleet	8	59	3233	3	_fleet
fret	7	58	4504	3	_fre_t
gabfest	13	3	645	3	gabfest
gaffe	12	41	1165	3	gaffe__
gaffed	14	42	1020	3	gaffe_d
gaffer	13	43	1013	3	gaffe_r
gaffers	14	42	871	3	gaffers
gaffes	13	48	1110	3	gaffe_s
haffets	16	3	605	3	haffets
haffit	15	3	853	3	haff_it
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
maffick	21	4	352	3	maffick
naffed	13	40	833	3	naffe_d
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
pandect	12	3	1095	3	pandect
perfect	14	10	1083	3	perfect
pfft	12	3	1188	3	pff__t
praefect	15	4	477	3	praefect
prefect	14	10	1107	3	prefect
refects	12	40	1274	3	refects
refelt	9	45	2142	3	refelt
reflect	12	39	1371	3	reflect
reject	15	41	1628	3	reject
resect	8	44	2470	3	resect
rifest	9	31	1458	3	rifest
safest	9	50	1660	3	safest
sect	6	74	4362	3	__sect
select	8	26	2117	3	select
taffeta	13	4	326	3	taffeta
tuffet	12	26	1208	3	tuffe_t
unfelt	9	24	1346	3	unfelt
waffed	16	45	979	3	waffe_d
yaffed	16	45	732	3	yaffe_d
zaffer	21	39	715	3	zaffe_r
zaffers	22	38	677	3	zaffers

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	112716	0.376	475242.0
2	DLD Change Limit	112716	174	5.670	19879.4
3	Display Results	174	174	0.063	2761.9
	(SQL Overall)	178691	174	6.109	29250.5