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

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

47 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
lampshells	17	5	130	(None)
lampshell	16	5	173	1	lampshell_
clamshells	17	5	156	2	clam_shells
bandshells	16	7	237	3	bandshells
bombshells	19	7	155	3	bombshells
clamshell	16	4	191	3	clam_shell_
lampshades	18	5	172	3	lampshades
ainsells	8	9	540	4	_ains_ells
bandshell	15	6	304	4	bandshell_
bombshell	18	8	166	4	bombshell_
camphenes	18	4	646	4	camp_henes
camphols	17	4	624	4	camp_h_ols
campshirts	19	5	210	4	campshirts
campstools	16	7	171	4	campstools
damosels	11	19	523	4	damos_e_ls
damsels	10	12	670	4	dam_s_e_ls
eggshells	14	5	105	4	_eggshells
famishes	16	5	828	4	famishe__s
gamashes	14	5	694	4	gamashe__s
lambkills	17	4	182	4	lam_bkills
lamella	9	8	861	4	lam___ella
lamellas	10	9	816	4	lam___ellas
lamisters	11	5	712	4	lamiste_rs
lampases	12	6	729	4	lampase__s
lampers	11	38	1733	4	lamp__e_rs
lampreys	15	4	288	4	lamp_re_ys
lampshade	17	5	185	4	lampsh_ade
lamsters	10	9	975	4	lam_ste_rs
lapels	8	37	1204	4	la_p__e_ls
lapsers	9	39	1105	4	la_ps_e_rs
lapses	8	52	1769	4	la_ps_e__s
lashers	10	41	2183	4	la__she_rs
lashes	9	48	3100	4	la__she__s
lavashes	14	4	557	4	lavashe__s
lavishers	15	6	464	4	lavishe_rs
lavishes	14	5	740	4	lavishe__s
marshalls	14	4	483	4	ma_rshalls
nutshells	12	4	266	4	_nutshells
pamphlets	18	4	275	4	pamp_hlets
rakehells	16	4	210	4	ra_kehells
seashells	12	4	354	4	_seashells
shells	9	43	1952	4	____shells
softshells	16	5	157	4	softshells
subshells	14	4	405	4	_subshells
unshells	11	4	592	4	__unshells
upswells	13	4	262	4	__upswells
wampishes	19	4	430	4	wampishe__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	161450	0.173	1032896.0
2	DLD Change Limit	161450	47	9.703	16639.2
3	Display Results	47	47	0.016	2937.5
	(SQL Overall)	178691	47	9.892	18064.2