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

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

70 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
markings	15	34	1024	(None)
makings	14	54	1316	1	ma_kings
marking	14	40	2013	1	marking_
marlings	11	37	1349	1	marlings
maskings	15	44	875	1	maskings
parkings	15	36	1068	1	parkings
armings	10	38	1150	2	_armings
askings	12	51	917	2	_askings
backings	17	40	1221	2	backings
bakings	14	43	1202	2	ba_kings
bankings	15	48	940	2	bankings
barking	14	47	2418	2	barking_
calkings	15	28	922	2	calkings
cardings	12	38	1263	2	cardings
carking	14	43	2285	2	carking_
carlings	11	40	1585	2	carlings
carpings	13	38	1238	2	carpings
carvings	14	38	1020	2	carvings
darings	9	37	1365	2	dar_ings
darking	13	42	1734	2	darking_
darklings	15	3	398	2	darklings
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
farmings	14	29	822	2	farmings
gaskings	14	42	747	2	gaskings
harking	15	41	2094	2	harking_
harpings	14	37	977	2	harpings
hawkings	19	33	613	2	hawkings
kartings	13	41	852	2	kartings
lakings	12	47	1351	2	la_kings
larking	12	37	1825	2	larking_
mailings	11	30	1192	2	mailings
making	13	48	2385	2	ma_king_
malkins	13	33	1180	2	malkin_s
mallings	11	34	1309	2	mallings
mappings	15	29	641	2	mappings
marblings	14	22	554	2	marblings
margins	10	38	1519	2	margin_s
marinas	9	35	1938	2	mar_inas
marines	9	39	2801	2	mar_ines
marketings	17	4	316	2	marketings
marlines	10	38	1871	2	marlines
marling	10	33	2276	2	marling_
marlins	9	34	2047	2	marlin_s
marring	10	33	1955	2	marring_
marting	10	33	2501	2	marting_
martinis	10	33	1161	2	martinis
martins	9	33	2206	2	martin_s
masking	14	51	1661	2	masking_
matings	10	45	1621	2	ma_tings
mattings	11	36	967	2	mattings
mayings	13	44	1051	2	ma_yings
mornings	11	29	792	2	mornings
narking	12	40	1538	2	narking_
packings	17	43	1006	2	packings
pargings	12	34	1016	2	pargings
parings	10	42	1921	2	par_ings
parking	14	34	2304	2	parking_
partings	11	35	1373	2	partings
rankings	13	38	917	2	rankings
sackings	15	38	963	2	sackings
takings	12	45	1257	2	ta_kings
talkings	13	35	840	2	talkings
walkings	16	32	731	2	walkings
warking	15	35	1957	2	warking_
warnings	12	35	845	2	warnings
workings	16	33	750	2	workings

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.376	475242.0
2	DLD Change Limit	121059	70	3.966	30524.2
3	Display Results	70	70	0.033	2121.2
	(SQL Overall)	178691	70	4.375	40843.7