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

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

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.

64 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
floater	10	44	1335	(None)
bloater	9	40	1342	1	bloater
floated	11	33	1270	1	floated
floatel	10	30	801	1	floatel
floaters	11	27	1151	1	floaters
floatier	11	3	698	1	floatier
flouter	10	43	1134	1	flouter
gloater	8	37	1101	1	gloater
bleater	9	45	1530	2	bleater
bloated	10	45	1343	2	bloated
bloaters	10	33	1102	2	bloaters
blotter	9	46	1285	2	blotter
boater	8	46	2209	2	_boater
clouter	9	35	1169	2	clouter
coater	8	43	2957	2	_coater
elater	6	47	2420	2	el_ater
feater	9	52	2405	2	f_eater
flaker	13	49	1617	2	fl_aker
flamer	11	49	1912	2	fl_amer
flatter	10	38	1596	2	flatter
flayer	12	47	1356	2	fl_ayer
fleeter	10	32	1036	2	fleeter
flirter	10	31	867	2	flirter
flitter	10	34	1390	2	flitter
float	8	59	2857	2	float__
floatels	11	29	566	2	floatels
floats	9	68	1625	2	float_s
floaty	12	42	1094	2	float_y
flogger	12	44	946	2	flogger
flooder	11	25	846	2	flooder
floorer	10	24	807	2	floorer
flopper	14	32	847	2	flopper
flosser	10	33	969	2	flosser
flouted	11	32	1081	2	flouted
flouters	11	41	927	2	flouters
flower	12	48	1550	2	flo_wer
fluster	10	39	1306	2	fluster
fluter	9	53	1686	2	fl_uter
flutter	10	40	1209	2	flutter
foamer	11	47	1431	2	f_oamer
folate	9	33	2039	2	folate_
folates	10	32	1845	2	folates
footer	9	43	2077	2	f_ooter
foster	9	43	2222	2	f_oster
frater	9	45	2059	2	f_rater
fronter	10	36	1158	2	fronter
gloated	9	35	1153	2	gloated
gloaters	9	28	886	2	gloaters
later	5	48	4392	2	_l_ater
loader	7	43	1631	2	_loader
loafer	9	36	1094	2	_loafer
loaner	6	44	1650	2	_loaner
loather	10	37	1100	2	_loather
locater	9	31	1360	2	_locater
lofter	9	46	1472	2	_lofter
loiter	6	46	1917	2	_loiter
looter	6	42	2232	2	_looter
lotter	6	40	2560	2	_lotter
oater	5	54	3373	2	__oater
plater	8	44	2769	2	pl_ater
pleater	9	39	1633	2	pleater
plotter	9	41	1366	2	plotter
slater	6	44	2918	2	sl_ater
slotter	7	33	1445	2	slotter

Search took 4 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	107671	0.140	1276364.3
2	DLD Change Limit	107671	64	2.830	38046.3
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	3.000	59563.7