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

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

54 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
member	12	25	885	(None)
ember	9	55	1680	1	_ember
members	13	25	860	1	members
amber	9	45	2321	2	_amber
bomber	12	50	1465	2	bomber
camber	12	44	1847	2	camber
comber	12	51	1850	2	comber
comember	16	4	416	2	comember
cumber	12	40	1670	2	cumber
dumber	11	44	1417	2	dumber
embar	9	40	1160	2	_embar
embed	10	50	1430	2	_embed
embers	10	41	1618	2	_embers
emeer	7	48	1536	2	_emeer
emmer	9	43	1446	2	_emmer
hemmer	13	41	1264	2	hemmer
lamber	10	44	1849	2	lamber
limber	10	43	1679	2	limber
lumber	10	38	1777	2	lumber
mammer	9	42	1886	2	mammer
mamzer	19	45	983	2	mamzer
meager	9	45	1519	2	meager
meaner	8	46	1784	2	meaner
meeker	12	35	998	2	meeker
meeter	8	36	1650	2	meeter
melder	9	39	1581	2	melder
melter	8	35	2011	2	melter
membered	15	3	590	2	membered
meme	8	53	3055	2	mem_e_
memes	9	49	2770	2	mem_es
memoir	10	3	721	2	memoir
mender	9	35	2079	2	mender
mercer	10	52	1420	2	mercer
merer	7	51	2623	2	me_rer
merger	9	50	1647	2	merger
meter	7	51	3032	2	me_ter
metier	8	35	1769	2	metier
mewler	11	35	1023	2	mewler
mimbar	12	9	749	2	mimbar
mimer	9	48	2576	2	mim_er
mobber	12	36	1346	2	mobber
momser	10	40	1141	2	momser
momzer	19	32	755	2	momzer
mumbler	13	35	1091	2	mumbler
mummer	9	36	1454	2	mummer
mumper	12	35	1352	2	mumper
number	10	39	1322	2	number
omber	9	53	1644	2	_omber
remember	14	3	462	2	remember
somber	10	37	1399	2	somber
temper	10	39	1409	2	temper
timber	10	40	1268	2	timber
umber	9	46	1759	2	_umber
weber	10	3	1352	2	we_ber

Search took 4 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.110	1624463.6
2	DLD Change Limit	82551	54	3.373	24474.1
3	Display Results	54	54	0.033	1636.4
	(SQL Overall)	178691	54	3.516	50822.2