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

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

68 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
floating	12	31	1188	(None)
bloating	11	35	1281	1	bloating
flouting	12	26	1047	1	flouting
gloating	10	26	1146	1	gloating
bleating	11	35	1450	2	bleating
blotting	11	39	1043	2	blotting
boating	10	37	2130	2	_boating
cleating	11	35	1813	2	cleating
cloaking	15	29	971	2	cloaking
clotting	11	31	1064	2	clotting
clouting	11	30	1168	2	clouting
coating	10	35	2531	2	_coating
doating	9	38	1686	2	_doating
elating	8	34	2308	2	el_ating
fating	10	53	2867	2	f__ating
fellating	13	3	924	2	fellating
filiating	13	3	924	2	filiating
fixating	19	3	618	2	fixating
flaking	15	41	1449	2	fl_aking
flaming	13	42	1644	2	fl_aming
flaring	11	41	1680	2	fl_aring
flatling	12	34	1001	2	fl_atling
flatting	12	35	1125	2	flatting
flawing	14	38	1256	2	fl_awing
flaying	14	39	1446	2	fl_aying
fleeting	12	29	1032	2	fleeting
flinting	12	34	1234	2	flinting
flirting	12	31	901	2	flirting
fliting	11	35	1461	2	fl_iting
flitting	12	30	1088	2	flitting
floatier	11	3	698	2	floatier
floccing	16	30	603	2	floccing
flocking	18	34	1087	2	flocking
flogging	14	32	917	2	flogging
flooding	13	23	896	2	flooding
flooring	12	25	988	2	flooring
flopping	16	38	877	2	flopping
flossing	12	24	790	2	flossing
flouring	12	30	1014	2	flouring
flowing	14	34	1176	2	flo_wing
fluting	11	38	1509	2	fl_uting
flyting	14	37	855	2	fl_yting
foaling	11	35	1584	2	f_oaling
foaming	13	36	1299	2	f_oaming
foliating	13	3	925	2	foliating
footing	11	50	1759	2	f_ooting
fronting	12	3	1044	2	fronting
frosting	12	3	1118	2	frosting
gloaming	12	26	801	2	gloaming
glouting	10	37	969	2	glouting
loading	9	41	1461	2	_loading
loafing	11	31	979	2	_loafing
loaming	10	36	1373	2	_loaming
loaning	8	36	1483	2	_loaning
loathing	12	4	767	2	_loathing
locating	11	3	1150	2	_locating
lofting	11	33	1131	2	_lofting
looting	8	30	1964	2	_looting
lotting	8	29	1775	2	_lotting
louting	8	37	1938	2	_louting
moating	10	42	1815	2	_moating
plating	10	38	2307	2	pl_ating
pleating	11	29	1605	2	pleating
plotting	11	30	1101	2	plotting
refloating	14	19	832	2	refloating
slating	8	37	2465	2	sl_ating
slotting	9	26	1261	2	slotting
solating	9	3	1559	2	solating

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	121059	0.390	458182.1
2	DLD Change Limit	121059	68	3.216	37642.7
3	Display Results	68	68	0.033	2060.6
	(SQL Overall)	178691	68	3.639	49104.4