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

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

59 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
trunkfishes	21	5	177	(None)
trunkfish	19	4	172	2	trunkfish__
drumfishes	19	4	275	3	dru_mfishes
groundfishes	20	5	161	3	groundfishes
lungfishes	17	4	341	3	_lungfishes
monkfishes	22	4	374	3	_monkfishes
rockfishes	22	6	351	3	_rockfishes
suckfishes	22	4	343	3	_suckfishes
sunfishes	15	4	703	3	_sun_fishes
tundishes	13	4	454	3	t_un_dishes
blackfishes	25	4	350	4	blackfishes
blindfishes	20	5	258	4	blindfishes
bluefishes	18	4	431	4	blu_efishes
bonefishes	18	4	491	4	_bonefishes
brandishes	16	4	589	4	bran_dishes
burnishes	14	3	664	4	burn__ishes
clingfishes	20	5	254	4	clingfishes
crampfishes	23	5	226	4	crampfishes
crawfishes	21	4	359	4	cr_awfishes
crayfishes	21	4	340	4	cr_ayfishes
finfishes	18	4	604	4	_fin_fishes
frogfishes	20	4	332	4	fr_ogfishes
frostfishes	20	5	227	4	frostfishes
furnishes	15	3	623	4	furn__ishes
grayfishes	20	4	363	4	gr_ayfishes
jackfishes	29	4	376	4	_jackfishes
kingfishes	21	4	370	4	_kingfishes
lionfishes	16	4	354	4	lion_fishes
lumpfishes	20	4	287	4	_lumpfishes
milkfishes	22	4	312	4	_milkfishes
moonfishes	18	4	419	4	moon_fishes
mudfishes	18	4	419	4	_mu_dfishes
numbfishes	20	4	278	4	_numbfishes
outfishes	15	11	802	4	_ou_tfishes
panfishes	17	3	759	4	_pan_fishes
pinfishes	17	4	624	4	_pin_fishes
punishes	13	3	811	4	_pun__ishes
pupfishes	19	4	431	4	_pu_pfishes
ratfishes	15	4	610	4	_r_atfishes
redfishes	16	4	579	4	_r_edfishes
rosefishes	16	4	411	4	_rosefishes
rubbishes	16	4	430	4	_ru_bbishes
sandfishes	17	4	554	4	_sandfishes
squawfishes	29	5	204	4	squawfishes
stockfishes	23	5	288	4	stockfishes
stonefishes	17	5	371	4	stonefishes
studfishes	17	10	379	4	stu_dfishes
surffishes	19	8	407	4	_surffishes
tarnishes	12	18	889	4	tarn__ishes
tilefishes	16	4	460	4	t_ilefishes
toadfishes	17	4	379	4	t_oadfishes
transfixes	20	4	647	4	transfi_xes
transfuses	13	4	674	4	transfus_es
trucklines	16	4	429	4	truckli_nes
trunkfuls	16	11	228	4	trunkf__uls
turkoises	13	4	363	4	t_urkois_es
unfished	15	21	829	4	__un_fished
unwishes	14	14	748	4	__un_wishes
weakfishes	23	4	335	4	_weakfishes

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.436	409841.7
2	DLD Change Limit	148819	59	9.266	16060.8
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	9.732	18361.2