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

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

100 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
globes	9	43	1454	(None)
glebes	9	55	1224	1	glebes
globe	8	49	1701	1	globe_
globed	10	48	1176	1	globed
globs	8	56	1640	1	glob_s
gloves	10	41	1518	1	gloves
glozes	16	43	1335	1	glozes
lobes	7	53	3100	1	_lobes
adobes	9	44	1153	2	adobes
aloes	5	49	3367	2	alo_es
blobs	9	56	2003	2	blob_s
blokes	12	38	1388	2	blokes
clones	8	45	2656	2	clones
closes	8	54	2559	2	closes
cloves	11	49	1882	2	cloves
clozes	17	49	1556	2	clozes
elopes	8	59	1816	2	elopes
floes	8	55	2814	2	flo_es
galores	8	26	1432	2	galores
gambes	11	63	1831	2	gambes
geodes	8	4	1215	2	geodes
gibes	8	44	2252	2	g_ibes
glaces	9	42	1802	2	glaces
glades	8	48	2034	2	glades
glares	7	55	1886	2	glares
glazes	16	53	1564	2	glazes
glebe	8	50	1644	2	glebe_
gledes	8	49	1513	2	gledes
glees	6	50	2759	2	gl_ees
glides	8	45	1886	2	glides
glimes	9	47	1752	2	glimes
gloams	9	52	1066	2	gloams
gloats	7	45	1542	2	gloats
glob	7	66	2339	2	glob__
global	9	3	766	2	global
globby	14	3	468	2	globby
globin	9	30	972	2	globin
globins	10	27	895	2	globins
globose	10	3	554	2	globose
globous	10	3	650	2	globous
globules	11	3	541	2	globules
gloggs	9	3	503	2	gloggs
gloms	8	52	1978	2	glo_ms
glomus	9	46	809	2	glomus
glooms	9	62	1168	2	glooms
glops	8	56	1955	2	glo_ps
glories	8	19	1591	2	glories
gloss	6	43	1962	2	glo_ss
glosses	8	40	1412	2	glosses
glosts	7	45	1381	2	glosts
glouts	7	44	1471	2	glouts
glove	9	45	1629	2	glove_
gloved	11	48	1187	2	gloved
glover	10	45	1353	2	glover
glovers	11	43	1088	2	glovers
glowed	11	49	1383	2	glowed
glower	10	51	1493	2	glower
glowers	11	34	1209	2	glowers
glows	9	55	1803	2	glo_ws
gloze	15	48	1598	2	gloze_
glozed	17	37	1122	2	glozed
glues	6	51	2568	2	gl_ues
glumes	9	45	1681	2	glumes
glutes	7	45	1767	2	glutes
gnomes	9	38	1297	2	gnomes
gnoses	7	65	1516	2	gnoses
gobies	9	54	1806	2	g_obies
goboes	9	59	1444	2	g_oboes
gobos	8	62	1938	2	g_obos
gobs	7	69	3557	2	g_ob_s
goes	5	56	4409	2	g_o_es
goober	9	39	1174	2	goober
goobers	10	21	962	2	goobers
gooses	7	57	2305	2	gooses
gores	6	57	4037	2	g_ores
goxes	13	50	1826	2	g_oxes
grebes	9	38	1361	2	grebes
gropes	9	52	2040	2	gropes
groves	10	43	1810	2	groves
gybes	11	50	1272	2	g_ybes
lobe	6	55	3536	2	_lobe_
lobed	8	60	2213	2	_lobed
lobos	7	59	2184	2	_lobos
lobs	6	64	4108	2	_lob_s
lodes	6	64	3691	2	_lodes
loges	6	65	3420	2	_loges
lopes	7	64	3734	2	_lopes
lores	5	50	4540	2	_lores
loses	5	67	4201	2	_loses
loves	8	53	3201	2	_loves
lowes	8	57	3246	2	_lowes
loxes	12	52	2747	2	_loxes
lubes	7	47	2799	2	_lubes
obes	6	60	3683	2	__obes
plebes	10	43	1362	2	plebes
probes	10	41	1945	2	probes
robes	7	51	3330	2	_robes
slobs	7	44	1987	2	slob_s
sloes	5	47	2887	2	slo_es
slopes	8	48	2045	2	slopes

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.360	496363.9
2	DLD Change Limit	82551	100	2.470	33421.5
3	Display Results	100	100	0.030	3333.3
	(SQL Overall)	178691	100	2.860	62479.4