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

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

81 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
laminarians	13	5	438	(None)
laminarian	12	4	532	1	laminarian_
laminarias	12	4	532	1	laminaria_s
laminarins	12	4	587	1	laminari_ns
laminaria	11	4	518	2	laminaria__
laminarin	11	4	608	2	laminari_n_
laminations	13	3	980	2	laminations
luminarias	12	5	475	2	luminaria_s
seminarians	13	5	513	2	seminarians
apiarians	11	4	665	3	_api_arians
culinarians	13	5	479	3	culinarians
laminating	13	4	872	3	laminati_ng
lamination	12	3	1122	3	lamination_
laminins	10	3	913	3	lamin__i_ns
lapidarian	13	5	383	3	lapidarian_
luminaria	11	4	477	3	luminaria__
luminaries	12	4	659	3	luminari_es
lunarians	9	4	551	3	l__unarians
planarians	12	4	519	3	pla__narians
sanitarians	11	4	624	3	sanitarians
seminarian	12	5	678	3	seminarian_
agrarians	10	4	579	4	_a_grarians
alcyonarians	17	6	164	4	alcyonarians
alfilarias	13	16	364	4	alfilaria_s
alizarins	18	4	589	4	_alizari_ns
apiarian	10	4	832	4	_api_arian_
aquarians	18	4	587	4	_a_quarians
barbarians	14	4	503	4	ba_rbarians
caesarians	12	4	494	4	ca_esarians
cnidarians	13	5	366	4	_cnidarians
culinarian	12	5	599	4	culinarian_
damnations	13	3	708	4	dam_nations
deaminations	15	10	1013	4	deaminations
delaminations	16	4	794	4	delaminations
dominations	14	6	1104	4	dominations
egalitarians	13	6	431	4	egalitarians
eliminations	14	4	761	4	eliminations
examinations	21	6	746	4	examinations
fruitarians	14	5	373	4	fruitarians
geminations	14	13	925	4	geminations
grammarians	16	5	247	4	gram_marians
hominians	14	4	591	4	homin__ians
jubilarians	20	5	276	4	jubilarians
laciniations	14	4	591	4	laciniations
lacunaria	11	4	379	4	lacunaria__
lamebrains	14	4	338	4	lamebrai_ns
lamentations	14	9	598	4	lamentations
laminals	10	33	930	4	lamin___als
laminar	9	38	1028	4	laminar____
laminary	13	33	725	4	laminar___y
laminas	9	36	1587	4	lamin___a_s
laminates	11	27	1290	4	lamina__tes
laminators	12	4	705	4	lamina_tors
laminin	9	3	997	4	lamin__i_n_
laminitis	11	4	624	4	lamin__itis
laminitises	13	4	438	4	laminitises
laniaries	9	4	1121	4	lani_ari_es
lapidaries	13	4	506	4	lapidari_es
latimerias	12	5	369	4	latimeria_s
librarians	12	6	395	4	l_ibrarians
limitations	13	4	818	4	limitations
luminaires	12	4	352	4	lumina_ires
lunarian	8	4	729	4	l__unarian_
mammalians	13	5	248	4	mam_malians
marinaras	11	4	556	4	marinar_a_s
marinations	13	4	1127	4	marinations
nominations	13	4	1053	4	nominations
paginations	14	4	775	4	paginations
patinations	13	4	1100	4	patinations
planarian	11	4	711	4	pla__narian_
planarias	11	4	740	4	pla__naria_s
radiolarians	13	14	295	4	radiolarians
ruminations	13	4	939	4	ruminations
samaritans	12	4	293	4	sam__aritans
sanitarian	10	4	744	4	sanitarian_
seminaries	12	4	1000	4	seminari_es
seminarists	13	7	539	4	seminarists
tamarins	10	3	1084	4	tam__ari_ns
uncinarias	12	14	471	4	uncinaria_s
unitarians	10	4	608	4	_unitarians
zamindaris	22	5	189	4	zamindari__s

Search took 9 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.450	397091.1
2	DLD Change Limit	148819	81	8.220	18104.5
3	Display Results	81	81	0.046	1760.9
	(SQL Overall)	178691	81	8.716	20501.5