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

Here are the results of your fuzzy-string dictionary search for “anent” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

93 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
anent	5	49	3184	(None)
agent	6	58	2964	1	agent
ament	7	60	3654	1	ament
anenst	6	35	1498	1	anenst
abet	6	105	4794	2	abe_t
absent	8	40	1699	2	absent
accent	10	51	1626	2	accent
adept	8	12	1964	2	adept
advent	10	26	1375	2	advent
agene	6	56	2158	2	agene
agents	7	48	1629	2	agents
akene	9	58	1866	2	akene
alant	5	57	4229	2	alant
alert	5	47	4065	2	alert
amen	6	67	3315	2	amen_
amend	8	57	1775	2	amend
amens	7	56	2484	2	amens
aments	8	52	1980	2	aments
ancient	9	5	1473	2	ancient
ane	3	78	6694	2	ane__
anear	5	54	2032	2	anear
anele	5	56	2883	2	anele
anes	4	52	5593	2	ane_s
anew	7	66	2313	2	ane_w
angst	6	4	1549	2	angst
anna	4	55	2901	2	an_na
annex	12	3	1088	2	annex
anoint	6	4	2363	2	anoint
anon	4	61	3485	2	anon_
ant	3	72	7078	2	a__nt
ardent	7	30	2261	2	ardent
arena	5	53	2381	2	arena
arene	5	53	2941	2	arene
argent	7	40	2366	2	argent
arpent	8	48	2209	2	arpent
ascent	8	45	1965	2	ascent
assent	6	51	1995	2	assent
attent	6	28	1832	2	attent
aunt	4	65	5365	2	a_unt
avant	8	62	2466	2	avant
avens	8	64	1933	2	avens
avert	8	60	2949	2	avert
bannet	8	49	2533	2	bannet
bent	6	77	5991	2	_bent
blent	7	62	3095	2	blent
brent	7	57	3413	2	brent
cadent	9	41	2035	2	cadent
candent	10	4	1736	2	candent
cent	6	74	5101	2	_cent
dent	5	71	5841	2	_dent
event	8	59	2444	2	event
gannet	7	43	2185	2	gannet
gent	5	69	5439	2	_gent
hent	7	66	5638	2	_hent
incent	8	33	2072	2	incent
indent	7	30	2124	2	indent
inept	7	36	2215	2	inept
inert	5	32	3437	2	inert
intent	6	31	2277	2	intent
invent	9	33	1636	2	invent
kent	8	68	4696	2	_kent
knelt	9	46	1768	2	knelt
lament	8	50	2494	2	lament
latent	6	41	2430	2	latent
lent	4	63	6053	2	_lent
neat	4	63	5678	2	_neat
nene	4	59	3206	2	_nene
nest	4	55	4873	2	_nest
net	3	66	7029	2	_ne_t
nett	4	66	4323	2	_nett
newt	7	69	3374	2	_newt
next	11	66	3108	2	_next
parent	8	32	3042	2	parent
patent	8	45	2492	2	patent
pent	6	65	5907	2	_pent
ponent	8	28	2159	2	ponent
rent	4	66	6124	2	_rent
sanest	6	44	2669	2	sanest
scent	7	58	3162	2	scent
sent	4	69	6301	2	_sent
shent	8	59	3349	2	shent
spent	7	55	3283	2	spent
stent	5	56	3451	2	stent
talent	6	3	2332	2	talent
tangent	8	3	1499	2	tangent
tent	4	61	5986	2	_tent
unbent	8	32	1659	2	unbent
unkent	10	31	1605	2	unkent
unpent	8	31	1737	2	unpent
unrent	6	32	1978	2	unrent
unsent	6	38	2096	2	unsent
vent	7	60	4905	2	_vent
went	7	60	5187	2	_went

Search took 2 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	93	1.733	31044.4
3	Display Results	93	93	0.033	2818.2
	(SQL Overall)	178691	93	1.859	96122.1