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

Here are the results of your fuzzy-string dictionary search for “protosteles” 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
protosteles	13	5	456	(None)
protostele	12	4	507	1	protostele_
protostelic	15	5	360	2	protostelic
protostomes	15	5	580	2	protostomes
monosteles	12	4	557	3	_monosteles
prostyles	14	15	711	3	pr__ostyles
protesters	12	16	938	3	proteste_rs
protostars	12	4	685	3	protost_ars
protostome	14	5	614	3	protostome_
prototypes	17	4	592	3	proto_types
dictyosteles	18	6	87	4	dictyosteles
monostele	11	4	533	4	_monostele_
monostelies	13	5	434	4	_monostelies
photocells	17	5	457	4	photo_cells
photogenes	16	4	888	4	photo_genes
photosets	14	4	783	4	photos_e_ts
photosetter	16	7	472	4	photosetter
photosetters	17	7	392	4	photosetters
photospheres	22	5	580	4	photospheres
photostated	17	6	586	4	photostated
photostats	15	4	706	4	photost_ats
phototaxes	22	4	666	4	photo_taxes
phototubes	17	5	436	4	photo_tubes
phototypes	20	4	651	4	photo_types
potstones	11	4	921	4	p_ot_stones
pottles	9	38	1698	4	p_ot__t_les
prattles	10	18	940	4	prat__t_les
pretastes	11	11	942	4	pretast__es
proboscides	18	6	258	4	proboscides
proboscises	17	6	289	4	proboscises
projectiles	22	4	380	4	projectiles
promisees	13	24	686	4	promis_e_es
promoters	13	3	1009	4	promo_te_rs
promotes	12	3	1412	4	promo_t__es
proposals	13	4	666	4	propos_al_s
proposers	13	22	852	4	propos_e_rs
proposes	12	25	1597	4	propos___es
proptoses	13	4	987	4	proptos___es
prostates	11	3	1442	4	pr__ostates
prostheses	15	4	655	4	pr__ostheses
prosties	10	14	2119	4	pr__ost_ies
prostyle	13	18	727	4	pr__ostyle_
protases	10	21	1503	4	protas___es
protecters	14	16	825	4	protecte_rs
protegees	12	7	539	4	prot_ege_es
proteges	11	4	992	4	pr__o_teges
proteoses	11	22	1101	4	proteos___es
protestants	13	5	455	4	protestants
protested	12	15	911	4	protest__ed
protester	11	15	1048	4	protest__er
protestors	12	16	931	4	protest_ors
protests	10	3	1049	4	protest___s
protheses	14	4	907	4	prot__heses
protistans	12	4	520	4	protist_ans
protists	10	3	1336	4	protist___s
protocoled	15	4	498	4	proto_coled
protocolled	16	5	288	4	protocolled
protocols	13	4	720	4	proto_col_s
protoderms	15	4	440	4	proto_derms
protonates	12	4	1169	4	proto_nates
protostar	11	4	669	4	protost__ar
prototype	16	4	566	4	proto_type_
prototyped	18	4	428	4	proto_typed
protoxides	20	4	628	4	proto_xides
protoxylem	24	6	258	4	proto_xylem
protoxylems	25	5	195	4	protoxylems
protyles	13	24	983	4	pr__o_tyles
proustites	12	4	645	4	pro_ustites
provosts	13	3	608	4	provost___s
roosters	8	35	1466	4	_ro_oste_rs
rootles	7	32	1563	4	_ro_o_t_les
rootstalks	14	5	190	4	_rootstalks
rototills	9	4	344	4	_roto_tills
siphonosteles	18	6	65	4	siphonosteles
troostites	10	4	454	4	tro_ostites
urostyles	12	17	397	4	ur__ostyles

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	76	8.483	17543.2
3	Display Results	76	76	0.050	1520.0
	(SQL Overall)	178691	76	8.969	19923.2