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

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

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.

76 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
globefishes	20	5	231	(None)
globefish	18	4	247	2	globefish__
goosefishes	18	5	229	2	goosefishes
blowfishes	21	4	346	3	blo_wfishes
bluefishes	18	4	431	3	bl_uefishes
bonefishes	18	4	491	3	_bonefishes
gibberishes	19	5	172	3	gibberishes
globalises	13	5	459	3	globalis_es
goatfishes	17	4	393	3	g_oatfishes
goldfishes	18	6	356	3	g_oldfishes
rosefishes	16	4	411	3	_rosefishes
stonefishes	17	5	371	3	stonefishes
blackfishes	25	4	350	4	blackfishes
blemishes	16	6	508	4	bl__emishes
blindfishes	20	5	258	4	blindfishes
boarfishes	18	4	497	4	_boarfishes
boxfishes	24	4	415	4	_bo_xfishes
cavefishes	21	4	386	4	_cavefishes
clingfishes	20	5	254	4	clingfishes
closefisted	17	10	117	4	closefisted
coalfishes	18	4	469	4	_coalfishes
codfishes	18	4	564	4	_co_dfishes
cowfishes	20	4	572	4	_co_wfishes
dogfishes	17	4	508	4	_do_gfishes
filefishes	19	4	448	4	_filefishes
flatfishes	19	4	399	4	fl_atfishes
flemishes	17	6	524	4	fl__emishes
flourishes	16	4	429	4	flo_urishes
foolfishes	19	4	376	4	_foolfishes
foxfishes	25	4	405	4	_fo_xfishes
frogfishes	20	4	332	4	fro_gfishes
frostfishes	20	5	227	4	frostfishes
garfishes	16	16	708	4	g__arfishes
globalise	12	4	515	4	globalis_e_
globalised	14	4	321	4	globalis_ed
globalisms	15	4	438	4	globalis_ms
globalists	13	4	469	4	globalis_ts
globalizes	22	4	464	4	globali_zes
globeflower	20	6	116	4	globeflower
globeflowers	21	6	111	4	globeflowers
globelike	16	4	385	4	globeli_ke_
globosities	14	5	323	4	globosities
glorifies	13	4	636	4	glorifi__es
glottises	10	8	495	4	glo_ttis_es
goosefish	16	4	227	4	goosefish__
goosefleshes	19	6	80	4	goosefleshes
grayfishes	20	4	363	4	g_rayfishes
groundfishes	20	5	161	4	groundfishes
hogfishes	19	4	468	4	_ho_gfishes
ladyfishes	20	5	284	4	_ladyfishes
lionfishes	16	4	354	4	_lionfishes
lobefins	13	4	482	4	_lobefi__ns
lobelines	11	3	856	4	_lobeli_nes
lumpfishes	20	4	287	4	_lumpfishes
lungfishes	17	4	341	4	_lungfishes
monkfishes	22	4	374	4	_monkfishes
moonfishes	18	4	419	4	_moonfishes
numbfishes	20	4	278	4	numb_fishes
oarfishes	15	15	695	4	__oarfishes
obelises	10	3	910	4	__obelis_es
outfishes	15	11	802	4	__outfishes
overfishes	19	4	701	4	__overfishes
pilotfishes	19	6	213	4	pilo_tfishes
pipefishes	20	4	379	4	_pipefishes
platyfishes	22	5	219	4	platyfishes
plenishes	14	8	708	4	pl__enishes
rockfishes	22	6	351	4	_rockfishes
sablefishes	19	5	289	4	sablefishes
snakefishes	21	5	241	4	snakefishes
spadefishes	20	5	269	4	spadefishes
stockfishes	23	5	288	4	stockfishes
swordfishes	21	5	216	4	swordfishes
tilefishes	16	4	460	4	_tilefishes
toadfishes	17	4	379	4	_toadfishes
whitefishes	23	5	264	4	whitefishes
wolffishes	22	4	298	4	_wolffishes

Search took 10 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	148819	0.420	425454.8
2	DLD Change Limit	148819	76	9.343	15928.4
3	Display Results	76	76	0.046	1652.2
	(SQL Overall)	178691	76	9.809	18217.0