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

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

65 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
branner	9	42	1237	(None)
banner	8	44	2150	1	b_anner
brander	10	39	1582	1	brander
branned	10	43	1169	1	branned
branners	10	40	1092	1	branners
brannier	10	21	893	1	brannier
bander	9	39	2822	2	b_ander
banger	9	44	2363	2	b_anger
banker	12	42	2273	2	b_anker
banned	9	47	2134	2	b_anned
banners	9	40	1871	2	b_anners
bannet	8	49	2533	2	b_annet
banter	8	48	2533	2	b_anter
barnier	9	32	1367	2	barnier
blander	10	37	1516	2	blander
blanker	13	46	1202	2	blanker
bracer	10	46	2058	2	bra_cer
bragger	11	38	1004	2	bragger
braider	10	51	1299	2	braider
brained	10	38	1610	2	brained
brainier	10	25	1023	2	brainier
brakier	13	38	1236	2	brakier
branded	11	44	1410	2	branded
branders	11	43	1309	2	branders
branny	11	51	1183	2	brann_y
brasher	12	45	1524	2	brasher
brasier	9	45	1675	2	brasier
braver	11	47	1904	2	bra_ver
brawer	11	42	1633	2	bra_wer
brawler	12	43	1023	2	brawler
brawnier	13	21	672	2	brawnier
brayer	11	53	1531	2	bra_yer
brazer	17	49	1753	2	bra_zer
brazier	18	39	1147	2	brazier
briner	8	45	1904	2	br_iner
bringer	10	42	1335	2	bringer
brinier	9	36	1347	2	brinier
bronzer	18	34	849	2	bronzer
browner	12	49	1164	2	browner
canner	8	46	2598	2	_canner
cranker	13	36	1278	2	cranker
drainer	8	30	1284	2	drainer
fanner	9	42	1818	2	_fanner
franker	14	35	1018	2	franker
grainer	8	37	1406	2	grainer
grander	9	33	1587	2	grander
granger	9	35	1421	2	granger
granter	8	41	1713	2	granter
grinner	8	32	923	2	grinner
lanner	6	49	2060	2	_lanner
manner	8	40	2051	2	_manner
panner	8	42	2476	2	_panner
planner	9	35	1162	2	planner
prancer	11	36	1338	2	prancer
prawner	12	4	680	2	prawner
ranger	7	39	2552	2	_ranger
ranker	10	50	2190	2	_ranker
ranter	6	38	2682	2	_ranter
runner	6	38	1446	2	_runner
scanner	9	44	1181	2	scanner
spanner	9	43	1256	2	spanner
tanner	6	37	2228	2	_tanner
trainer	7	33	1679	2	trainer
vanner	9	42	1584	2	_vanner
wanner	9	40	1962	2	_wanner

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.143	1249587.4
2	DLD Change Limit	107671	65	3.013	35735.5
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	3.172	56333.9