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

Here are the results of your fuzzy-string dictionary search for “brasier” 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
brasier	9	45	1675	(None)
brakier	13	38	1236	1	brakier
brasher	12	45	1524	1	brasher
brashier	13	38	993	1	brashier
brasiers	10	37	1051	1	brasiers
brassier	10	33	1053	1	brassier
brazier	18	39	1147	1	brazier
artsier	7	6	894	2	artsier
babier	10	35	1557	2	b_abier
barkier	13	38	1448	2	barkier
barmier	11	43	1304	2	barmier
barnier	9	32	1367	2	barnier
barrier	9	40	1775	2	barrier
baser	7	48	2892	2	b_as_er
basher	11	51	2381	2	b_asher
baster	8	53	3360	2	b_aster
beadier	10	35	1391	2	beadier
beakier	13	40	1216	2	beakier
beamier	11	34	1194	2	beamier
bitsier	9	37	907	2	bitsier
blaster	9	40	1730	2	blaster
blastier	10	24	949	2	blastier
boaster	9	46	1643	2	boaster
bossier	9	37	1242	2	bossier
bracer	10	46	2058	2	bra_cer
bragger	11	38	1004	2	bragger
braggier	12	13	645	2	braggier
braider	10	51	1299	2	braider
brainier	10	25	1023	2	brainier
braise	8	43	1875	2	braise_
braised	10	40	1480	2	braised
braises	9	38	1887	2	braises
brander	10	39	1582	2	brander
branner	9	42	1237	2	branner
brannier	10	21	893	2	brannier
brashes	12	45	1846	2	brashes
brasil	8	7	1386	2	brasi_l
brasils	9	4	1097	2	brasils
brassed	10	36	1237	2	brassed
brasses	9	38	1835	2	brasses
brassie	9	34	1152	2	brassie_
brassiere	11	36	538	2	brassiere
brassies	10	36	1353	2	brassies
brattier	10	4	766	2	brattier
braver	11	47	1904	2	bra_ver
brawer	11	42	1633	2	bra_wer
brawler	12	43	1023	2	brawler
brawlier	13	26	704	2	brawlier
brawnier	13	21	672	2	brawnier
braxies	16	7	1146	2	braxies
brayer	11	53	1531	2	bra_yer
brazer	17	49	1753	2	bra_zer
braziers	19	39	719	2	braziers
brevier	12	3	776	2	brevier
brier	7	45	2740	2	br__ier
brinier	9	36	1347	2	brinier
brisker	13	42	1029	2	brisker
bruiser	9	34	957	2	bruiser
brusher	12	38	1300	2	brusher
brushier	13	30	697	2	brushier
brusker	13	43	785	2	brusker
busier	8	52	1972	2	b_usier
crasher	12	46	1616	2	crasher
crasser	9	41	1434	2	crasser
crazier	18	36	1074	2	crazier
creasier	10	32	1020	2	creasier
crosier	9	41	1658	2	crosier
easier	6	42	1846	2	_easier
eraser	6	42	1633	2	eras_er
grapier	10	37	1260	2	grapier
grasper	10	38	979	2	grasper
grassier	9	34	928	2	grassier
grazier	17	36	1113	2	grazier
greasier	9	29	808	2	greasier
praiser	9	34	1394	2	praiser
prosier	9	38	1749	2	prosier
racier	8	51	2097	2	_racier
raiser	6	66	2010	2	_raiser
rapier	8	40	1999	2	_rapier
raser	5	56	3341	2	_ras_er
rasher	9	50	2412	2	_rasher
rasper	8	39	1733	2	_rasper
raspier	9	31	1064	2	_raspier
raster	6	47	3144	2	_raster
rosier	6	42	2127	2	_rosier
tarsier	7	41	1925	2	tarsier
trasher	10	44	1613	2	trasher
trashier	11	32	1010	2	trashier

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	107671	0.373	479064.3
2	DLD Change Limit	107671	88	2.970	36252.9
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	3.373	52976.9