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

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

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.

64 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
wonderlands	16	5	220	(None)
wonderland	15	5	259	1	wonderland_
borderlands	15	5	184	2	borderlands
borderland	14	5	216	3	borderland_
hinterlands	15	5	300	3	hinterlands
motherlands	17	5	235	3	motherlands
nondemands	14	5	359	3	nonde_mands
overlands	13	21	888	3	_o_verlands
underhands	15	4	545	3	_underhands
wonderments	17	5	451	3	wonderments
woodlands	14	4	415	3	wood__lands
borderlines	14	4	325	4	borderlines
condescends	17	5	340	4	condescends
conelrads	12	4	426	4	con_elra_ds
confirmands	19	5	285	4	confirmands
countermands	17	4	623	4	countermands
dunelands	11	4	277	4	dun_e_lands
engarlands	12	6	167	4	_engarlands
fatherlands	18	5	250	4	fatherlands
forelands	13	4	717	4	fo_re_lands
hinterland	14	4	347	4	hinterland_
homelands	15	4	544	4	ho_me_lands
honorands	13	4	502	4	hon_or_ands
interlards	11	4	681	4	_interlards
interlends	11	4	860	4	_interlends
monerans	10	3	1034	4	mon_er_an_s
moorlands	12	4	420	4	mo__orlands
motherland	16	5	261	4	motherland_
nondemand	13	4	475	4	nonde_mand_
norlands	9	3	644	4	__n_orlands
operands	11	4	681	4	_o_per_ands
overhands	16	22	780	4	_o_verhands
overland	12	23	1200	4	_o_verland_
overlends	13	23	752	4	_o_verlends
pinelands	12	4	493	4	pin_e_lands
rangelands	12	4	279	4	range_lands
sanderlings	13	4	343	4	sanderlings
tidelands	11	4	408	4	_tide_lands
timberlands	16	5	179	4	timberlands
undercards	14	4	556	4	_undercards
underfunds	15	4	403	4	_underfunds
underhand	14	4	726	4	_underhand_
underlaid	11	4	749	4	_underlaid_
underlaps	12	14	682	4	_underla_ps
underlays	13	14	688	4	_underla_ys
underlines	11	15	1211	4	_underlines
underlings	12	17	814	4	_underlings
underloads	12	4	523	4	_underloads
underpants	13	4	691	4	_underpants
understands	13	4	465	4	_understands
videolands	15	5	197	4	_videolands
wanderings	15	21	583	4	wander_ings
wanderlusts	15	5	146	4	wanderlusts
wastelands	14	4	289	4	waste_lands
wetlands	12	4	476	4	w___etlands
wildlands	14	4	327	4	wild__lands
wondered	13	23	994	4	wonder__ed_
wonderers	13	21	793	4	wonder__ers
wondering	14	21	1046	4	wonder_in_g
wonderment	16	4	600	4	wondermen_t
wonders	11	33	1599	4	wonder____s
wonderworks	22	5	202	4	wonderworks
woodland	13	4	460	4	wood__land_
wunderkind	19	4	273	4	wunderkind_

Search took 9 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	148819	0.420	425454.8
2	DLD Change Limit	148819	64	8.203	18142.0
3	Display Results	64	64	0.033	1939.4
	(SQL Overall)	178691	64	8.656	20643.6