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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

106 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
brents	8	47	1727	(None)
bents	7	60	3369	1	b_ents
brants	8	57	2305	1	brants
brens	7	58	2336	1	bren_s
brent	7	57	3413	1	brent_
brunts	8	52	1545	1	brunts
rents	5	59	3518	1	_rents
absents	9	35	1072	2	absents
agents	7	48	1629	2	agents
aments	8	52	1980	2	aments
arenas	6	50	2199	2	arenas
arenes	6	49	2839	2	arenes
argents	8	40	1485	2	argents
arpents	9	36	1308	2	arpents
beats	7	60	4224	2	b_eats
beets	7	61	3144	2	b_eets
belts	7	59	3116	2	b_elts
bends	8	56	2897	2	b_ends
benes	7	55	3623	2	b_enes
bens	6	59	4570	2	b_en_s
bent	6	77	5991	2	b_ent_
bento	7	59	2295	2	b_ento
bentos	8	62	1830	2	b_entos
berets	8	58	2252	2	berets
bests	7	59	3261	2	b_ests
bets	6	70	5144	2	b_e_ts
bints	7	61	3018	2	b_ints
bionts	8	6	1239	2	bionts
bleats	8	55	1861	2	bleats
blends	9	60	1288	2	blends
blent	7	62	3095	2	blent_
blets	7	53	2494	2	ble_ts
blunts	8	45	1289	2	blunts
bracts	10	56	1777	2	bracts
brands	9	51	1894	2	brands
branks	12	48	1738	2	branks
brans	7	54	3743	2	bran_s
brant	7	47	4217	2	brant_
brats	7	53	3601	2	br_ats
breads	9	54	1920	2	breads
breaks	12	48	1642	2	breaks
breams	10	48	1504	2	breams
breast	8	3	1963	2	breast
breasts	9	3	970	2	breasts
breath	11	39	1626	2	breath
breaths	12	44	1118	2	breaths
bredes	9	48	1847	2	bredes
breeds	9	49	1488	2	breeds
breeks	12	53	1079	2	breeks
brees	7	56	3255	2	bre_es
bren	6	56	2956	2	bren__
breves	11	55	1642	2	breves
brevets	12	51	939	2	brevets
brewis	11	46	998	2	brewis
brews	10	56	1707	2	bre_ws
brines	8	50	2885	2	brines
brings	9	46	1843	2	brings
brinks	12	46	1631	2	brinks
brins	7	55	3397	2	brin_s
brits	7	64	3308	2	br_its
britts	8	48	1344	2	britts
broncs	10	16	1115	2	broncs
bruits	8	57	1445	2	bruits
brunets	9	41	955	2	brunets
brunt	7	57	2875	2	brunt_
bruts	7	59	2295	2	br_uts
bunts	7	57	2980	2	b_unts
burets	8	43	2126	2	bure_ts
burnets	9	38	1326	2	burnets
cents	7	47	3033	2	_cents
crests	8	52	1870	2	crests
dents	6	50	3180	2	_dents
erects	8	41	1618	2	erects
events	9	48	1407	2	events
frets	8	55	2340	2	fre_ts
fronts	9	44	1579	2	fronts
gents	6	57	2961	2	_gents
gerents	8	26	1292	2	gerents
grants	7	37	2247	2	grants
greats	7	63	1839	2	greats
greets	7	51	1742	2	greets
grunts	7	55	1185	2	grunts
hents	8	73	3074	2	_hents
orients	7	3	1158	2	orients
parents	9	34	1812	2	parents
prests	8	40	2126	2	prests
prints	8	43	2010	2	prints
rants	5	59	3534	2	_rants
rends	6	51	2995	2	_rends
rent	4	66	6124	2	_rent_
rente	5	47	3378	2	_rente
rentes	6	54	3119	2	_rentes
rerents	7	33	1942	2	rerents
rests	5	49	3587	2	_rests
rets	4	53	5256	2	_re_ts
runts	5	59	2763	2	_runts
scents	8	53	1702	2	scents
stents	6	50	1945	2	stents
subrents	10	3	1029	2	subrents
tents	5	64	3421	2	_tents
treats	6	48	2169	2	treats
trends	7	55	1354	2	trends
trets	5	59	2802	2	tre_ts
vents	8	61	2593	2	_vents
wrens	8	50	1624	2	wren_s
wrests	9	53	1308	2	wrests

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	106	2.466	33475.7
3	Display Results	106	106	0.033	3212.1
	(SQL Overall)	178691	106	2.842	62875.1