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

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

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.

46 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
cinerary	13	4	643	(None)
cineraria	11	4	511	2	cineraria
contrary	13	4	749	2	contrary
funerary	14	4	364	2	funerary
itinerary	12	5	234	2	itinerary
literary	11	4	775	2	literary
vinegary	15	4	389	2	vinegary
binary	11	3	1222	3	bin__ary
canary	11	3	1469	3	can__ary
caneware	13	4	780	3	caneware
catenary	13	4	658	3	catenary
cedary	12	41	960	3	c__edary
centenary	14	4	432	3	centenary
cherry	14	48	1076	3	c_her_ry
ciliary	12	4	792	3	ci_liary
cindery	13	42	919	3	cin_dery
cineast	9	3	1052	3	cine_ast
cinema	10	4	765	3	cinema__
cinemas	11	3	804	3	cinema_s
cinerarias	12	4	523	3	cinerarias
cinerarium	14	5	344	3	cinerarium
cinerin	9	3	1382	3	ciner_in
cinerins	10	4	1410	3	cinerins
cometary	15	4	769	3	cometary
dietary	11	5	866	3	di_etary
finery	12	45	1289	3	fine__ry
honorary	14	4	580	3	honorary
inertly	10	3	854	3	_inertly
itineracy	14	5	216	3	itineracy
library	12	4	532	3	li_brary
linear	6	51	1334	3	line_ar_
linearly	11	4	679	3	linearly
literacy	13	4	680	3	literacy
mineral	9	3	1273	3	minera_l
minerals	10	3	1138	3	minerals
monetary	13	4	652	3	monetary
ninebark	14	4	425	3	ninebark
numerary	13	4	428	3	numerary
pinery	11	52	1429	3	pine__ry
vicenary	16	5	497	3	vicenary
vinegar	11	3	461	3	vinegar_
vinegars	12	4	506	3	vinegars
vinery	12	49	1260	3	vine__ry
vineyard	15	4	398	3	vineyard
vulnerary	15	5	177	3	vulnerary
winery	12	50	1428	3	wine__ry

Search took 8 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.406	440125.6
2	DLD Change Limit	146162	46	7.300	20022.2
3	Display Results	46	46	0.013	3538.5
	(SQL Overall)	178691	46	7.719	23149.5