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

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

88 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
barren	8	53	1761	(None)
barmen	10	54	1853	1	barmen
barre	7	59	2954	1	barre_
barred	9	57	2579	1	barred
barrel	8	45	1787	1	barrel
barrens	9	44	1432	1	barrens
barres	8	44	2754	1	barres
barret	8	49	3048	1	barret
warren	9	50	1285	1	warren
arpen	7	44	1804	2	_arpen
badmen	11	46	1383	2	badmen
bagmen	11	54	1253	2	bagmen
bairn	7	75	1553	2	bair_n
baleen	8	6	1305	2	baleen
barbe	9	53	2828	2	barbe_
barbed	11	51	2131	2	barbed
barbel	10	43	1707	2	barbel
barber	10	44	1932	2	barber
barbes	10	45	2623	2	barbes
barbet	10	44	2788	2	barbet
barde	8	53	3077	2	barde_
barded	10	54	2642	2	barded
bardes	9	50	2693	2	bardes
bare	6	54	6052	2	ba_re_
bared	8	51	4448	2	ba_red
barer	7	45	3580	2	ba_rer
bares	7	54	5713	2	ba_res
barfed	12	54	1638	2	barfed
barge	8	56	3102	2	barge_
barged	10	58	2264	2	barged
bargee	9	46	2444	2	bargee
barges	9	45	2825	2	barges
barked	13	50	2731	2	barked
barker	12	48	2286	2	barker
barley	11	51	1676	2	barley
barman	10	35	1970	2	barman
barn	6	64	4464	2	ba_r_n
barned	9	56	2358	2	barned
barney	11	53	1445	2	barney
baron	7	81	3124	2	ba_ron
barrels	9	45	1436	2	barrels
barrener	10	3	833	2	barrener
barrenly	13	4	542	2	barrenly
barrets	9	49	1710	2	barrets
barrier	9	40	1773	2	barrier
barring	10	40	2159	2	barring
barrio	8	3	1257	2	barrio
barrow	11	45	1276	2	barrow
bartend	10	3	875	2	bartend
barter	8	55	2537	2	barter
barye	10	50	2149	2	barye_
baryes	11	62	1850	2	baryes
baryon	11	12	1161	2	baryon
batmen	10	44	1430	2	batmen
batten	8	52	1712	2	batten
baymen	13	42	1200	2	baymen
birred	9	47	1320	2	birred
boreen	8	3	1431	2	boreen
brazen	17	48	1245	2	brazen
bren	6	56	2956	2	b__ren
burden	9	4	1247	2	burden
burred	9	58	2072	2	burred
burrer	8	37	1847	2	burrer
careen	8	41	1949	2	careen
carmen	10	40	1934	2	carmen
carrel	8	47	1863	2	carrel
carven	11	47	1666	2	carven
darken	11	40	1344	2	darken
garden	8	42	1508	2	garden
garred	8	52	1741	2	garred
garret	7	44	2656	2	garret
garron	7	31	1349	2	garron
harden	10	57	1853	2	harden
harken	13	51	1634	2	harken
jarred	14	46	1325	2	jarred
marred	9	54	2104	2	marred
marrer	8	37	1667	2	marrer
marron	8	37	1754	2	marron
marten	8	45	1826	2	marten
parred	9	50	2407	2	parred
parrel	8	45	1598	2	parrel
sarsen	6	3	1423	2	sarsen
tarre	5	58	2563	2	tarre_
tarred	7	47	2028	2	tarred
tarres	6	47	2304	2	tarres
warden	10	45	1551	2	warden
warred	10	40	1984	2	warred
warrens	10	38	1089	2	warrens

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	82551	0.780	229091.0
2	DLD Change Limit	82551	88	5.626	14673.1
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	6.436	27764.3