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

Here are the results of your fuzzy-string dictionary search for “sellotaping” 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
sellotaping	14	5	258	(None)
heliotyping	20	5	184	3	heliotyping
sellotape	11	9	362	3	sellotap__e
sellotaped	13	12	257	3	sellotap_ed
sellotapes	12	10	374	3	sellotap_es
serotyping	16	4	312	3	se_rotyping
allocating	13	4	738	4	_allocating
allotting	10	4	650	4	_allot_ting
audiotaping	15	5	165	4	audiotaping
balloting	12	3	838	4	ballot__ing
becloaking	19	4	488	4	beclo_aking
beclothing	18	4	387	4	beclot_hing
beleaping	14	3	674	4	be_l_eaping
bellowing	15	4	719	4	bello__wing
cellaring	12	3	852	4	cell__aring
collocating	16	4	590	4	collocating
delectating	15	4	599	4	delectating
dolloping	13	4	499	4	dollo__ping
eloping	10	35	1283	4	_e_lo__ping
fellating	13	3	924	4	fell__ating
fellowing	16	5	592	4	fello__wing
ferrotyping	20	5	216	4	ferrotyping
galloping	13	5	625	4	gallo__ping
halloaing	13	8	703	4	hallo_a_ing
helloing	12	15	912	4	hello___ing
hilloaing	13	7	543	4	hillo_a_ing
holloaing	13	8	579	4	hollo_a_ing
hulloaing	13	8	452	4	hullo_a_ing
lolloping	12	4	468	4	lollo__ping
meliorating	14	4	656	4	meliorating
mellowing	15	4	589	4	mello__wing
pelleting	12	3	795	4	pellet__ing
pelletising	14	5	339	4	pelletising
pelletizing	23	4	508	4	pelletizing
reallocating	15	7	366	4	reallocating
reallotting	12	4	367	4	reallot_ting
reclothing	16	4	497	4	reclot_hing
refloating	14	19	832	4	reflo_ating
reloading	11	8	988	4	re_lo_ading
reloaning	10	7	1048	4	re_lo_aning
relocating	13	3	1087	4	re_locating
reluctating	14	4	576	4	reluctating
replotting	13	5	704	4	replot_ting
retaping	11	30	1255	4	re___taping
retotaling	11	8	688	4	re_totaling
sabotaging	14	6	286	4	s_abotaging
sallowing	13	5	738	4	sallo__wing
scalloping	15	4	395	4	scallo__ping
scolloping	15	4	324	4	scollo__ping
selecting	12	3	1053	4	select__ing
selling	8	32	2583	4	sell____ing
sloping	10	41	1407	4	s__lo__ping
slopping	13	38	1142	4	s__lo_pping
slotting	9	26	1261	4	s__lot_ting
soaping	10	36	1622	4	s___o_aping
splotching	18	4	286	4	s_plotching
stenotyping	17	5	219	4	stenotyping
stereotyping	18	5	277	4	stereotyping
subtotaling	14	5	301	4	subtotaling
sulfonating	15	4	367	4	sulfonating
syllogizing	25	5	373	4	syllogizing
teetotaling	12	5	253	4	teetotaling
teletyping	16	4	247	4	te_letyping
vellicating	17	4	455	4	vellicating
videotaping	18	5	170	4	videotaping
walloping	15	4	559	4	wallo__ping
yellowing	16	5	507	4	yello__wing

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.173	1032896.0
2	DLD Change Limit	148819	67	8.813	16886.3
3	Display Results	67	67	0.046	1456.5
	(SQL Overall)	178691	67	9.032	19784.2