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

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

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.

80 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
markhors	17	4	539	(None)
markhoors	18	4	270	1	markhoors
markhor	16	3	546	1	markhor_
marchers	15	37	1081	2	marchers
markers	13	35	1610	2	mark_ers
markhoor	17	4	297	2	markhoor
abhors	11	4	1062	3	_a_bhors
anchors	12	39	1295	3	_anchors
arbors	8	47	1788	3	_ar_bors
archers	12	44	1457	3	_archers
archons	12	3	1158	3	_archons
ardors	7	44	1687	3	_ar_dors
armors	8	50	1781	3	_ar_mors
authors	10	3	1185	3	_authors
backhoes	19	3	854	3	backhoes
barhops	14	28	811	3	bar_hops
barkers	13	43	1851	3	bark_ers
camphors	17	3	705	3	camphors
carhops	14	32	970	3	car_hops
carthorse	14	4	629	3	carthorse
earshots	11	4	662	3	earshots
harbors	12	4	1241	3	har_bors
larkers	11	30	1451	3	lark_ers
machos	13	52	1749	3	ma_cho_s
machzors	24	4	411	3	machzors
mahoes	11	3	1310	3	ma__hoes
mahzors	21	3	512	3	ma_hzors
majors	15	45	1109	3	ma__jors
makars	12	46	1263	3	ma_k_ars
makers	12	39	2173	3	ma_k_ers
makos	11	65	1836	3	ma_k_o_s
malodors	11	4	497	3	malodors
manihots	13	12	644	3	manihots
manors	8	44	2088	3	ma__nors
marabous	12	4	906	3	marabous
marathons	14	4	641	3	marathons
marblers	12	31	923	3	marblers
marcher	14	39	1297	3	marcher_
marches	14	39	2117	3	march_es
mariners	10	31	1386	3	mariners
markas	12	47	1700	3	mark__as
markdown	18	4	303	3	markdown
markdowns	19	4	246	3	markdowns
marker	12	44	2039	3	mark_er_
marketers	15	4	598	3	marketers
markets	13	33	1403	3	mark_ets
markings	15	34	1024	3	markings
markkas	12	35	608	3	mark_kas
marks	11	59	3348	3	mark___s
markups	15	3	496	3	mark_ups
marmots	11	3	1151	3	mar_mots
maroons	9	26	1555	3	mar_oons
marplots	12	4	563	3	marplots
marrers	9	34	1431	3	mar_rers
marriers	10	33	1247	3	marriers
marrons	9	32	1697	3	mar_rons
marrows	12	29	1182	3	mar_rows
marshals	13	3	778	3	marshals
marshes	12	36	1537	3	marsh_es
martyrs	12	3	489	3	mar_tyrs
mashers	12	46	2105	3	ma_shers
maskers	13	39	1384	3	mask_ers
matadors	11	5	698	3	matadors
matchers	15	30	1243	3	matchers
mayors	11	57	1419	3	ma__yors
miradors	11	4	685	3	miradors
mirrors	9	3	862	3	mir_rors
morphos	14	15	908	3	morpho_s
murthers	13	3	654	3	murthers
packhorse	20	4	339	3	packhorse
parachors	16	4	740	3	parachors
paradors	11	34	1190	3	paradors
parkers	13	38	1687	3	park_ers
parlors	9	3	1291	3	par_lors
sartors	7	3	1497	3	sar_tors
warhorse	14	4	534	3	war_horse
warriors	11	3	536	3	warriors
warthogs	15	4	482	3	warthogs
workhorse	19	4	385	3	workhorse
workhours	19	4	319	3	workhours

Search took 8 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	146162	0.420	425454.8
2	DLD Change Limit	146162	80	6.580	22213.1
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	7.030	25418.3