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

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

78 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
mainlanders	14	6	250	(None)
mainlander	13	5	297	1	mainlander_
inlanders	10	3	614	2	__inlanders
mainlands	12	4	470	2	mainland__s
mainliners	12	4	401	2	mainlin_ers
malanders	12	3	702	2	ma__landers
auslanders	11	4	336	3	_auslanders
bilanders	12	3	596	3	_bi_landers
inlander	9	3	722	3	__inlander_
islanders	10	3	528	3	__islanders
mainland	11	4	521	3	mainland___
mainliner	11	4	467	3	mainlin_er_
mainlines	11	3	852	3	mainlin_e_s
maintainers	13	5	283	3	maintainers
philanders	16	4	427	3	phi_landers
tailenders	11	4	364	3	tai_lenders
uitlanders	11	4	283	3	_uitlanders
airliners	9	4	598	4	_airlin_ers
alexanders	18	4	244	4	_alexanders
applauders	15	4	212	4	_applauders
auslander	10	4	388	4	_auslander_
backhanders	23	12	380	4	backhanders
balancers	13	4	506	4	ba__lancers
bilander	11	3	667	4	_bi_lander_
calamanders	16	6	291	4	calamanders
calenders	12	3	740	4	ca__lenders
colanders	12	3	801	4	__colanders
faineances	15	5	353	4	faineance_s
fairleaders	15	5	177	4	fairleaders
flatlanders	15	5	198	4	flatlanders
gainsayers	14	4	187	4	gainsa_yers
glanders	10	38	1151	4	___glanders
highlanders	19	5	202	4	highlanders
inlands	8	3	878	4	__inland__s
inlayers	11	3	564	4	__inla_yers
intenders	10	21	937	4	__intenders
invaders	12	10	530	4	__inva_ders
islander	9	4	610	4	__islander_
landers	8	40	2622	4	____landers
lowlanders	14	4	269	4	_lowlanders
maenades	11	3	747	4	maen_a_de_s
mailers	9	44	2033	4	mai_l___ers
mainline	10	3	986	4	mainlin_e__
mainlined	12	5	435	4	mainlin_e_d
maintainer	12	4	351	4	maintainer_
malingers	12	8	585	4	ma__lingers
managers	11	29	1100	4	ma_n_a_gers
manhandles	16	4	339	4	ma_nhandles
manliness	11	13	1012	4	ma_nlin_ess
manners	9	34	1783	4	ma_n__n_ers
manslayers	15	4	268	4	mansla_yers
marauders	12	4	426	4	ma__rauders
marinades	12	26	898	4	marin_a_de_s
maunders	11	34	835	4	ma___unders
meanders	11	6	883	4	m___eanders
midlands	12	4	554	4	m_idland__s
milliners	11	28	995	4	m_illin_ers
minders	10	37	2012	4	m_i___nders
minelayers	15	4	345	4	m_inela_yers
mishanters	15	4	498	4	m_ishanters
mislayers	14	4	594	4	m_isla_yers
misleaders	13	4	520	4	m_isleaders
misrenders	13	7	536	4	m_isrenders
outlanders	11	4	427	4	_outlanders
panhandlers	17	5	205	4	pa_nhandlers
philander	15	4	406	4	phi_lander_
rainbands	12	4	420	4	rainband__s
rainmakers	16	4	407	4	rainma_kers
rainwaters	13	4	373	4	rainwa_ters
sailplaners	13	5	227	4	sailplan_ers
salamanders	14	6	220	4	salamanders
slanders	9	40	1402	4	___slanders
solanders	10	3	696	4	__solanders
tailender	10	4	407	4	tai_lender_
uitlander	10	4	296	4	_uitlander_
uplanders	12	3	486	4	__uplanders
woodlanders	16	5	216	4	woodlanders
zinfandels	23	5	119	4	_zinfandels

Search took 10 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.423	422437.4
2	DLD Change Limit	148819	78	8.856	16804.3
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	9.325	19162.6