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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

190 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
gander	8	43	2276	(None)
bander	9	39	2822	1	bander
dander	8	112	2299	1	dander
gadder	9	37	1471	1	gadder
ganders	9	35	2170	1	ganders
ganger	8	37	2146	1	ganger
gender	8	35	1793	1	gender
grander	9	33	1587	1	grander
hander	10	45	2643	1	hander
lander	7	40	2848	1	lander
pander	9	37	2552	1	pander
sander	7	48	2853	1	sander
wander	10	44	2371	1	wander
zander	16	34	1711	1	zander
adder	7	54	1959	2	_adder
aider	6	54	3113	2	_aider
alder	6	54	2191	2	_alder
anger	6	62	2587	2	_anger
badder	10	38	1751	2	badder
balder	9	53	1886	2	balder
banded	10	52	2317	2	banded
banders	10	43	2456	2	banders
banger	9	44	2363	2	banger
banker	12	42	2273	2	banker
banner	8	44	2150	2	banner
banter	8	48	2533	2	banter
bender	9	52	2330	2	bender
binder	9	44	2287	2	binder
blander	10	37	1516	2	blander
bonder	9	53	2478	2	bonder
brander	10	39	1582	2	brander
cancer	10	42	2092	2	cancer
candler	10	35	1659	2	candler
candor	9	45	1642	2	candor
caner	7	53	3477	2	can_er
canker	12	44	2252	2	canker
canner	8	46	2598	2	canner
canoer	8	51	2107	2	canoer
canter	8	52	3011	2	canter
carder	9	45	2418	2	carder
cinder	9	41	1912	2	cinder
dancer	9	48	1761	2	dancer
danders	9	39	2118	2	danders
dandier	9	37	1457	2	dandier
dandler	9	44	1427	2	dandler
danger	8	37	2282	2	danger
danker	11	43	1966	2	danker
daunder	9	34	889	2	daunder
ender	6	43	2586	2	_ender
fader	9	44	2151	2	fa_der
fanner	9	42	1818	2	fanner
fender	10	37	1872	2	fender
finder	10	40	2023	2	finder
fonder	10	41	2006	2	fonder
funder	10	40	1608	2	funder
gabber	11	49	1660	2	gabber
gadded	10	39	1317	2	gadded
gadders	10	36	1150	2	gadders
gaffer	13	43	1013	2	gaffer
gager	7	47	2629	2	ga_ger
gagger	9	50	1651	2	gagger
gainer	7	41	1749	2	gainer
gaiter	7	38	1950	2	gaiter
gamer	8	49	2894	2	ga_mer
gamier	9	36	1793	2	gamier
gammer	11	123	1833	2	gammer
gandered	11	22	1117	2	gandered
gane	5	51	4529	2	gan_e_
ganef	9	63	2246	2	gan_ef
ganev	9	55	1386	2	gan_ev
ganged	9	46	1919	2	ganged
gangers	9	44	1860	2	gangers
gannet	7	43	2185	2	gannet
gaoler	7	39	1357	2	gaoler
gaper	8	61	2512	2	ga_per
garden	8	42	1508	2	garden
garner	7	39	1700	2	garner
garter	7	44	2051	2	garter
gasher	10	43	2037	2	gasher
gasper	9	45	1554	2	gasper
gasser	7	50	1777	2	gasser
gaster	7	50	2735	2	gaster
gater	6	45	3364	2	ga_ter
gather	10	41	1585	2	gather
gaudery	12	3	474	2	gaudery
gaudier	9	3	845	2	gaudier
gauger	8	47	1485	2	gauger
gaunter	8	29	1071	2	gaunter
gawker	14	55	935	2	gawker
gawper	12	49	969	2	gawper
gaydar	11	3	550	2	gaydar
gayer	9	45	1919	2	ga_yer
gazer	15	57	2007	2	ga_zer
gelder	8	46	1371	2	gelder
genders	9	36	1678	2	genders
gilder	8	44	1553	2	gilder
ginger	8	49	2002	2	ginger
ginner	7	39	1581	2	ginner
girder	8	43	1206	2	girder
gladder	10	39	831	2	gladder
glancer	10	37	1007	2	glancer
glanders	10	38	1150	2	glanders
glandes	9	54	1383	2	glandes
glider	8	46	1426	2	glider
gnawer	10	38	695	2	gnawer
golder	8	44	1760	2	golder
goner	6	60	2515	2	gon_er
grader	8	49	1969	2	grader
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
guarder	9	3	646	2	guarder
guider	8	43	1352	2	guider
gunner	7	38	1398	2	gunner
handed	11	49	1998	2	handed
handers	11	42	2433	2	handers
handier	11	38	1744	2	handier
handler	11	35	1616	2	handler
hanger	10	40	2325	2	hanger
hanker	13	46	2209	2	hanker
harder	10	50	2240	2	harder
hinder	10	41	2006	2	hinder
kinder	11	37	1684	2	kinder
ladder	8	46	1762	2	ladder
lader	6	56	3372	2	la_der
lancer	8	43	1997	2	lancer
landed	8	46	1924	2	landed
landers	8	40	2621	2	landers
landler	8	41	1320	2	landler
lanker	10	41	2300	2	lanker
lanner	6	49	2059	2	lanner
larder	7	37	2097	2	larder
lauder	7	38	1501	2	lauder
launder	8	30	914	2	launder
lender	7	39	2127	2	lender
madder	10	35	1559	2	madder
manger	9	43	2500	2	manger
manner	8	40	2051	2	manner
maunder	10	32	868	2	maunder
meander	10	4	997	2	meander
mender	9	35	2079	2	mender
minder	9	48	2250	2	minder
padder	10	34	1549	2	padder
panders	10	34	2373	2	panders
panier	8	44	2550	2	panier
panner	8	42	2476	2	panner
panzer	17	42	1323	2	panzer
pinder	9	45	2345	2	pinder
ponder	9	45	2169	2	ponder
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
sadder	8	29	1697	2	sadder
sanded	8	49	2061	2	sanded
sanders	8	40	2594	2	sanders
sandier	8	40	1784	2	sandier
saner	5	43	3432	2	san_er
sanger	7	45	2456	2	sanger
sender	7	38	2441	2	sender
slander	8	40	1544	2	slander
sonder	7	36	2352	2	sonder
stander	8	43	1616	2	stander
sunder	7	40	1982	2	sunder
tandem	9	3	1140	2	tandem
tanker	10	45	2112	2	tanker
tanner	6	37	2228	2	tanner
tender	7	41	2184	2	tender
tinder	7	38	2180	2	tinder
under	6	46	2421	2	_under
vanner	9	42	1584	2	vanner
vender	10	34	1842	2	vender
wadder	11	42	1548	2	wadder
wader	9	53	2536	2	wa_der
wanders	11	42	2133	2	wanders
wanier	9	39	2068	2	wanier
wanker	13	42	1997	2	wanker
wanner	9	40	1962	2	wanner
wanter	9	44	2305	2	wanter
warder	10	40	2027	2	warder
winder	10	40	2526	2	winder
wonder	10	36	1781	2	wonder
yarder	10	38	1397	2	yarder
yonder	10	32	1413	2	yonder
zanders	17	30	1579	2	zanders
zanier	15	43	1471	2	zanier

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	82551	0.126	1418182.5
2	DLD Change Limit	82551	190	2.796	29524.7
3	Display Results	190	190	0.060	3166.7
	(SQL Overall)	178691	190	2.982	59923.2