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

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

67 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
sailplaners	13	5	227	(None)
sailplaner	12	5	276	1	sailplaner_
sailplanes	12	4	431	1	sailplane_s
sailplane	11	4	409	2	sailplane__
sailplaned	13	4	247	2	sailplane_d
tailplanes	12	4	431	2	tailplane_s
airplanes	11	8	723	3	_airplane_s
ballplayers	18	5	160	3	ballplayers
sailboaters	13	5	275	3	sailboaters
sailmakers	16	4	378	3	sail_makers
sailplaning	14	5	199	3	sailplaning
skiplanes	15	4	463	3	ski_plane_s
tailplane	11	4	426	3	tailplane__
airliners	9	4	598	4	_ai_rliners
airplane	10	6	779	4	_airplane__
allayers	11	15	663	4	_a_l_layers
aquaplaners	22	5	115	4	aquaplaners
ballplayer	17	5	181	4	ballplayer_
biplanes	12	3	857	4	_bi_plane_s
cardplayers	19	5	166	4	cardplayers
displacers	15	4	501	4	_displacers
displayers	16	5	482	4	_displayers
implanters	14	8	415	4	__implanters
jackplanes	25	5	292	4	jackplane_s
mainlanders	14	6	250	4	mai_nlanders
mainliners	12	4	400	4	mai_nliners
milliners	11	28	995	4	_mil_liners
oilpapers	13	4	283	4	_oilp_apers
pillagers	12	27	692	4	_pil_lagers
planers	9	45	1794	4	____planers
railroaders	12	5	196	4	railroaders
sailboater	12	5	349	4	sailboater_
sailers	7	38	2232	4	sai__l__ers
sailless	8	24	1037	4	sail_l__ess
sailmaker	15	4	397	4	sail_maker_
saintliness	11	4	415	4	saintliness
salamanders	14	6	220	4	sa_lamanders
salliers	8	36	1334	4	sa_l_l_iers
salpians	10	3	676	4	sa_lpian__s
salvagers	13	4	469	4	sa_l_vagers
samplers	12	29	940	4	sa_mpl__ers
sandpapers	15	11	371	4	sandp_apers
seaplanes	11	4	872	4	s_eaplane_s
shinplasters	17	5	186	4	shinplasters
shipowners	18	4	212	4	shi_powners
sideliners	11	12	513	4	s_ideliners
silanes	7	25	1716	4	s_i__lane_s
sillers	7	38	2210	4	s_il_l__ers
silliness	9	5	1036	4	s_il_liness
siloxanes	16	4	361	4	s_iloxane_s
simpleness	14	4	517	4	s_impleness
skiplane	14	4	483	4	ski_plane__
spillages	12	5	608	4	spil_lage_s
spillers	10	33	1170	4	spil_l__ers
spillovers	15	4	240	4	spil_lovers
stillness	9	3	610	4	stil_l_ness
stipplers	13	3	445	4	stippl__ers
supplanters	15	11	304	4	s_upplanters
swillers	11	29	911	4	swil_l__ers
tailgaters	11	4	340	4	tail_gaters
tailwaters	13	4	351	4	tail_waters
trailblazers	23	5	123	4	trailblazers
triplanes	11	4	880	4	tri_plane_s
villagers	13	29	615	4	_vil_lagers
volplanes	14	4	467	4	_volplane_s
wallpapers	17	4	265	4	wallp_apers
warplanes	14	4	589	4	wa_rplane_s

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.436	409841.7
2	DLD Change Limit	148819	67	8.266	18003.8
3	Display Results	67	67	0.046	1456.5
	(SQL Overall)	178691	67	8.748	20426.5