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

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

93 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
brander	10	39	1582	(None)
bander	9	39	2822	1	b_ander
blander	10	37	1517	1	blander
braider	10	51	1299	1	braider
branded	11	44	1410	1	branded
branders	11	43	1309	1	branders
branner	9	42	1237	1	branner
grander	9	33	1587	1	grander
abrader	10	3	864	2	abra_der
badder	10	38	1751	2	b_adder
balder	9	53	1886	2	b_alder
banded	10	52	2317	2	b_anded
banders	10	43	2456	2	b_anders
banger	9	44	2364	2	b_anger
banker	12	42	2273	2	b_anker
banner	8	44	2150	2	b_anner
banter	8	48	2534	2	b_anter
barnier	9	32	1367	2	barnier
beader	9	46	2379	2	bea_der
bender	9	52	2330	2	b_ender
bilander	11	3	667	2	bilander
binder	9	44	2287	2	b_inder
bladder	11	42	915	2	bladder
blader	9	36	1858	2	bla_der
blanker	13	46	1202	2	blanker
blender	10	46	1385	2	blender
blinder	10	39	1299	2	blinder
blonder	10	40	1195	2	blonder
blunder	10	38	1316	2	blunder
boarder	10	39	1032	2	boarder
bonder	9	53	2478	2	b_onder
bounder	10	42	1554	2	bounder
bracer	10	46	2058	2	bra_cer
bradded	12	38	871	2	bradded
bragger	11	38	1004	2	bragger
braided	11	40	1321	2	braided
braiders	11	41	1057	2	braiders
brainier	10	25	1023	2	brainier
brakier	13	38	1236	2	brakier
brand	8	51	2449	2	brand__
brandied	12	5	911	2	brandied
brandies	11	7	1456	2	brandies
brands	9	51	1894	2	brand_s
brandy	12	47	1206	2	brand_y
branned	10	43	1169	2	branned
branners	10	40	1092	2	branners
brannier	10	21	893	2	brannier
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
breeder	10	32	1004	2	breeder
brinded	11	51	1205	2	brinded
briner	8	45	1904	2	brin_er
bringer	10	42	1335	2	bringer
brinier	9	36	1347	2	brinier
broader	10	34	1261	2	broader
broider	10	39	1297	2	broider
bronzer	18	34	849	2	bronzer
brooder	10	38	1162	2	brooder
cranker	13	36	1279	2	cranker
dander	8	112	2299	2	_dander
franker	14	35	1018	2	franker
gander	8	43	2276	2	_gander
grader	8	49	1969	2	gra_der
grandee	9	31	1551	2	grandee
grandeur	10	30	567	2	grandeur
granger	9	35	1421	2	granger
granter	8	41	1713	2	granter
grinder	9	33	1239	2	grinder
hander	10	45	2643	2	_hander
lander	7	40	2849	2	_lander
meander	10	4	997	2	meander
pander	9	37	2553	2	_pander
prancer	11	36	1338	2	prancer
raider	7	43	1874	2	_raider
randier	8	36	1847	2	_randier
ranger	7	39	2553	2	_ranger
ranker	10	50	2190	2	_ranker
ranter	6	38	2682	2	_ranter
render	7	40	2414	2	_render
sander	7	48	2853	2	_sander
slander	8	40	1545	2	slander
stander	8	43	1616	2	stander
strander	9	71	1206	2	strander
trader	7	52	1876	2	tra_der
wander	10	44	2371	2	_wander
zander	16	34	1711	2	_zander

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.390	458182.1
2	DLD Change Limit	107671	93	3.360	32044.9
3	Display Results	93	93	0.046	2021.7
	(SQL Overall)	178691	93	3.796	47073.5