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

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

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

158 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
commode	14	3	812	(None)
commodes	15	3	909	1	commodes
commove	16	3	596	1	commove
comade	11	44	1532	2	co_made
commie	12	42	1552	2	comm_ie
commodore	16	4	420	2	commodore
common	12	3	1080	2	commo_n
commoner	14	27	1063	2	commoner
commons	13	3	1104	2	commons
commoved	18	4	476	2	commoved
commoves	17	3	696	2	commoves
commune	13	32	936	2	commune
commute	13	43	1044	2	commute
comose	10	50	1684	2	co_mose
compone	13	65	1719	2	compone
compose	13	57	1666	2	compose
compote	13	56	1646	2	compote
comrade	12	13	921	2	comrade
corrode	10	13	1057	2	corrode
incommode	16	5	279	2	incommode
alamode	10	3	815	3	alamode
cameoed	12	3	838	3	cameoed
cammie	12	46	1529	3	camm_ie
cathode	13	3	899	3	cathode
cestode	10	3	796	3	cestode
chamade	15	13	845	3	chamade
cladode	11	3	461	3	cladode
cockade	16	3	813	3	cockade
code	7	73	4773	3	c___ode
codrove	13	3	642	3	codrove
coelome	11	3	968	3	coelome
coembody	18	4	249	3	coembody
collide	10	32	1479	3	collide
collude	10	33	799	3	collude
colone	8	54	2500	3	co_lone
comae	9	71	2842	3	co_m_ae
comake	14	44	1342	3	co_make
comate	10	41	2484	3	co_mate
comatose	12	4	782	3	comatose
combe	11	62	2354	3	co_m_be
combed	13	55	1654	3	combed_
combine	13	30	1472	3	combine
combo	11	45	1943	3	combo__
combos	12	53	1661	3	combo_s
come	8	75	4770	3	co_m__e
comedo	11	35	960	3	co_medo
comedos	12	32	907	3	comedos
comedy	14	37	823	3	co_medy
comfort	14	36	1169	3	comfort
comma	11	45	1479	3	comm__a
command	14	39	921	3	command
commanded	17	13	650	3	commanded
commander	16	12	740	3	commander
commando	15	27	575	3	commando
commands	15	31	882	3	commands
commas	12	48	1457	3	comm_as
commata	13	3	848	3	commata
commence	16	14	910	3	commence
commend	14	40	1018	3	commend
commended	17	13	701	3	commended
commender	16	16	792	3	commender
commends	15	30	846	3	commends
comment	13	103	1770	3	comment
commerce	16	11	632	3	commerce
commies	13	37	1845	3	commies
commit	12	40	1670	3	comm_it
commits	13	38	1238	3	commits
commix	19	40	776	3	comm_ix
commixed	22	6	474	3	commixed
commixes	21	7	735	3	commixes
commixt	20	35	762	3	commixt
commodify	22	5	255	3	commodify
commodity	19	4	439	3	commodity
commodores	17	4	397	3	commodores
commonage	16	4	573	3	commonage
commoners	15	33	978	3	commoners
commonest	15	4	925	3	commonest
commonly	17	4	496	3	commonly
communed	15	33	821	3	communed
communer	14	34	930	3	communer
communes	14	34	1124	3	communes
commuted	15	28	898	3	commuted
commuter	14	30	1015	3	commuter
commutes	14	30	1189	3	commutes
commy	14	47	1264	3	comm__y
comous	10	8	1650	3	co_mous
compadre	15	29	588	3	compadre
compare	13	58	1499	3	compare
comped	13	59	1987	3	comped_
compere	13	46	1662	3	compere
compete	13	47	1655	3	compete
compile	13	3	1244	3	compile
compo	11	53	1857	3	compo__
compony	16	130	1191	3	compony
comport	13	36	1684	3	comport
compos	12	48	1880	3	compo_s
composed	15	46	1206	3	composed
composer	14	50	1295	3	composer
composes	14	50	1711	3	composes
compost	13	45	1535	3	compost
compotes	14	47	1651	3	compotes
compted	14	38	1352	3	compted
compute	13	45	1366	3	compute
comrades	13	14	977	3	comrades
comte	9	61	2547	3	co_m_te
concede	12	3	1010	3	concede
condole	10	29	1495	3	condole
condone	10	26	1629	3	condone
confide	13	3	1020	3	confide
connote	9	3	1161	3	connote
console	9	27	1598	3	console
convoke	16	20	717	3	convoke
cooed	8	45	3434	3	co__oed
cooee	7	45	3102	3	co__oee
coombe	12	41	1009	3	coom_be
cormoid	12	3	1040	3	cormoid
cormous	11	3	1235	3	cormous
corody	12	14	970	3	co_rody
corrade	10	11	1104	3	corrade
corroded	12	14	751	3	corroded
corrodes	11	13	1033	3	corrodes
corrody	13	13	614	3	corrody
cosmid	11	8	1064	3	cosmid_
cosmids	12	3	763	3	cosmids
cosmos	10	3	1175	3	cosmo_s
cosmoses	12	3	970	3	cosmoses
coude	8	50	2263	3	co__ude
couvade	13	3	506	3	couvade
cowhide	16	3	614	3	cowhide
cowpoke	18	3	510	3	cowpoke
cowrote	12	28	967	3	cowrote
coyote	11	4	1178	3	co_yote
crunode	10	3	471	3	crunode
cymose	13	42	965	3	c_ymose
demode	10	40	1346	3	_demode
discommode	18	12	317	3	~~dis~~commode
forbode	13	25	796	3	forbode
gummose	12	3	533	3	gummose
homemade	16	4	514	3	homemade
hommock	20	4	399	3	hommock
hommos	13	12	850	3	hommo_s
hommoses	15	3	815	3	hommoses
hormone	12	4	1050	3	hormone
incommoded	18	5	259	3	incommoded
incommodes	17	5	313	3	incommodes
joyrode	18	5	330	3	joyrode
mode	7	58	4030	3	___mode
omnimode	13	4	202	3	_omnimode
osmole	8	12	851	3	_osmole
osmose	8	10	800	3	_osmose
outmode	10	19	966	3	outmode
pomade	11	36	1133	3	po_made
pommee	12	28	1328	3	pomm_ee
pommie	12	37	1050	3	pomm_ie
someone	9	3	881	3	someone
tomcod	11	3	578	3	tomcod_
tomcods	12	3	487	3	tomcods
tommed	11	33	1014	3	tommed_

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	134027	0.406	440125.6
2	DLD Change Limit	134027	158	6.250	21444.3
3	Display Results	158	158	0.063	2507.9
	(SQL Overall)	178691	158	6.719	26594.9