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

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

57 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
kingfishers	22	5	171	(None)
kingfisher	21	5	224	1	kingfisher_
kingfishes	21	4	370	1	kingfishe_s
clingfishes	20	5	254	3	clingfishe_s
finfishes	18	4	604	3	fin_fishe_s
finishers	15	4	535	3	fin__ishers
kingfish	19	4	449	3	kingfish___
languishers	15	5	259	3	languishers
lungfishes	17	4	341	3	lungfishe_s
pigfishes	18	4	500	3	pi_gfishe_s
pinfishes	17	4	624	3	pin_fishe_s
anguishes	13	4	509	4	_anguishe_s
banishers	14	25	805	4	ban__ishers
billfishes	18	4	425	4	billfishe_s
blindfishes	20	5	258	4	blindfishe_s
bonefishes	18	4	491	4	bonefishe_s
disguisers	12	4	403	4	disguis_ers
dogfishes	17	4	508	4	_dogfishe_s
englishes	13	4	510	4	_englishe_s
extinguishers	24	9	157	4	extinguishers
filefishes	19	4	448	4	filefishe_s
finisher	14	3	630	4	fin__isher_
finishes	14	3	898	4	fin__ishe_s
fishers	13	47	1472	4	____fishers
frogfishes	20	4	332	4	frogfishe_s
hagfishes	19	4	515	4	_hagfishe_s
hogfishes	19	4	468	4	_hogfishe_s
infesters	12	23	771	4	_in_festers
infighters	17	4	332	4	_in_fighters
infusers	11	28	614	4	_in_fus_ers
ingathers	13	4	445	4	_ing_athers
insisters	9	9	765	4	_in_sisters
inveighers	17	4	202	4	_inveighers
killifishes	21	5	204	4	killifishe_s
kinglier	13	4	563	4	kingli__er_
kingliness	15	4	395	4	kingli_ness
kingmakers	16	15	280	4	king_makers
kingships	19	4	397	4	king__ships
kingsides	15	4	385	4	kingsi_de_s
knishes	14	3	826	4	k_n__ishe_s
languisher	14	4	307	4	languisher_
languishes	14	4	424	4	languishe_s
lionfishes	16	4	354	4	lionfishe_s
milkfishes	22	4	312	4	milkfishe_s
minishes	13	3	1058	4	min__ishe_s
ministers	11	3	962	4	min__isters
monkfishes	22	4	374	4	monkfishe_s
panfishes	17	3	759	4	pan_fishe_s
pipefishes	20	4	379	4	pipefishe_s
punishers	14	3	497	4	pun__ishers
ringmasters	14	13	280	4	ringmasters
sandfishes	17	4	554	4	sandfishe_s
skirmishers	20	5	123	4	ski_rmishers
sunfishes	15	4	703	4	sun_fishe_s
tilefishes	16	4	460	4	tilefishe_s
vanishers	15	18	661	4	van__ishers
vanquishers	26	5	178	4	vanquishers

Search took 9 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	57	8.233	18075.9
3	Display Results	57	57	0.033	1727.3
	(SQL Overall)	178691	57	8.702	20534.5