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

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

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.

52 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
ampere	10	5	1441	(None)
amperes	11	3	1398	1	amperes
abampere	14	4	285	2	abampere
adhere	10	3	1033	2	adhere
ambeer	10	45	1160	2	ambeer
amber	9	45	2321	2	amber_
ambers	10	45	1958	2	ambers
ambery	13	38	1113	2	ambery
ameer	7	56	1898	2	ameer_
ameers	8	40	1557	2	ameers
amerce	10	3	1051	2	am_erce
amped	10	48	2051	2	ampe_d
amperage	13	4	774	2	amperage
ample	9	47	2030	2	amp_le
ampler	10	43	1330	2	ampler_
ampule	10	7	1061	2	ampule
aper	6	63	3623	2	a_per_
apers	7	66	2913	2	a_pers
apery	10	65	1790	2	a_pery
asper	7	55	2043	2	asper_
aspers	8	62	2031	2	aspers
asperse	9	42	1066	2	asperse
aspire	8	6	1212	2	aspire
camper	12	47	2221	2	camper_
campers	13	42	2029	2	campers
compere	13	46	1662	2	compere
damper	11	41	1775	2	damper_
dampers	12	39	1569	2	dampers
empery	13	4	868	2	empery
empire	10	3	932	2	empire
hamper	13	45	1865	2	hamper_
hampered	16	23	993	2	hampered
hamperer	15	37	909	2	hamperer
hampers	14	36	1695	2	hampers
impede	11	46	962	2	impede
impure	10	3	838	2	impure
lampers	11	38	1733	2	lampers
mere	6	72	4444	2	_m_ere
pamper	12	43	1666	2	pamper_
pampered	15	22	923	2	pampered
pamperer	14	22	833	2	pamperer
pampero	13	32	809	2	pampero
pampers	13	36	1593	2	pampers
pere	6	64	5026	2	__pere
tamper	10	46	1851	2	tamper_
tampered	13	27	946	2	tampered
tamperer	12	24	889	2	tamperer
tampers	11	35	1674	2	tampers
umpire	10	4	789	2	umpire
vamper	13	42	1265	2	vamper_
vampers	14	31	1162	2	vampers
vampire	14	29	667	2	vampire

Search took 3 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	82551	0.326	548131.9
2	DLD Change Limit	82551	52	2.500	33020.4
3	Display Results	52	52	0.016	3250.0
	(SQL Overall)	178691	52	2.842	62875.1