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

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

69 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
comember	16	4	416	(None)
comembers	17	4	422	1	comembers
comber	12	51	1850	2	co__mber
comelier	12	3	1065	2	comelier
comether	15	3	725	2	comether
member	12	25	885	2	__member
nonmember	15	4	312	2	nonmember
remember	14	3	462	2	remember
bomber	12	50	1465	3	bo__mber
camber	12	44	1847	3	c__amber
cameleer	12	4	603	3	cameleer
cementer	12	3	919	3	cementer
chamber	16	40	1105	3	c_hamber
clamber	13	33	1173	3	c_lamber
climber	13	44	913	3	c_limber
clumber	13	40	1144	3	c_lumber
cobber	12	41	1684	3	co__bber
coercer	11	3	838	3	co_ercer
coherer	12	29	1278	3	cohe_rer
coleader	11	3	917	3	coleader
comaker	15	34	1060	3	com_aker
combater	14	3	937	3	combater
combe	11	62	2354	3	co__mbe_
combed	13	55	1654	3	co__mbed
combers	13	45	1661	3	co__mbers
combes	12	53	2173	3	co__mbes
combiner	14	25	972	3	combiner
comedies	13	3	1183	3	comedies
comer	9	58	3269	3	co__m_er
comethers	16	3	743	3	comethers
comfier	14	3	916	3	com_fier
commencer	17	14	780	3	commencer
commender	16	16	792	3	commender
commenter	15	14	1068	3	commenter
commie	12	42	1552	3	com_mie_
commies	13	37	1844	3	com_mies
commoner	14	27	1063	3	commoner
communer	14	34	929	3	communer
commuter	14	30	1013	3	commuter
comparer	14	36	1136	3	comparer
compeer	13	38	1155	3	com_peer
compeller	15	4	629	3	compeller
compiler	14	3	837	3	compiler
complier	14	3	1025	3	complier
composer	14	50	1295	3	composer
computer	14	45	1150	3	computer
condemner	14	4	576	3	condemner
contemner	13	4	718	3	contemner
coombe	12	41	1009	3	co_ombe_
coombes	13	38	1066	3	co_ombes
corymbed	18	4	261	3	corymbed
coverer	12	31	1352	3	cove_rer
coveter	12	29	1206	3	cove_ter
cozener	18	32	895	3	coze_ner
crumber	13	33	964	3	c_rumber
cucumber	16	4	260	3	cucumber
cumber	12	40	1670	3	c__umber
cummer	12	44	1459	3	cum_m_er
dismember	16	4	398	3	dismember
ember	9	55	1679	3	___ember
fomenter	13	3	926	3	fomenter
homelier	13	3	898	3	homelier
homemaker	20	4	496	3	homemaker
members	13	25	860	3	__members
nonmembers	16	4	315	3	nonmembers
omber	9	53	1643	3	_o__mber
remembers	15	4	449	3	remembers
solemner	10	4	505	3	solemner
somber	10	37	1399	3	so__mber

Search took 8 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.170	1051123.5
2	DLD Change Limit	146162	69	7.140	20470.9
3	Display Results	69	69	0.033	2090.9
	(SQL Overall)	178691	69	7.343	24334.9