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

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

59 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
warren	9	50	1285	(None)
barren	8	53	1761	1	barren
warden	10	45	1551	1	warden
warred	10	40	1984	1	warred
warrens	10	38	1089	1	warrens
arpen	7	44	1804	2	_arpen
barmen	10	54	1853	2	barmen
barre	7	59	2954	2	barre_
barred	9	57	2579	2	barred
barrel	8	45	1787	2	barrel
barrens	9	44	1432	2	barrens
barres	8	44	2754	2	barres
barret	8	49	3048	2	barret
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	1740	2	garred
garret	7	44	2655	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
waired	10	60	1583	2	waired
waken	12	48	1847	2	wa_ken
warded	11	50	2104	2	warded
wardens	11	37	1190	2	wardens
warder	10	40	2027	2	warder
ware	7	62	5472	2	wa_re_
wared	9	63	3987	2	wa_red
wares	8	82	5058	2	wa_res
warier	9	37	2289	2	warier
warked	14	44	2121	2	warked
warmed	12	45	1689	2	warmed
warmer	11	38	1673	2	warmer
warn	7	52	3932	2	wa_r_n
warned	10	40	1891	2	warned
warner	9	37	1722	2	warner
warped	12	48	1641	2	warped
warper	11	40	1558	2	warper
warrant	10	6	1424	2	warrant
warrener	11	3	691	2	warrener
warring	11	37	1797	2	warring
warted	10	42	2323	2	warted
waxen	15	49	1181	2	wa_xen
worsen	9	55	1387	2	worsen
wren	7	82	2168	2	w__ren

Search took 4 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.360	496363.9
2	DLD Change Limit	82551	59	2.766	29844.9
3	Display Results	59	59	0.016	3687.5
	(SQL Overall)	178691	59	3.142	56871.7