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

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

89 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
grander	9	33	1587	(None)
brander	10	39	1582	1	brander
gander	8	43	2276	1	g_ander
grader	8	49	1969	1	gra_der
grandee	9	31	1551	1	grandee
grandeur	10	30	567	1	grandeur
granger	9	35	1421	1	granger
granter	8	41	1713	1	granter
grinder	9	33	1239	1	grinder
bander	9	39	2822	2	_bander
blander	10	37	1516	2	blander
braider	10	51	1299	2	braider
branded	11	44	1410	2	branded
branders	11	43	1309	2	branders
branner	9	42	1237	2	branner
cranker	13	36	1279	2	cranker
dander	8	112	2299	2	_dander
franker	14	35	1018	2	franker
gadder	9	37	1471	2	g_adder
ganders	9	35	2170	2	g_anders
ganger	8	37	2146	2	g_anger
garner	7	39	1700	2	garn_er
gender	8	35	1793	2	g_ender
germander	13	4	536	2	germander
gladder	10	39	831	2	gladder
glancer	10	37	1007	2	glancer
glanders	10	38	1150	2	glanders
glandes	9	54	1383	2	glandes
grabber	12	38	976	2	grabber
grade	7	51	2609	2	gra_de_
graded	9	49	1955	2	gra_ded
graders	9	47	1601	2	gra_ders
grades	8	49	2631	2	gra_des
grafter	11	42	1115	2	grafter
grainer	8	37	1406	2	grainer
grainier	9	21	890	2	grainier
grand	7	51	2269	2	grand__
grandad	10	3	845	2	grandad
grandam	11	3	939	2	grandam
grandees	10	32	1128	2	grandees
grandest	10	3	1157	2	grandest
grandeurs	11	33	511	2	grandeurs
grandly	12	3	874	2	grandly
grandma	11	3	691	2	grandma
grandpa	11	3	541	2	grandpa
grands	8	42	1824	2	grand_s
grandsir	10	4	431	2	grandsir
grange	8	37	1620	2	grange_
grangers	10	30	1197	2	grangers
granges	9	35	1652	2	granges
granted	9	47	1510	2	granted
grantee	8	32	1713	2	grantee
granters	9	36	1414	2	granters
grantor	8	40	1094	2	grantor
grapier	10	37	1260	2	grapier
grasper	10	38	979	2	grasper
grater	7	46	2544	2	gra_ter
graver	10	50	1859	2	gra_ver
grayer	10	60	1454	2	gra_yer
grazer	16	48	1576	2	gra_zer
grazier	17	36	1113	2	grazier
gridder	10	36	776	2	gridder
grinded	10	42	1063	2	grinded
grinders	10	34	1042	2	grinders
grindery	13	25	551	2	grindery
grinner	8	32	923	2	grinner
groaner	8	25	1013	2	groan_er
grounder	10	4	761	2	grounder
grunger	9	38	978	2	grunger
grunter	8	31	1078	2	grunter
guarder	9	3	646	2	guarder
hander	10	45	2643	2	_hander
lander	7	40	2848	2	_lander
meander	10	4	997	2	meander
pander	9	37	2552	2	_pander
prancer	11	36	1338	2	prancer
raider	7	43	1874	2	_raider
randier	8	36	1847	2	_randier
ranger	7	39	2552	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	1544	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	89	2.860	37647.2
3	Display Results	89	89	0.046	1934.8
	(SQL Overall)	178691	89	3.296	54214.5