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

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

79 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
flourishers	17	5	238	(None)
flourisher	16	4	305	1	flourisher_
flourishes	16	4	429	1	flourishe_s
flourished	17	4	311	2	flourishe_d
nourishers	13	8	363	2	_nourishers
flourish	14	4	675	3	flourish___
flourishing	18	5	256	3	flourishing
fluorescers	16	9	270	3	fluorescers
flushers	14	27	973	3	fl_u__shers
furbishers	18	4	309	3	f__urbishers
furnishers	16	4	363	3	f__urnishers
nourisher	12	7	448	3	_nourisher_
nourishes	12	11	673	3	_nourishe_s
abolishers	15	4	318	4	abo_lishers
blandishers	17	4	300	4	blandishers
blemishers	17	6	301	4	bl_emishers
blowfishes	21	4	346	4	blowfishe_s
blushers	13	39	1129	4	bl_u__shers
burnishers	15	4	370	4	__burnishers
cherishers	18	5	455	4	_cherishers
choristers	15	8	610	4	cho_risters
cloisters	11	3	743	4	clo__isters
couriers	10	32	1317	4	_couri__ers
coursers	10	44	1230	4	_cour_s_ers
finishers	15	4	535	4	f__inishers
fishers	13	47	1472	4	f____ishers
flashers	14	39	1265	4	fl___ashers
flatfishes	19	4	399	4	flatfishe_s
flemishes	17	6	524	4	fl_emishe_s
fleshers	14	33	944	4	fl___eshers
floorers	11	22	757	4	floor___ers
floorshows	19	5	157	4	floor_shows
floridness	14	4	377	4	flo_ridness
florigens	13	13	386	4	flo_ri_gens
floristry	15	4	271	4	flo_ris_try
florists	11	3	881	4	flo_ris__ts
flossers	11	30	786	4	flo___ssers
flounders	13	7	461	4	flou__nders
flourless	12	4	353	4	flour__less
flouters	11	41	927	4	flou___ters
fluorescer	15	8	319	4	fluorescer_
fluoresces	15	7	386	4	fluoresce_s
fluorides	13	4	582	4	fluori_de_s
fluorimeters	17	10	243	4	fluorimeters
fluorines	12	4	755	4	fluori_ne_s
fluorites	12	5	716	4	fluori_te_s
fluoroses	12	4	494	4	fluoros_e_s
fluorspars	15	12	191	4	fluor_spars
flusher	13	30	1227	4	fl_u__sher_
flushes	13	41	1414	4	fl_u__she_s
flusters	11	38	1150	4	fl_u__sters
foolfishes	19	4	376	4	foolfishe_s
foolisher	15	4	422	4	f_oolisher_
foreseers	12	3	740	4	f_o_reseers
foresters	12	3	1253	4	f_o_resters
foxfishes	25	4	405	4	f_oxfishe_s
friskers	15	33	737	4	f___riskers
frogfishes	20	4	332	4	frogfishe_s
furbisher	17	4	370	4	f__urbisher_
furbishes	17	4	524	4	f__urbishe_s
furnisher	15	4	452	4	f__urnisher_
furnishes	15	3	623	4	f__urnishe_s
furthers	14	3	649	4	f__ur_thers
glorifiers	14	4	259	4	glo_rifiers
lavishers	15	6	464	4	_l_avishers
lorimers	10	3	661	4	_lo_ri_mers
loriners	8	3	996	4	_lo_ri_ners
lorises	7	39	1859	4	_lo_ris_e_s
loutishness	14	4	454	4	_loutishness
lowriders	13	4	318	4	_lowri_ders
lurchers	13	30	715	4	_l_ur_chers
nourished	13	7	460	4	_nourishe_d
planishers	15	8	477	4	pl_anishers
pleurisies	12	4	317	4	pleurisie_s
ploughers	15	19	392	4	plou__ghers
polishers	14	7	760	4	_po_lishers
punishers	14	3	497	4	__punishers
refurbishers	20	10	171	4	refurbishers
slouchers	14	18	562	4	slou__chers

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.406	440125.6
2	DLD Change Limit	148819	79	8.250	18038.7
3	Display Results	79	79	0.046	1717.4
	(SQL Overall)	178691	79	8.702	20534.5