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

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

63 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
devilfishes	21	5	199	(None)
dealfishes	17	4	419	2	de_alfishes
devilfish	19	4	232	2	devilfish__
demolishes	16	8	490	3	demol_ishes
depolishes	16	9	412	3	depol_ishes
devilish	15	4	637	3	devil_ish__
devilishly	20	5	179	3	devil_ishly
devilishness	19	6	238	3	devil_ishness
devilries	13	4	525	3	devilri__es
jewelfishes	27	5	178	3	jewelfishes
sailfishes	16	4	464	3	_sailfishes
angelfishes	18	6	269	4	angelfishes
baitfishes	18	4	405	4	_baitfishes
billfishes	18	4	425	4	_billfishes
cavefishes	21	4	386	4	cav_efishes
civilises	14	10	609	4	civil_is_es
coalfishes	18	4	469	4	_coalfishes
damselfishes	21	5	124	4	damselfishes
dealfish	15	4	550	4	de_alfish__
debilities	13	4	1129	4	debil_ities
decilitres	13	4	499	4	decil_itres
deifies	11	33	1745	4	de_i_fi__es
deixises	16	3	569	4	de_i_xis_es
demolished	17	9	452	4	demol_ished
demolisher	16	9	364	4	demol_isher
demolishers	17	9	258	4	demol_ishers
depolished	17	10	361	4	depol_ished
dervishes	16	4	493	4	de__rvishes
devilkins	17	4	280	4	devilki__ns
deviltries	14	4	413	4	devil_tries
devisees	12	35	828	4	dev___isees
devises	11	41	1676	4	dev___is_es
devitrifies	18	5	287	4	devitrifies
diminishes	16	4	497	4	dimi_nishes
divinises	13	6	701	4	divi_nis_es
dogfishes	17	4	508	4	d__ogfishes
drumfishes	19	4	275	4	d_rumfishes
englishes	13	4	510	4	_engl_ishes
evanishes	15	4	560	4	_ev_anishes
evilnesses	13	4	600	4	_evilnesses
fallfishes	19	4	398	4	_fallfishes
filefishes	19	4	448	4	__filefishes
finfishes	18	4	604	4	__finfishes
foolfishes	19	4	376	4	_foolfishes
headfishes	20	4	441	4	he_adfishes
jellyfishes	27	8	184	4	jellyfishes
jewfishes	25	4	338	4	je__wfishes
killifishes	21	5	204	4	killifishes
milkfishes	22	4	312	4	__milkfishes
needlefishes	19	5	137	4	needlefishes
overfishes	19	4	701	4	_overfishes
pigfishes	18	4	500	4	__pigfishes
pinfishes	17	4	624	4	__pinfishes
redfishes	16	4	579	4	re__dfishes
refinishes	16	4	469	4	refi_nishes
relishes	11	3	1195	4	re__l_ishes
repolishes	15	10	510	4	repol_ishes
revarnishes	17	4	279	4	revarnishes
shellfishes	20	5	258	4	shellfishes
swellfishes	20	5	214	4	swellfishes
tilefishes	16	4	460	4	__tilefishes
weakfishes	23	4	335	4	we_akfishes
zebrafishes	28	5	127	4	zebrafishes

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.423	422437.4
2	DLD Change Limit	148819	63	8.703	17099.7
3	Display Results	63	63	0.030	2100.0
	(SQL Overall)	178691	63	9.156	19516.3