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

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

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.

66 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
columbaries	17	5	340	(None)
columbaria	16	5	204	2	columbari_a
columbarium	19	5	172	2	columbarium
calamaries	14	4	688	3	calam_aries
colombards	17	5	248	3	colombar_ds
colubrids	14	4	360	3	colu_b_rids
columbary	18	4	296	3	columbar__y
columbines	16	4	376	3	columb_ines
columbites	16	4	369	3	columb_ites
costmaries	14	4	691	3	costm_aries
coumarins	13	4	702	3	co_um_arins
plumberies	16	4	512	3	_plumberies
voluntaries	14	5	412	3	voluntaries
ambaries	12	33	1238	4	___ambaries
boundaries	13	4	511	4	bo_undaries
calamaris	13	4	608	4	calam_ari_s
calumnies	13	4	604	4	calum__nies
calvaries	14	4	980	4	cal__varies
celibacies	16	4	315	4	cel_ibacies
clambakes	19	4	331	4	c_lamba_kes
claries	9	34	2220	4	c_l___aries
cloudberries	17	5	180	4	cloudberries
clumbers	14	39	1041	4	c_lumber__s
coembodies	17	4	296	4	co_embodies
colemanites	15	4	470	4	colem_anites
collieries	12	4	833	4	col_lieries
colombard	16	4	315	4	colombar__d
colubrid	13	4	441	4	colu_b_ri_d
colubrine	13	4	504	4	colu_b_rine
columbic	16	4	344	4	columb__i_c
columbine	15	4	426	4	columb__ine
columbite	15	4	397	4	columb__ite
columbium	17	4	322	4	columb__ium
columbiums	18	5	263	4	columb_iums
columnar	12	4	371	4	columnar___
colures	9	3	1514	4	colu___r_es
companies	15	3	1180	4	co__mpanies
compares	14	38	1643	4	co__mpar_es
contraries	12	7	1193	4	co_ntraries
contumacies	17	5	414	4	contum_acies
coquetries	21	4	602	4	coqu_etries
corollaries	13	5	499	4	corollaries
coronaries	12	4	1023	4	co_ronaries
costumeries	15	5	410	4	costum_eries
coulometries	16	5	465	4	coulometries
coumaric	14	4	618	4	co_um_ari_c
coumarin	12	4	732	4	co_um_ari_n
coumarones	14	4	386	4	co_um_arones
coumarous	13	8	578	4	co_um_arous
countries	11	3	1361	4	co_u_ntries
cousinries	12	4	469	4	co_usinries
covaries	13	4	1325	4	co___varies
coxcombries	26	5	135	4	coxcomb_ries
cumarins	12	3	864	4	c__um_arins
flummeries	17	4	376	4	_flummeries
formularies	16	5	416	4	formularies
lumbars	11	28	976	4	__lumbar__s
luminaries	12	4	659	4	__luminaries
polyparies	17	4	783	4	pol_yparies
polyzoaries	25	5	370	4	polyzoaries
rosemaries	12	4	603	4	rosem_aries
solitaries	10	4	1012	4	sol_itaries
summaries	13	11	818	4	__summaries
syllabaries	16	5	251	4	syllabaries
turbaries	11	4	774	4	__turbaries
voluptuaries	17	6	155	4	voluptuaries

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	148819	0.423	422437.4
2	DLD Change Limit	148819	66	9.373	15877.4
3	Display Results	66	66	0.033	2000.0
	(SQL Overall)	178691	66	9.829	18180.0