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

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

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.

73 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
lampreys	15	4	288	(None)
lamprey	14	3	486	1	lamprey_
lampers	11	38	1733	2	lamp_ers
amperes	11	3	1398	3	_amperes
apres	7	54	2640	3	_a_pre_s
campers	13	42	2028	3	camp_ers
camporees	15	4	610	3	camporees
clamorers	13	4	578	3	clamorers
clampers	14	32	1188	3	clamp_ers
comfreys	18	4	333	3	comfreys
compress	14	3	905	3	compress
dampens	12	34	856	3	damp_ens
dampers	12	39	1569	3	damp_ers
dampness	13	3	607	3	dampness
empress	11	3	816	3	_empress
gambrels	13	3	421	3	gambrels
hamperers	16	28	752	3	hamperers
hampers	14	36	1694	3	hamp_ers
impress	11	3	777	3	_impress
koupreys	17	4	173	3	koupreys
laborers	10	20	838	3	laborers
labrets	9	3	936	3	la_brets
lackeys	16	45	826	3	la_ckeys
lacqueys	22	13	269	3	lacqueys
lambers	11	38	1710	3	lam_bers
lamberts	12	34	878	3	lamberts
lambies	11	30	1511	3	lambie_s
lameds	9	48	1203	3	lam__eds
lameness	10	26	1267	3	lameness
lames	7	54	4554	3	lam__e_s
lampads	12	47	762	3	lamp_ads
lampas	10	66	1595	3	lamp__as
lampases	12	6	729	3	lampases
lamped	11	40	1754	3	lamp_e_d
lamperses	13	4	512	3	lamperses
lampions	12	27	797	3	lampions
lampoons	12	26	686	3	lampoons
lamps	9	56	2483	3	lamp___s
lampyrids	17	4	201	3	lampyrids
lamsters	10	9	975	3	lamsters
langleys	12	4	510	3	langleys
langrels	9	10	617	3	langrels
lapels	8	37	1204	3	la_p_els
lappers	11	37	1746	3	la_ppers
lappets	11	32	912	3	la_ppets
lapsers	9	39	1105	3	la_psers
lapses	8	52	1769	3	la_pse_s
larees	6	53	2311	3	la__rees
lares	5	48	5263	3	la__re_s
laurels	7	4	666	3	la_urels
lazarets	17	4	480	3	lazarets
lemures	9	3	879	3	lemure_s
limeys	11	42	927	3	lim__eys
limpers	11	38	1522	3	limp_ers
limpets	11	32	978	3	limp_ets
limpness	12	4	670	3	limpness
limpsey	14	36	509	3	limpsey_
lumpens	11	29	826	3	lump_ens
lumpers	11	35	1448	3	lump_ers
mameys	13	44	952	3	mam__eys
mammeys	13	37	672	3	mam_meys
ospreys	12	3	314	3	_ospreys
palfreys	16	4	200	3	palfreys
pamperers	15	23	686	3	pamperers
pamperos	14	30	669	3	pamperos
pampers	13	36	1593	3	pamp_ers
preys	10	57	1778	3	___preys
samplers	12	29	940	3	samplers
samples	11	28	1545	3	sample_s
tamperers	13	22	731	3	tamperers
tampers	11	35	1674	3	tamp_ers
vampers	14	31	1162	3	vamp_ers
vampires	15	22	603	3	vampire_s

Search took 7 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	146162	0.156	1145455.1
2	DLD Change Limit	146162	73	6.780	21557.8
3	Display Results	73	73	0.033	2212.1
	(SQL Overall)	178691	73	6.969	25640.8