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

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

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.

71 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
documentaries	18	6	326	(None)
documentarian	18	14	303	2	documentarian
documentarians	19	16	264	2	documentarians
documentarily	21	6	264	2	documentarily
documentarist	18	16	397	2	documentarist
documentarists	19	11	312	2	documentarists
commentaries	18	5	680	3	co_mmentaries
documentable	19	8	251	3	documentable_
documentalist	18	14	489	3	documentalist
documentalists	19	15	395	3	documentalists
documentary	19	5	306	3	documentar__y
documentation	18	14	472	3	documentation
documentations	19	14	448	3	documentations
documenters	16	5	281	3	documenter__s
decenaries	13	4	812	4	dec__en_aries
decennaries	14	5	426	4	dec__ennaries
documental	15	5	451	4	documenta___l
documented	16	5	320	4	document___ed
documenter	15	5	328	4	document___er
documenting	17	5	312	4	document__ing
documents	14	4	652	4	document____s
dosimetries	14	5	475	4	dosime_t_ries
monumentalizes	27	12	348	4	monumentalizes
voluntaries	14	5	412	4	volu__ntaries
ancientries	13	5	452	5	anc_ient_ries
boundaries	13	4	511	5	bo_u__ndaries
catenaries	12	4	867	5	__caten_aries
cemeteries	14	4	738	5	__ceme_teries
centares	10	29	1389	5	__c__entar_es
centauries	12	4	553	5	__c__entauries
centuries	11	3	1133	5	__c__enturies
columbaries	17	5	340	5	colum__baries
commentates	17	10	761	5	co_mmenta_tes
complementaries	23	7	234	5	complementaries
coquetries	21	4	602	5	coqu_e_t_ries
countries	11	3	1361	5	co_u__nt_ries
decentres	12	23	852	5	dec__ent_r_es
decimetres	15	13	504	5	decime_t_r_es
dicentrics	15	4	467	5	dic__ent_rics
dictionaries	15	5	478	5	diction_aries
dietaries	10	4	1066	5	d___ie_taries
dispensaries	15	5	376	5	d_ispensaries
doctrinaires	15	6	169	5	doctrin_aires
document	13	4	866	5	document_____
documentational	20	6	196	5	documentational
dominatrices	17	5	180	5	do__minatrices
dormitories	14	6	368	5	do_rm_itories
dromedaries	15	5	310	5	d_rome_daries
dysenteries	15	5	428	5	d__ysenteries
frumenties	15	4	444	5	_frument__ies
iodometries	14	5	593	5	iodome_t_ries
locutories	12	4	464	5	locu___tories
luminaries	12	4	659	5	__lumin_aries
maumetries	14	4	602	5	_maume_t_ries
momentarily	18	5	330	5	mo__mentarily
momentariness	17	6	293	5	mo__mentariness
monumentalities	19	6	244	5	monumentalities
monumentality	20	6	388	5	monumentality
monumentalize	26	12	383	5	monumentalize
monumentalized	28	12	304	5	monumentalized
nonentries	10	4	828	5	no__nent_ries
octonaries	12	4	600	5	_oc_ton_aries
odometries	13	4	682	5	_odome_t_ries
oximetries	19	4	456	5	_oxime_t_ries
rocketries	16	4	589	5	roc_ke_t_ries
secretaries	13	4	542	5	sec_re_taries
sociometries	16	5	500	5	sociome_t_ries
subentries	12	4	643	5	__subent_ries
tonometries	13	4	721	5	tonome_t_ries
udometries	13	4	592	5	udo__me_t_ries
zoometries	21	4	707	5	zo_ome_t_ries

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	124790	0.376	475242.0
2	DLD Change Limit	124790	71	8.470	14733.2
3	Display Results	71	71	0.046	1543.5
	(SQL Overall)	178691	71	8.892	20095.7