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

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

104 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
barley	11	51	1676	(None)
bailey	11	50	1567	1	bailey
barely	11	47	1679	1	barely
barleys	12	50	1184	1	barleys
barney	11	53	1445	1	barney
burley	11	47	1575	1	burley
parley	11	67	1835	1	parley
agley	9	69	1733	2	_agley
alley	8	57	2167	2	_alley
arles	5	67	3574	2	_arles
badly	11	49	1876	2	badl_y
bailed	9	47	2665	2	bailed
bailee	8	45	2601	2	bailee
bailer	8	54	2525	2	bailer
baileys	12	38	893	2	baileys
baldy	11	55	1893	2	ba_ldy
bale	6	63	5384	2	ba_le_
baled	8	54	3644	2	ba_led
baler	7	56	3527	2	ba_ler
bales	7	62	5008	2	ba_les
balky	14	54	1824	2	ba_lky
balled	9	49	2689	2	balled
baller	8	38	2520	2	baller
ballet	8	47	3397	2	ballet
ballsy	11	50	887	2	ballsy
bally	10	55	3010	2	ba_lly
balmy	12	52	1747	2	ba_lmy
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	bar_e_
bared	8	51	4448	2	bar_ed
barer	7	45	3580	2	bar_er
bares	7	54	5713	2	bar_es
barfed	12	54	1638	2	barfed
barfly	14	33	965	2	barfly
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
barky	14	57	2161	2	bar_ky
barless	9	43	1700	2	barless
barlow	11	29	1142	2	barlow
barmen	10	54	1853	2	barmen
barmy	12	52	1876	2	bar_my
barned	9	56	2358	2	barned
barneys	12	56	956	2	barneys
barny	10	58	2173	2	bar_ny
barony	11	59	1530	2	barony
barre	7	59	2954	2	barre_
barred	9	57	2579	2	barred
barrel	8	45	1787	2	barrel
barren	8	53	1761	2	barren
barres	8	44	2754	2	barres
barret	8	49	3048	2	barret
barter	8	55	2537	2	barter
barye	10	50	2149	2	barye_
baryes	11	62	1850	2	baryes
basely	11	44	1231	2	basely
baulky	15	44	631	2	baulky
bawled	12	44	1569	2	bawled
bawler	11	43	1505	2	bawler
birle	7	50	2363	2	birle_
birled	9	44	1699	2	birled
birler	8	57	1508	2	birler
birles	8	49	2064	2	birles
blarney	12	17	476	2	blarney
burled	9	48	2538	2	burled
burler	8	47	2383	2	burler
burleys	12	47	967	2	burleys
burly	10	49	2283	2	burl_y
byrled	12	43	717	2	byrled
carle	7	45	3570	2	carle_
carles	8	54	3508	2	carles
carney	11	53	1570	2	carney
charley	15	11	827	2	charley
darkey	14	52	1242	2	darkey
early	8	53	2412	2	earl_y
farle	8	69	2924	2	farle_
farles	9	60	2578	2	farles
galley	10	42	1545	2	galley
garvey	13	12	787	2	garvey
hurley	12	50	1252	2	hurley
jarvey	19	13	540	2	jarvey
marled	9	55	2316	2	marled
marly	10	69	2561	2	marl_y
parlay	11	37	1399	2	parlay
parle	7	58	3616	2	parle_
parled	9	46	2628	2	parled
parles	8	63	3440	2	parles
parleys	12	52	1237	2	parleys
parsley	12	4	779	2	parsley
rarely	9	35	1365	2	rarely
valley	12	43	1160	2	valley
varlet	9	4	2350	2	varlet
yarely	12	28	1030	2	yarely

Search took 6 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.126	1418182.5
2	DLD Change Limit	82551	104	4.796	17212.5
3	Display Results	104	104	0.063	1650.8
	(SQL Overall)	178691	104	4.985	35845.7