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

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

109 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
gelder	8	46	1371	(None)
elder	6	40	2002	1	_elder
gelded	9	45	1211	1	gelded
gelders	9	38	1257	1	gelders
gender	8	35	1793	1	gender
gilder	8	44	1553	1	gilder
golder	8	44	1760	1	golder
melder	9	39	1581	1	melder
welder	10	29	1441	1	welder
alder	6	54	2191	2	_alder
aulder	7	5	1145	2	aulder
balder	9	53	1886	2	balder
beader	9	46	2379	2	beader
bedder	10	42	1579	2	bedder
belier	8	44	2356	2	belier
belter	8	47	2096	2	belter
bender	9	52	2330	2	bender
bolder	9	48	2093	2	bolder
ceder	8	53	2224	2	ce_der
colder	9	51	2185	2	colder
deader	8	42	2047	2	deader
deluder	9	16	833	2	deluder
delver	10	49	1349	2	delver
eelier	6	42	1646	2	eelier
eider	6	46	2474	2	_eider
elders	7	48	1730	2	_elders
eluder	7	37	1221	2	_eluder
elver	8	52	1624	2	_elver
ender	6	43	2586	2	_ender
feeder	10	35	1384	2	feeder
feller	9	44	1955	2	feller
fender	10	37	1872	2	fender
fielder	11	21	741	2	fielder
folder	10	43	1754	2	folder
gadder	9	37	1471	2	gadder
gander	8	43	2276	2	gander
geezer	16	27	801	2	geezer
geld	6	58	2843	2	geld__
gelds	7	51	1834	2	geld_s
gelee	6	36	2698	2	gel_ee
gelees	7	41	1626	2	gelees
gelled	8	47	1889	2	gelled
genders	9	36	1678	2	genders
geode	7	4	1259	2	geode_
geodes	8	4	1215	2	geodes
getter	7	41	1761	2	getter
geyser	10	3	651	2	geyser
gilded	9	44	1322	2	gilded
gilders	9	42	1246	2	gilders
giller	7	45	1973	2	giller
girder	8	43	1206	2	girder
glede	7	55	1783	2	glede_
gledes	8	49	1513	2	gledes
glider	8	46	1426	2	glider
gluer	6	51	1677	2	g_luer
golden	8	44	1115	2	golden
golfer	10	44	1118	2	golfer
grader	8	49	1969	2	grader
guider	8	43	1352	2	guider
guilder	9	4	591	2	guilder
gulden	8	32	876	2	gulden
gulper	9	34	1021	2	gulper
header	10	44	2254	2	header
heder	9	56	2364	2	he_der
heeder	10	42	1604	2	heeder
heller	9	33	2251	2	heller
helper	11	43	1309	2	helper
herder	10	45	1646	2	herder
holder	10	46	1965	2	holder
kelter	10	32	1438	2	kelter
leader	7	48	2465	2	leader
lender	7	39	2127	2	lender
lewder	10	47	961	2	lewder
melded	10	47	1471	2	melded
melders	10	32	1391	2	melders
melter	8	35	2011	2	melter
mender	9	35	2079	2	mender
milder	9	38	1845	2	milder
molder	9	38	1927	2	molder
needer	7	36	1495	2	needer
older	6	51	2117	2	_older
pedler	9	36	1462	2	pedler
pelter	8	33	2162	2	pelter
polder	9	40	1925	2	polder
reader	7	36	2829	2	reader
redder	8	39	1814	2	redder
relier	6	58	2618	2	relier
render	7	40	2414	2	render
seder	6	48	2676	2	se_der
seeder	7	43	2077	2	seeder
seller	6	38	2460	2	seller
sender	7	38	2441	2	sender
solder	7	39	2134	2	solder
tedder	8	33	1216	2	tedder
telfer	9	37	989	2	telfer
teller	6	35	1982	2	teller
tender	7	41	2184	2	tender
vender	10	34	1842	2	vender
wedder	11	36	1230	2	wedder
weeder	10	33	1551	2	weeder
welded	11	40	1338	2	welded
welders	11	33	1341	2	welders
weldor	10	31	765	2	weldor
welter	9	34	1738	2	welter
wielder	11	19	767	2	wielder
wilder	10	36	1647	2	wilder
yeller	9	42	1451	2	yeller
yelper	11	45	878	2	yelper
yielder	11	17	511	2	yielder

Search took 3 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.346	516448.0
2	DLD Change Limit	82551	109	2.420	34112.0
3	Display Results	109	109	0.033	3303.0
	(SQL Overall)	178691	109	2.799	63841.0