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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

132 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
comber	12	51	1850	(None)
bomber	12	50	1465	1	bomber
camber	12	44	1848	1	camber
cobber	12	41	1684	1	cobber
combe	11	62	2354	1	combe_
combed	13	55	1654	1	combed
combers	13	45	1662	1	combers
combes	12	53	2173	1	combes
comer	9	58	3269	1	com_er
cumber	12	40	1670	1	cumber
omber	9	53	1644	1	_omber
somber	10	37	1400	1	somber
amber	9	45	2321	2	_amber
bobber	9	50	1674	2	bobber
bombe	11	55	1931	2	bombe_
bombed	13	41	1387	2	bombed
bombers	13	45	1259	2	bombers
bombes	12	49	1682	2	bombes
caber	9	51	2683	2	c_aber
cambers	13	40	1744	2	cambers
camper	12	47	2221	2	camper
chamber	16	40	1106	2	chamber
chomper	16	38	1007	2	chomper
clamber	13	33	1174	2	clamber
climber	13	44	913	2	climber
clobber	13	37	816	2	clobber
clumber	13	40	1144	2	clumber
coaler	8	41	2171	2	coaler
coater	8	43	2957	2	coater
coaxer	15	39	1279	2	coaxer
cobbers	13	41	1475	2	cobbers
cobbier	13	34	1016	2	cobbier
cobbler	13	33	1182	2	cobbler
cocker	14	43	2039	2	cocker
codder	10	44	1634	2	codder
coder	8	61	3422	2	co_der
codger	10	58	1487	2	codger
coffer	14	41	1286	2	coffer
coiler	8	44	2159	2	coiler
coiner	8	43	2378	2	coiner
colder	9	51	2185	2	colder
colter	8	46	2509	2	colter
comae	9	71	2842	2	comae_
comaker	15	34	1060	2	comaker
comb	10	66	3211	2	comb__
combat	12	3	1675	2	combat
combater	14	3	938	2	combater
combiner	14	25	972	2	combiner
combo	11	45	1943	2	comb_o
combos	12	53	1661	2	combos
combs	11	61	2296	2	comb_s
come	8	75	4770	2	com_e_
comember	16	4	416	2	comember
comers	10	53	2808	2	com_ers
comes	9	72	4699	2	com_es
comet	9	59	4607	2	com_et
comfier	14	3	916	2	comfier
comped	13	59	1987	2	comped
compeer	13	38	1155	2	compeer
compel	12	44	1289	2	compel
compere	13	46	1662	2	compere
comte	9	61	2547	2	comte_
comtes	10	62	2281	2	comtes
confer	11	40	1868	2	confer
conger	9	50	2427	2	conger
conker	12	47	2155	2	conker
conner	8	44	2396	2	conner
cooer	7	48	3101	2	co_oer
cooker	12	47	2245	2	cooker
cooler	8	48	2471	2	cooler
coombe	12	41	1009	2	coombe_
coombes	13	38	1066	2	coombes
cooper	10	42	2112	2	cooper
cooter	8	51	2861	2	cooter
coper	9	53	3609	2	co_per
copier	10	37	2290	2	copier
copper	12	43	2189	2	copper
copter	10	98	2201	2	copter
corbel	10	37	1597	2	corbel
corder	9	43	2288	2	corder
corer	7	55	3887	2	co_rer
corker	12	47	2085	2	corker
corner	8	46	2562	2	corner
cosher	11	48	1990	2	cosher
cosier	8	44	2376	2	cosier
coster	8	43	3129	2	coster
cotter	8	49	2667	2	cotter
couter	8	49	3022	2	couter
cover	10	54	3077	2	co_ver
cower	10	45	3177	2	co_wer
cowier	11	36	1616	2	cowier
coyer	10	52	2284	2	co_yer
cozier	17	33	1514	2	cozier
crumber	13	33	964	2	crumber
cuber	9	52	2253	2	c_uber
cumbers	13	45	1541	2	cumbers
cummer	12	44	1459	2	cummer
curber	10	45	1705	2	curber
cyber	12	49	1038	2	c_yber
dobber	11	40	1542	2	dobber
dumber	11	44	1417	2	dumber
ember	9	55	1680	2	_ember
gomer	8	52	2065	2	gom_er
goober	9	39	1174	2	goober
hobber	13	41	1463	2	hobber
hombre	13	30	930	2	hombre
homer	10	58	2845	2	hom_er
homier	11	64	1699	2	homier
jobber	17	38	1335	2	jobber
lamber	10	44	1849	2	lamber
limber	10	43	1679	2	limber
lobber	10	40	1660	2	lobber
lumber	10	38	1777	2	lumber
member	12	25	885	2	member
mobber	12	36	1346	2	mobber
momser	10	40	1141	2	momser
momzer	19	32	755	2	momzer
number	10	39	1322	2	number
ombers	10	42	1440	2	_ombers
ombre	9	41	1180	2	_ombre
omer	6	70	2839	2	_om_er
robber	10	39	1653	2	robber
romper	10	42	1368	2	romper
sobber	10	40	1659	2	sobber
sober	7	48	2241	2	so_ber
sombre	10	72	947	2	sombre
timber	10	40	1268	2	timber
tombed	11	38	1213	2	tombed
umber	9	46	1759	2	_umber
vomer	10	55	1738	2	vom_er
wombed	14	41	923	2	wombed
wombier	14	3	654	2	wombier

Search took 5 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.346	516448.0
2	DLD Change Limit	82551	132	3.623	22785.3
3	Display Results	132	132	0.046	2869.6
	(SQL Overall)	178691	132	4.015	44505.9