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

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

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
moorland	11	4	468	(None)
moorlands	12	4	420	1	moorlands
norland	8	3	716	2	_norland
woodland	13	4	460	2	woodland
coolant	9	3	1646	3	coo_lant
courlan	9	11	776	3	courlan_
courlans	10	11	761	3	courlans
cropland	13	4	630	3	cropland
dockland	16	4	371	3	dockland
doorman	10	3	706	3	doorman_
dooryard	13	4	337	3	dooryard
downland	13	6	453	3	downland
foreland	12	3	901	3	foreland
garland	9	4	870	3	_garland
gormand	11	5	745	3	_gormand
gourmand	12	4	326	3	gourmand
holland	11	34	947	3	_holland
homeland	14	4	623	3	homeland
honorand	12	4	633	3	honor_and
lowland	11	3	469	3	_lowland
mainland	11	4	521	3	mainland
midland	11	3	661	3	m_idland
monoplane	13	4	748	3	monoplane
moola	7	51	1703	3	moo_la__
moolah	11	40	919	3	moo_la_h
moolahs	12	34	738	3	moo_lahs
moolas	8	36	1559	3	moo_la_s
moonblind	14	4	285	3	moonblind
moonward	14	7	447	3	moonward
moorage	10	3	874	3	moor_age
moored	9	38	1417	3	moor__ed
moorhen	12	3	602	3	moorhen_
moorhens	13	4	485	3	moorhens
mooring	10	25	1444	3	moor_ing
mordant	10	3	1240	3	m_ordant
morgan	9	3	1137	3	m_organ_
morgans	10	3	1012	3	m_organs
motherland	16	5	261	3	motherland
motorman	12	4	614	3	motorman_
norlands	9	3	644	3	_norlands
outland	8	12	1234	3	_outland
overland	12	23	1200	3	overland
plowland	14	4	274	3	plowland
snowland	12	4	383	3	snowland
soland	7	51	1504	3	_so_land
troland	8	3	754	3	tro_land
woodlands	14	4	415	3	woodlands

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.156	1145455.1
2	DLD Change Limit	146162	47	7.796	18748.3
3	Display Results	47	47	0.016	2937.5
	(SQL Overall)	178691	47	7.968	22426.1