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

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

135 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
creamery	15	38	598	(None)
creamer	11	37	1409	1	creamer_
creamers	12	41	1131	1	creamers
creamed	12	39	1371	2	creame_d
creamier	12	31	906	2	creamier_
creamily	15	3	636	2	creamily
creamy	13	48	1136	2	cream__y
creaser	9	44	1574	2	creaser_
creasers	10	36	1284	2	creasers
dreamer	10	41	1084	2	dreamer_
dreamers	11	36	900	2	dreamers
reamer	8	43	2521	2	_reamer_
reamers	9	42	2108	2	_reamers
screamer	12	26	788	2	screamer_
screamers	13	23	626	2	screamers
beanery	12	3	756	3	_beanery
bravery	15	42	813	3	br_avery
breaker	13	39	1292	3	breaker_
breakers	14	38	1097	3	breakers
breamed	12	40	1159	3	breame_d
brewery	15	37	696	3	bre_wery
calamary	15	4	546	3	calamary
camera	10	3	1369	3	c__amera
celery	11	3	962	3	c_e_lery
cheaper	14	40	1058	3	cheaper_
cheater	12	48	1696	3	cheater_
cheaters	13	36	1351	3	cheaters
cheery	14	49	1315	3	che__ery
cleaner	9	37	1230	3	cleaner_
cleaners	10	36	1054	3	cleaners
clearer	9	37	1082	3	clearer_
clearers	10	34	930	3	clearers
cleaver	12	41	1080	3	cleaver_
cleavers	13	39	887	3	cleavers
crammer	13	40	1096	3	crammer_
crammers	14	36	935	3	crammers
crampy	15	47	1099	3	cr_am_py
crater	8	50	2664	3	cr_ater_
craters	9	50	2189	3	cr_aters
craver	11	46	1847	3	cr_aver_
cravers	12	44	1656	3	cr_avers
creaked	14	34	1323	3	creake_d
creakier	14	32	833	3	creakier_
creakily	17	3	539	3	creakily
creaky	15	49	1155	3	crea__ky
cream	9	57	2135	3	cream___
creameries	14	4	667	3	creameries
creamiest	13	24	893	3	creamiest
creaming	13	34	1314	3	creaming
creams	10	47	1525	3	cream__s
creamware	16	4	253	3	creamware
crease	8	55	1957	3	crease__
creased	10	43	1558	3	crease_d
creases	9	40	2096	3	crease_s
creasier	10	32	1019	3	creasier_
creasy	11	46	1230	3	crea__sy
create	8	51	2638	3	create__
created	10	43	2345	3	create_d
creates	9	52	2520	3	create_s
creator	9	37	1444	3	creator_
creators	10	28	1441	3	creators
creature	10	3	874	3	creature
creeper	11	33	998	3	creeper_
creepers	12	31	863	3	creepers
creepy	13	41	880	3	cre__epy
crematory	16	4	721	3	crematory
creme	9	43	1932	3	cre_me__
cremes	10	45	1799	3	cre_me_s
crenately	14	4	478	3	crenately
crepey	13	51	1093	3	cre_pe_y
crepier	11	3	974	3	crepier_
crewmen	14	3	638	3	crewme_n
crimmer	13	33	1077	3	crimmer_
crimmers	14	29	854	3	crimmers
croaker	13	30	1068	3	croaker_
croakers	14	28	852	3	croakers
crockery	19	35	660	3	crockery
crookery	17	41	599	3	crookery
deanery	11	3	761	3	_deanery
dramedy	14	3	324	3	dr_amedy
drapery	13	38	794	3	dr_apery
dreamed	11	43	1063	3	dreame_d
dreamier	11	28	729	3	dreamier_
dreamily	14	3	514	3	dreamily
dreamy	12	50	999	3	dream__y
dreary	10	46	1167	3	drea__ry
eatery	9	53	1635	3	__eatery
emery	10	48	1433	3	__e_mery
framer	11	48	1744	3	fr_amer_
framers	12	51	1382	3	fr_amers
gleamer	10	32	851	3	gleamer_
gleamers	11	30	656	3	gleamers
gramary	13	5	591	3	gr_amary
gramercy	16	4	192	3	gr_amercy
grapery	13	45	795	3	gr_apery
greaser	8	39	1308	3	greaser_
greasers	9	34	1025	3	greasers
greater	8	44	1649	3	greater_
greenery	12	26	592	3	greenery
preaver	12	10	1161	3	preaver_
preavers	13	9	1026	3	preavers
reader	7	36	2829	3	_reader_
readerly	12	4	508	3	_readerly
readers	8	38	2377	3	_readers
realer	6	35	2859	3	_realer_
reamed	9	43	2612	3	_reame_d
reaper	8	42	2314	3	_reaper_
reapers	9	35	2045	3	_reapers
rearer	6	49	2891	3	_rearer_
rearers	7	43	2356	3	_rearers
reaver	9	45	2473	3	_reaver_
reavers	10	83	2074	3	_reavers
remarry	12	3	519	3	_remarry
remedy	12	3	787	3	_re_medy
revery	12	40	1421	3	_re_very
roamer	8	47	1516	3	_roamer_
roamers	9	37	1346	3	_roamers
screamed	13	27	760	3	screame_d
sealery	10	40	1105	3	_sealery
seamer	8	42	2361	3	_seamer_
seamers	9	47	1943	3	_seamers
steamer	9	33	1309	3	steamer_
steamers	10	34	1087	3	steamers
stemmery	15	33	469	3	stemmery
streamer	10	23	951	3	streamer_
streamers	11	22	807	3	streamers
tracery	12	39	979	3	tr_acery
treachery	17	4	469	3	treachery
treader	8	41	1383	3	treader_
treaders	9	33	1184	3	treaders
treasury	11	4	379	3	treasury
treater	7	42	1983	3	treater_
treaters	8	36	1584	3	treaters
wreaker	14	36	1004	3	wreaker_
wreakers	15	32	842	3	wreakers

Search took 10 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.453	394461.4
2	DLD Change Limit	146162	135	8.860	16496.8
3	Display Results	135	135	0.046	2934.8
	(SQL Overall)	178691	135	9.359	19093.0