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

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

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.

57 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
sailboardings	17	7	153	(None)
sailboarding	16	5	212	1	sailboarding_
sailboatings	15	5	182	2	sailboa_tings
railroadings	14	5	147	3	railroa_dings
sailboards	13	4	548	3	sailboard___s
sailboating	14	5	346	3	sailboa_ting_
skateboardings	22	7	121	3	skateboardings
snowboardings	20	7	139	3	snowboardings
wakeboardings	24	95	244	3	wakeboardings
billboarding	18	5	181	4	billboarding_
boardings	13	29	606	4	____boardings
railroading	13	5	237	4	railroa_ding_
sailboard	12	4	590	4	sailboard____
sailboarded	15	5	222	4	sailboard__ed
skateboarding	21	6	165	4	skateboarding_
snowboarding	19	8	192	4	snowboarding_
starboarding	16	5	207	4	starboarding_
surfboarding	19	5	157	4	surfboarding_
tailboards	13	4	508	4	tailboard___s
tailorings	11	4	343	4	tail_o_r_ings
wakeboarding	23	35	290	4	wakeboarding_
boarding	12	31	1023	5	____boarding_
bodyboarding	22	6	168	5	bodyboarding_
callboards	15	4	497	5	callboard___s
childbearings	22	6	66	5	childbear_ings
clapboarding	20	5	155	5	clapboarding_
fallboards	16	4	443	5	fallboard___s
gabardines	14	4	307	5	ga__b_ardines
gaillardias	13	5	175	5	gail_lardi_as
hoardings	14	31	511	5	____hoardings
keyboarding	22	6	182	5	_keyboarding_
loadings	10	37	838	5	___l_oa_dings
lordings	10	36	850	5	___l_o_rdings
preboarding	17	4	427	5	_preboarding_
reboarding	14	4	567	5	__reboarding_
safeguarding	18	6	137	5	safeguarding_
sailboaters	13	5	275	5	sailboa__ters
sailboats	11	4	524	5	sailboa____ts
sailings	9	35	1325	5	sail_____ings
sailplaning	14	5	199	5	sailpla_ning_
saladangs	11	4	291	5	sa_l__a_dangs
salarying	13	3	607	5	sa_l__arying_
scabbarding	19	5	183	5	s_cabbarding_
shipboards	18	9	410	5	shipboard___s
shipbuildings	22	6	68	5	shipbuildings
silverings	14	4	384	5	s_il_ver_ings
skibobbings	19	5	90	5	ski_bo_bbings
skijorings	22	4	144	5	ski_jo_r_ings
skimboards	19	4	312	5	skimboard___s
skiorings	14	24	379	5	ski__o_r_ings
smallholdings	20	7	95	5	smallho_ldings
soarings	9	32	1039	5	s____oar_ings
storyboarding	20	10	139	5	storyboarding_
tailboard	12	4	577	5	tailboard____
tailoring	10	3	640	5	tail_o_r_ing_
talebearings	15	6	188	5	talebear_ings
wallboards	16	4	445	5	wallboard___s

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	124790	0.406	440125.6
2	DLD Change Limit	124790	57	9.126	13674.1
3	Display Results	57	57	0.030	1900.0
	(SQL Overall)	178691	57	9.562	18687.6