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

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

105 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
brunts	8	52	1545	(None)
blunts	8	45	1289	1	blunts
brants	8	57	2305	1	brants
brents	8	47	1728	1	brents
bruits	8	57	1446	1	bruits
brunets	9	41	955	1	brunets
brunt	7	57	2875	1	brunt_
bruts	7	59	2295	1	bru_ts
bunts	7	57	2980	1	b_unts
grunts	7	55	1185	1	grunts
runts	5	59	2763	1	_runts
aunts	5	52	2763	2	_aunts
bents	7	60	3369	2	b_ents
bhuts	10	58	1295	2	bhu_ts
bints	7	61	3018	2	b_ints
bionts	8	6	1239	2	bionts
bluets	8	72	1549	2	bluets
blunt	7	55	2502	2	blunt_
blurts	8	44	1264	2	blurts
bounds	9	44	1580	2	bounds
bounty	11	34	1107	2	bounty
bouts	7	51	3131	2	bou_ts
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	3602	2	br_ats
brens	7	58	2336	2	bren_s
brent	7	57	3413	2	brent_
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	3309	2	br_its
britts	8	48	1345	2	britts
broncs	10	16	1115	2	broncs
brughs	12	50	906	2	brughs
bruins	8	60	1495	2	bruins
bruit	7	61	2672	2	bruit_
brulots	9	4	622	2	brulots
brumes	10	64	1707	2	brumes
brunch	13	32	935	2	brunch
brunet	8	44	1929	2	brunet
brung	8	46	1391	2	brun_g
brut	6	65	3796	2	bru_t_
brute	7	53	2178	2	bru_te
brutes	8	61	1868	2	brutes
bruxes	15	48	1102	2	bruxes
bunas	7	51	2657	2	b_unas
bunds	8	55	2354	2	b_unds
bundts	9	50	1084	2	b_undts
bungs	8	53	2386	2	b_ungs
bunks	11	51	2508	2	b_unks
bunns	7	47	1829	2	b_unns
buns	6	62	4372	2	b_un_s
bunt	6	58	5085	2	b_unt_
burets	8	43	2127	2	burets
burnets	9	38	1326	2	burnets
burns	7	49	2678	2	burn_s
burnt	7	52	3033	2	burnt_
bursts	8	51	1624	2	bursts
busts	7	52	2769	2	b_usts
buts	6	72	4769	2	b_u_ts
butts	7	58	2425	2	b_utts
counts	8	46	1827	2	counts
cruets	8	53	1495	2	cruets
crusts	8	49	1654	2	crusts
cunts	7	61	2512	2	_cunts
daunts	7	50	1408	2	daunts
drunks	11	42	751	2	drunks
dunts	6	58	2841	2	_dunts
eructs	8	36	1079	2	eructs
erupts	8	34	890	2	erupts
founts	9	43	1338	2	founts
fronts	9	44	1579	2	fronts
fruits	9	45	1249	2	fruits
grants	7	37	2247	2	grants
grunt	6	55	2354	2	grunt_
haunts	9	56	1439	2	haunts
hunts	8	68	2617	2	_hunts
jaunts	13	75	1188	2	jaunts
lunts	5	58	2690	2	_lunts
mounts	8	41	1507	2	mounts
prints	8	43	2010	2	prints
prunes	8	34	1906	2	prunes
prunus	8	39	936	2	prunus
punts	7	58	2800	2	_punts
rants	5	59	3534	2	_rants
rents	5	59	3518	2	_rents
runes	5	55	3022	2	_runes
rungs	6	118	1940	2	_rungs
runs	4	64	3808	2	_run_s
runt	4	66	4799	2	_runt_
runty	8	61	1904	2	_runty
rusts	5	50	2699	2	_rusts
ruts	4	45	4149	2	_ru_ts
shunts	9	57	1202	2	shunts
strunts	7	42	954	2	strunts
stunts	6	56	1525	2	stunts
taunts	6	57	1566	2	taunts
truants	7	3	816	2	truants
trunks	10	42	975	2	trunks
trusts	6	47	1443	2	trusts
vaunts	9	52	1262	2	vaunts

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	105	2.360	34979.2
3	Display Results	105	105	0.030	3500.0
	(SQL Overall)	178691	105	2.733	65382.7