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

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

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
woodland	13	4	460	(None)
woodlands	14	4	415	1	woodlands
moorland	11	4	468	2	moorland
wildland	13	5	384	2	wildland
woodbind	15	4	371	2	woodbind
woodlander	15	5	243	2	woodlander
woodlark	16	9	330	2	woodlark
woodman	13	3	631	2	woodman_
woodwind	16	4	375	2	woodwind
badland	11	4	765	3	_badland
boodled	11	34	1093	3	boodl_ed
boodling	12	19	1024	3	boodling
cloudland	13	7	195	3	cloudland
coolant	9	3	1646	3	coo_lant
cropland	13	4	630	3	cropland
deodand	10	3	571	3	deod_and
dockland	16	4	371	3	dockland
doodad	9	3	642	3	dood_a_d
doodled	10	36	946	3	doodl_ed
doodling	11	21	840	3	doodling
downland	13	6	453	3	downland
foreland	12	3	901	3	foreland
goodman	11	3	593	3	goodman_
headland	13	4	561	3	headland
holland	11	34	947	3	_holland
homeland	14	4	623	3	homeland
lowland	11	3	469	3	_lowland
midland	11	3	661	3	_midland
moorlands	12	4	420	3	moorlands
noodled	9	33	992	3	noodl_ed
noodling	10	20	944	3	noodling
norland	8	3	716	3	_norland
oodlins	8	32	1051	3	_oodlins
outland	8	12	1234	3	_outland
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
wetland	11	3	535	3	w_etland
wildlands	14	4	327	3	wildlands
wonderland	15	5	259	3	wonderland
woodbin	13	5	487	3	woodbin_
woodbinds	16	4	279	3	woodbinds
woodbine	14	4	497	3	woodbine
woodbins	14	4	504	3	woodbins
wooded	11	42	1368	3	wood__ed
wooden	10	36	1030	3	wood_en_
woodhen	14	5	472	3	woodhen_
woodhens	15	3	410	3	woodhens
wooding	12	30	1202	3	wood_ing
woodlanders	16	5	216	3	woodland~~ers~~
woodlarks	17	10	313	3	woodlarks
woodless	12	27	845	3	woodless
woodlore	12	4	510	3	woodlore
woodlot	11	4	702	3	woodl_ot
woodlots	12	4	534	3	woodlots
woodmen	13	5	605	3	woodmen_
woodshed	16	4	421	3	woodshed
woodsman	14	4	479	3	woodsman_
woodtone	12	4	515	3	woodtone
woodwax	21	4	347	3	woodwa_x
woodwinds	17	4	279	3	woodwinds
wooled	10	37	1550	3	woo_l_ed
woolen	9	31	1137	3	woo_len_
woolens	10	39	884	3	woo_lens
woolled	11	3	664	3	woo_lled
woollen	10	3	472	3	woollen_
woollens	11	4	409	3	woollens
woolman	12	3	543	3	woolman_
yardland	13	4	376	3	yardland

Search took 7 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.436	409841.7
2	DLD Change Limit	146162	70	6.190	23612.6
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	6.656	26846.6