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

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

47 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
fronting	12	3	1044	(None)
frosting	12	3	1118	1	frosting
affronting	17	4	260	2	affronting
arointing	10	4	936	2	arointing
aroynting	13	4	463	2	aroynting
bronzing	20	3	769	2	bronzing
droning	9	30	1372	2	dron_ing
fainting	12	33	1216	2	fainting
feinting	12	34	1083	2	feinting
flinting	12	34	1234	2	flinting
floating	12	31	1188	2	floating
flouting	12	26	1047	2	flouting
fonding	12	38	1542	2	f_onding
fontina	10	3	863	2	f_ontina
footing	11	50	1759	2	f_ooting
franking	16	43	1086	2	franking
fretting	12	27	1152	2	fretting
fringing	13	30	1090	2	fringing
fritting	12	35	1070	2	fritting
frocking	18	30	957	2	frocking
frogging	14	35	873	2	frogging
frontier	11	4	731	2	frontier
frontline	12	4	505	2	frontline
fronton	10	3	720	2	fronton_
frontons	11	3	650	2	frontons
frostings	13	3	573	2	frostings
frothing	15	20	853	2	frothing
frouncing	15	3	476	2	frouncing
frowning	15	30	783	2	frowning
frowsting	16	3	468	2	frowsting
fruiting	12	22	906	2	fruiting
granting	10	35	1452	2	granting
grouting	10	34	1079	2	grouting
grunting	10	26	958	2	grunting
ironing	8	24	1401	2	iron_ing
printing	11	32	1608	2	printing
pronating	12	3	1376	2	pronating
pronging	12	35	1184	2	pronging
ranting	8	40	2541	2	_ranting
refronting	14	3	727	2	refronting
renting	8	40	2685	2	_renting
rooting	8	35	2243	2	_rooting
rotting	8	29	1968	2	_rotting
routing	8	38	2109	2	_routing
trotting	9	25	1091	2	trotting
wonting	11	32	1410	2	_wonting
wronging	13	32	739	2	wronging

Search took 5 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.203	880251.2
2	DLD Change Limit	121059	47	4.440	27265.5
3	Display Results	47	47	0.013	3615.4
	(SQL Overall)	178691	47	4.656	38378.7