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

Here are the results of your fuzzy-string dictionary search for “flopover” with Change Limit: [1] [2] [3] [4]

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.

72 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
flopover	16	4	286	(None)
flopovers	17	4	256	1	flopovers
flooder	11	25	846	2	flo_oder
floorer	10	24	807	2	flo_orer
flopper	14	32	847	2	flop_per
floppier	15	5	463	2	floppier
flyover	16	3	351	2	fl_yover
popover	14	9	584	2	_popover
slipover	13	4	383	2	slipover
stopover	13	4	406	2	stopover
allover	10	3	858	3	al_lover
bloomer	11	41	981	3	blo_omer
blooper	11	35	853	3	blo_oper
clover	11	46	1712	3	cl__over
eloper	8	54	1415	3	elop__er
flapper	14	35	920	3	flap_per
flappier	15	4	429	3	flappier
flashover	18	4	313	3	flashover
flavorer	14	5	455	3	flavorer
flipper	14	38	914	3	flip_per
flivver	16	3	304	3	fl_ivver
floater	10	44	1335	3	flo_ater
floatier	11	3	698	3	floatier
flockier	17	4	534	3	flockier
flogger	12	44	946	3	flo_gger
flooded	12	30	793	3	flo_oded
flooders	12	25	783	3	flo_oders
flooey	12	39	1017	3	flo_o_ey
flooie	9	37	1215	3	flo_oie_
floor	8	42	1523	3	flo_o__r
floored	11	26	868	3	flo_ored
floorers	11	22	757	3	flo_orers
flopped	15	33	876	3	flop_ped
floppers	15	33	746	3	flop_pers
floppies	15	4	681	3	floppies
flosser	10	33	969	3	flo_sser
flossier	11	32	697	3	flossier
flounder	12	3	510	3	flounder
flouter	10	43	1134	3	flo_uter
flower	12	48	1550	3	fl__ower
flowerer	14	3	545	3	flowerer
flyovers	17	3	367	3	fl_yovers
flypaper	18	4	222	3	flypaper
follower	14	13	707	3	follower
footer	9	43	2077	3	f_o_oter
forever	13	3	895	3	f_orever
gloppier	13	5	467	3	gloppier
glover	10	45	1353	3	gl__over
groover	11	35	854	3	gro_over
holdover	15	4	408	3	holdover
hoover	12	43	1443	3	_ho_over
layover	13	3	443	3	_layover
looker	10	48	1695	3	_lo_oker
looper	8	38	1711	3	_lo_oper
loopier	9	37	1119	3	_loopier
looser	6	52	1994	3	_lo_oser
looter	6	42	2232	3	_lo_oter
loper	7	51	2923	3	_lop__er
lopper	10	37	1720	3	_lop_per
loppier	11	36	972	3	_loppier
louver	9	41	1039	3	_lo_uver
lover	8	55	2645	3	_l__over
plover	11	53	1261	3	pl__over
popovers	15	9	566	3	_popovers
proposer	12	18	1063	3	proposer
rollover	11	4	445	3	rollover
sleepover	14	4	259	3	sleepover
slipcover	16	4	209	3	slipcover
slipovers	14	4	346	3	slipovers
sloper	8	46	1591	3	slop__er
sloppier	12	5	570	3	sloppier
stopovers	14	4	383	3	stopovers

Search took 7 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	146162	0.406	440125.6
2	DLD Change Limit	146162	72	6.326	23105.0
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	6.765	26414.0