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

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

82 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
laminary	13	33	725	(None)
laminar	9	38	1028	1	laminar_
luminary	13	33	665	1	luminary
lacunary	13	11	415	2	lacunary
lamina	8	49	2044	2	lamina__
laminae	9	35	1297	2	lamina_e
laminal	9	41	1363	2	lamina_l
laminals	10	33	931	2	laminals
laminaria	11	4	518	2	laminaria
laminarin	11	4	608	2	laminarin
laminas	9	36	1587	2	lamina_s
laminate	10	30	1463	2	laminate
laniary	10	6	801	2	lani_ary
lapidary	14	5	409	2	lapidary
limitary	13	4	493	2	limitary
seminary	13	9	810	2	seminary
acinar	8	3	1048	3	_acinar_
almonry	12	10	473	3	almon_ry
ambary	13	40	1054	3	_am_bary
aminity	12	3	1051	3	_aminity
apiary	11	39	1038	3	_api_ary
ariary	9	41	1420	3	_ari_ary
aviary	12	33	841	3	_avi_ary
basilary	13	4	507	3	basilary
binary	11	3	1222	3	__binary
canary	11	3	1469	3	ca__nary
catenary	13	4	658	3	catenary
cavitary	16	6	496	3	cavitary
culinary	13	5	585	3	culinary
feminacy	18	4	445	3	feminacy
flamingly	18	4	503	3	flamingly
hymnary	18	4	303	3	hym_nary
imaginary	15	5	250	3	imaginary
janisary	18	4	362	3	janisary
janizary	27	4	248	3	janizary
lactary	12	3	785	3	la_ctary
lacunar	9	13	629	3	lacunar_
lacunars	10	11	473	3	lacunars
lamasery	13	4	395	3	lamasery
lamia	7	53	2432	3	lami_a__
lamiae	8	48	1745	3	lami_a_e
lamias	8	50	2061	3	lami_a_s
laminable	13	3	712	3	laminable
laminarian	12	4	532	3	laminarian
laminarias	12	4	532	3	laminarias
laminarins	12	4	587	3	laminarins
laminated	12	26	1028	3	laminated
laminates	11	27	1290	3	laminates
laminator	11	4	755	3	laminator
laminators	12	4	705	3	laminators
laming	9	45	2836	3	lamin__g
laminin	9	3	997	3	lamin_in
laminins	10	3	913	3	laminins
laminose	10	3	691	3	laminose
laminous	10	3	795	3	laminous
laniard	8	6	852	3	lani_ard
latina	6	56	2114	3	latina__
latinas	7	44	1646	3	latina_s
latinity	11	3	881	3	latinity
laundry	11	3	351	3	la_undry
legionary	13	4	365	3	legionary
limina	8	35	1450	3	limina__
liminal	9	38	1067	3	limina_l
lumina	8	46	1354	3	lumina__
luminaire	11	4	393	3	luminaire
luminal	9	37	1100	3	lumina_l
luminaria	11	4	477	3	luminaria
mammary	13	3	599	3	mam_mary
marinara	10	4	649	3	marinara
ordinary	12	4	491	3	ordinary
plagiary	14	4	364	3	plagi_ary
quinary	19	3	693	3	_quinary
salivary	14	4	473	3	salivary
sanitary	11	4	675	3	sanitary
seminar	9	7	976	3	seminar_
seminars	10	7	905	3	seminars
trinary	10	3	917	3	_trinary
urinary	10	3	724	3	_urinary
zamindar	20	4	240	3	zamindar_
zamindari	21	5	198	3	zamindari
zamindars	21	4	236	3	zamindars
zemindary	24	4	267	3	zemindary

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.423	422437.4
2	DLD Change Limit	146162	82	7.200	20300.3
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	7.656	23340.0