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

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

53 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
farmings	14	29	822	(None)
armings	10	38	1150	1	_armings
farming	13	35	1508	1	farming_
framings	14	33	813	1	framings
arming	9	47	1980	2	_arming_
cardings	12	38	1264	2	cardings
carlings	11	40	1586	2	carlings
carmines	12	36	1787	2	carmines
carpings	13	38	1239	2	carpings
carvings	14	38	1021	2	carvings
darings	9	37	1365	2	dar_ings
darlings	10	37	1038	2	darlings
darnings	10	37	855	2	darnings
earings	8	45	1771	2	ear_ings
earnings	9	41	933	2	earnings
earrings	9	29	963	2	earrings
facings	13	45	1126	2	fa_cings
fadings	12	46	930	2	fa_dings
failings	12	38	1101	2	failings
fairings	12	38	819	2	fairings
famines	12	32	1626	2	fa_mines
faming	12	49	2297	2	fa_ming_
farcing	13	35	1400	2	farcing_
farding	12	37	1674	2	farding_
farinas	10	32	1524	2	far_inas
faring	10	52	3128	2	far_ing_
farthings	16	3	523	2	farthings
farting	11	41	2075	2	farting_
fastings	12	40	1194	2	fastings
fatlings	12	35	930	2	fatlings
firings	11	41	1233	2	fir_ings
firming	13	28	1122	2	firming_
forgings	13	28	770	2	forgings
forming	13	36	1573	2	forming_
framing	13	30	1479	2	framing_
frayings	15	32	599	2	frayings
furrings	12	31	714	2	furrings
gamings	11	46	1091	2	ga_mings
harmines	13	27	1514	2	harmines
harming	13	37	1793	2	harming_
harmins	12	37	1672	2	harmin_s
harpings	14	37	977	2	harpings
kartings	13	41	852	2	kartings
markings	15	34	1024	2	markings
marlings	11	37	1349	2	marlings
pargings	12	34	1016	2	pargings
parings	10	42	1921	2	par_ings
parkings	15	36	1068	2	parkings
partings	11	35	1373	2	partings
pharmings	17	25	472	2	pharmings
varmints	13	3	564	2	varmints
warming	13	35	1508	2	warming_
warnings	12	35	845	2	warnings

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.800	223363.8
2	DLD Change Limit	121059	53	4.046	29920.7
3	Display Results	53	53	0.013	4076.9
	(SQL Overall)	178691	53	4.859	36775.3