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

Here are the results of your fuzzy-string dictionary search for “bramblier” with Change Limit: [1] [2] [3] [4]

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.

78 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
bramblier	15	4	350	(None)
brabbler	11	39	737	2	brabbl_er
bramble	13	37	1003	2	brambl_e_
brambled	15	31	673	2	brambl_ed
brambles	14	30	897	2	brambl_es
brambliest	16	4	377	2	brambliest
brambling	16	3	554	2	brambling
brawlier	13	26	704	2	bra_wlier
crumblier	15	4	387	2	crumblier
rambler	11	33	1326	2	_rambl_er
tremblier	13	4	328	2	tremblier
wamblier	15	27	573	2	_wamblier
ambler	10	49	1645	3	__ambl_er
babbler	10	40	1282	3	b_abbl_er
babier	10	35	1557	3	b_a_b_ier
barmier	11	43	1304	3	barm__ier
beamier	11	34	1194	3	beam__ier
beastlier	11	4	420	3	beastlier
brabble	10	34	997	3	brabbl_e_
brabbled	12	33	763	3	brabbl_ed
brabblers	12	33	556	3	brabbl_ers
brabbles	11	34	975	3	brabbl_es
brabbling	13	3	496	3	brabbling
braggier	12	13	645	3	bra_ggier
brailler	10	3	688	3	bra_iller
brainier	10	25	1023	3	bra_inier
brakier	13	38	1236	3	bra__kier
bramblings	17	4	261	3	bramblings
brambly	16	29	625	3	brambl__y
branchier	16	3	713	3	branchier
brannier	10	21	893	3	bra_nnier
brashier	13	38	993	3	bra_shier
brasier	9	45	1675	3	bra__sier
brassier	10	33	1053	3	bra_ssier
brattier	10	4	766	3	bra_ttier
brawler	12	43	1023	3	bra_wl_er
brawlie	12	19	815	3	bra_wlie_
brawnier	13	21	672	3	bra_wnier
brazier	18	39	1147	3	bra__zier
bristlier	11	4	431	3	bristlier
brumbies	14	3	653	3	brumb_ies
bubblier	11	8	447	3	b_ubblier
bumbler	13	40	1323	3	b_umbl_er
burblier	12	5	560	3	b_urblier
crabbier	14	32	680	3	cra_bbier
cracklier	17	4	482	3	cracklier
crampier	14	28	890	3	cram_pier
crawlier	13	21	687	3	cra_wlier
crumbier	14	5	636	3	crumb_ier
crumplier	15	4	378	3	crumplier
drawlier	12	22	525	3	dra_wlier
drumlier	11	3	452	3	drum_lier
gambier	12	47	1197	3	_gamb_ier
gambler	12	36	1268	3	_gambl_er
grabbier	13	31	665	3	gra_bbier
grabbler	13	37	769	3	grabbl_er
grumbler	13	86	668	3	grumbl_er
lambier	11	36	1164	3	_lamb_ier
marblier	12	5	634	3	_marblier
rabbler	11	35	1409	3	_rabbl_er
rallier	7	38	1628	3	_ra_llier
ramble	10	45	1997	3	_rambl_e_
rambled	12	39	1352	3	_rambl_ed
ramblers	12	40	1037	3	_rambl_ers
rambles	11	31	1831	3	_rambl_es
rambling	13	18	1077	3	_rambling
ramilie	9	3	1028	3	_ramilie_
ramilies	10	3	1183	3	_ramilies
rammier	11	28	1102	3	_ram_mier
rubblier	12	4	491	3	_rubblier
rumbler	11	35	1411	3	_rumbl_er
rumplier	12	3	530	3	_rumplier
scrabblier	16	4	277	3	scrabblier
scrambler	15	16	504	3	scrambl_er
trampier	12	31	824	3	tram_pier
trampler	12	27	801	3	trampl_er
trembler	12	3	536	3	trembl_er
wabblier	15	37	549	3	_wabblier

Search took 8 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	148641	0.453	394461.4
2	DLD Change Limit	148641	78	7.330	20278.4
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	7.813	22871.0