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

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

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

120 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
geodesy	12	3	313	(None)
geodes	8	4	1215	1	geodes_
geode	7	4	1259	2	geode__
geodesic	12	4	356	2	geodesic
abodes	9	44	1751	3	abodes_
aedes	6	46	2515	3	ae_des_
anodes	7	44	1876	3	anodes_
bodes	8	49	3510	3	_bodes_
cedes	8	49	2733	3	ce_des_
codes	8	62	4729	3	_codes_
deadest	9	30	1488	3	deadest
decodes	11	39	1498	3	decodes_
diodes	8	39	1578	3	diodes_
egoless	8	3	698	3	egoless
eldest	7	29	1268	3	_eldest
epodes	9	43	1556	3	epodes_
erodes	7	48	1988	3	erodes_
feodary	14	4	471	3	feodary
feods	9	95	1685	3	feod_s_
gaudery	12	3	474	3	gaudery
geds	6	67	3081	3	ge_d_s_
geeky	13	47	1073	3	ge__eky
gees	5	56	4788	3	ge__es_
geese	6	43	1600	3	ge__ese
geest	6	48	2962	3	ge__est
gelded	9	45	1211	3	gelde_d
gelder	8	46	1371	3	gelde_r
gelders	9	38	1257	3	gelders
gelds	7	51	1834	3	geld_s_
gelees	7	41	1626	3	gelees_
gemotes	10	37	1214	3	gemotes_
gender	8	35	1793	3	gende_r
genders	9	36	1678	3	genders
genes	6	51	3309	3	ge_nes_
genies	7	53	2494	3	genies_
genomes	10	36	1170	3	genomes_
genres	7	55	1562	3	genres_
gentes	7	53	2416	3	gentes_
geodesics	13	4	284	3	geodesics
geodesies	11	4	459	3	geodesies
geodesist	11	8	382	3	geodesist
geodetic	12	4	632	3	geodetic
geodic	10	4	800	3	geod_ic
geoduck	15	4	246	3	geoduck
geognosy	13	4	120	3	geognosy
geoids	8	36	984	3	geoids_
geology	12	25	732	3	geology
geometry	14	4	539	3	geometry
gestes	7	57	2139	3	gestes_
glades	8	48	2034	3	glades_
gledes	8	49	1513	3	gledes_
glides	8	45	1886	3	glides_
globes	9	43	1454	3	globes_
glossy	10	54	900	3	glo_ssy
gloves	10	41	1518	3	gloves_
glozes	16	43	1335	3	glozes_
gnomes	9	38	1297	3	gnomes_
gnoses	7	65	1516	3	gnoses_
goddess	10	3	526	3	goddess
godet	7	5	3004	3	g_ode_t
godets	8	4	1093	3	g_odets
godless	9	3	840	3	g_odless
godly	10	49	1329	3	g_od_ly
gods	6	54	3804	3	g_od_s_
goes	5	56	4409	3	g_o_es_
goldest	9	24	1117	3	goldest
goodby	13	40	628	3	good_by
goodbys	14	35	417	3	goodbys
goodies	9	35	1699	3	goodies_
goodish	12	3	796	3	goodish
goodly	11	41	930	3	good_ly
goodness	10	3	625	3	goodness
goods	7	51	2448	3	good_s_
goody	10	56	2039	3	good__y
gooey	9	55	2286	3	g_ooe_y
gooiest	8	28	1388	3	gooiest
gooney	10	66	1231	3	goone_y
gooneys	11	40	707	3	gooneys
gooses	7	57	2305	3	gooses_
goosey	10	59	1351	3	goose_y
goosy	9	60	1888	3	g_o_osy
gores	6	57	4037	3	g_ores_
gorsy	9	59	1578	3	g_o_rsy
goxes	13	50	1826	3	g_oxes_
grades	8	49	2631	3	grades_
grides	8	44	2236	3	grides_
grocery	13	33	676	3	grocery
grodiest	10	3	1055	3	grodiest
grody	10	34	1206	3	grod__y
gropes	9	52	2040	3	gropes_
groves	10	43	1810	3	groves_
gudes	7	45	2081	3	g_udes_
guides	8	41	1828	3	guides_
heresy	12	50	1123	3	he_resy
heydey	16	3	463	3	heyde_y
heydeys	17	3	286	3	heydeys
leones	6	44	1772	3	leones_
leudes	7	53	1409	3	leudes_
lewdest	11	3	628	3	lewdest
lodes	6	64	3691	3	_lodes_
merdes	9	45	1860	3	merdes_
modes	8	55	3741	3	_modes_
modest	9	38	1845	3	_modest
modesty	13	47	698	3	_modesty
neoteny	10	4	502	3	neoteny
nodes	6	46	3349	3	_nodes_
odes	5	72	4324	3	__odes_
pedes	8	53	2729	3	pe_des_
peones	8	38	2104	3	peones_
phoresy	15	3	465	3	phoresy
poesy	10	50	1406	3	_po_esy
recodes	10	29	1863	3	recodes_
reddest	9	3	1195	3	reddest
redefy	13	38	876	3	re_defy
redeny	10	27	1273	3	re_deny
redes	6	51	3913	3	re_des_
redoes	7	46	2377	3	redoes_
rodes	6	140	3908	3	_rodes_
spodes	9	48	1743	3	spodes_
woodsy	13	50	592	3	wood_sy

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	120	6.220	21547.7
3	Display Results	120	120	0.046	2608.7
	(SQL Overall)	178691	120	6.672	26782.2