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

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

115 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
clownery	16	3	331	(None)
cloner	8	44	1809	2	clo_ner_
cloners	9	45	1482	2	clo_ners
clovery	15	40	740	2	clo_very
clowder	13	36	794	2	clowder_
clowders	14	35	747	2	clowders
clowned	13	44	773	2	clowne_d
crowner	12	40	1260	2	crowner_
crowners	13	37	1075	2	crowners
flowery	16	32	778	2	flow_ery
lowery	12	41	1271	2	_low_ery
bloomery	15	33	569	3	bloomery
blower	11	53	1657	3	blow_er_
blowers	12	43	1359	3	blow_ers
blowier	12	4	894	3	blowier_
bowery	14	60	1211	3	_bow_ery
browner	12	49	1164	3	browner_
cannery	12	36	1001	3	c_annery
chowder	16	38	781	3	chowder_
chowders	17	38	754	3	chowders
clattery	13	37	819	3	clattery
clawer	11	45	1278	3	claw_er_
clawers	12	39	1097	3	claw_ers
cleaner	9	37	1230	3	cleaner_
cleaners	10	36	1054	3	cleaners
clobber	13	37	816	3	clobber_
clobbers	14	39	751	3	clobbers
clocker	15	39	1087	3	clocker_
clockers	16	36	981	3	clockers
clogger	11	43	880	3	clogger_
cloggers	12	43	728	3	cloggers
clone	7	57	2816	3	clo_ne__
cloned	9	45	1880	3	clo_ne_d
clones	8	45	2656	3	clo_ne_s
closely	12	3	705	3	clo_sely
closer	8	49	1820	3	clo_ser_
closers	9	44	1532	3	clo_sers
clouter	9	35	1169	3	clouter_
clouters	10	39	980	3	clouters
clover	11	46	1712	3	clo_ver_
clovers	12	51	1466	3	clo_vers
clown	10	52	1473	3	clown___
clowneries	15	4	474	3	clowneries
clowning	14	30	725	3	clowning
clownish	16	4	380	3	clownish
clowns	11	48	1011	3	clown__s
clustery	13	31	711	3	clustery
cluttery	13	34	632	3	cluttery
coiner	8	43	2378	3	c_oiner_
coiners	9	36	2075	3	c_oiners
colliery	13	30	736	3	colliery
coney	10	59	3288	3	c_o_ne_y
conner	8	44	2396	3	c_onner_
conners	9	40	2311	3	c_onners
cookery	16	42	1039	3	c_ookery
coopery	14	39	1027	3	c_oopery
coppery	16	40	939	3	c_oppery
corner	8	46	2562	3	c_orner_
corners	9	47	2331	3	c_orners
country	12	38	804	3	c_ountry
cowberry	18	4	334	3	c_owberry
cower	10	45	3177	3	c_ow_er_
cowers	11	46	2553	3	c_ow_ers
cowherb	17	3	510	3	c_owherb
cowherd	16	3	695	3	c_owherd
cowier	11	36	1616	3	c_owier_
cowry	13	55	1248	3	c_ow__ry
crockery	19	35	660	3	crockery
crookery	17	41	599	3	crookery
crooner	9	37	1404	3	crooner_
crooners	10	39	1139	3	crooners
crowberry	19	4	237	3	crowberry
crowder	13	38	986	3	crowder_
crowders	14	39	881	3	crowders
crower	11	41	1756	3	crow_er_
crowers	12	46	1490	3	crow_ers
crowned	13	39	1243	3	crowne_d
crownet	12	37	1411	3	crowne_t
crownets	13	40	767	3	crownets
dowery	13	43	1166	3	_dow_ery
downer	10	44	1492	3	_downer_
downers	11	39	1277	3	_downers
drowner	11	36	980	3	drowner_
drowners	12	42	827	3	drowners
eloiner	7	14	918	3	eloiner_
eloiners	8	12	815	3	eloiners
flower	12	48	1550	3	flow_er_
flowers	13	34	1317	3	flow_ers
frowner	13	42	968	3	frowner_
frowners	14	37	793	3	frowners
glower	10	51	1493	3	glow_er_
glowers	11	34	1209	3	glow_ers
joinery	17	36	659	3	_joinery
loaner	6	44	1650	3	_loaner_
loaners	7	39	1362	3	_loaners
lonely	9	29	1247	3	_lo_nely
loner	5	54	3104	3	_lo_ner_
loners	6	42	2581	3	_lo_ners
looney	9	47	1241	3	_loone_y
lottery	10	38	983	3	_lottery
lower	8	58	3041	3	_low_er_
lowers	9	46	2492	3	_low_ers
lowness	10	3	781	3	_lowness
onery	8	4	1412	3	__o_nery
ornery	9	3	846	3	__ornery
owner	8	46	1331	3	__owner_
owners	9	42	1070	3	__owners
plower	11	43	1506	3	plow_er_
plowers	12	38	1224	3	plow_ers
powdery	16	39	612	3	_powdery
showery	16	43	724	3	show_ery
slobbery	15	37	566	3	slobbery
slower	9	40	1615	3	slow_er_
slowness	11	3	501	3	slowness
towery	12	40	1209	3	_tow_ery

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	146162	0.470	380193.6
2	DLD Change Limit	146162	115	6.360	22981.4
3	Display Results	115	115	0.046	2500.0
	(SQL Overall)	178691	115	6.876	25987.6