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

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

88 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
frontalities	15	5	559	(None)
atonalities	11	4	841	3	aton_alities
brutalities	13	4	544	3	br_utalities
dentalities	12	4	954	3	_dentalities
fatalities	13	4	944	3	f__atalities
finalities	13	4	991	3	f_in_alities
formalities	16	13	782	3	f_ormalities
frontality	16	5	418	3	frontalit__y
frontlines	13	4	519	3	front_li_nes
frugalities	15	4	416	3	fr_ugalities
mentalities	13	4	1002	3	_mentalities
mortalities	13	4	842	3	_mortalities
tonalities	10	17	1173	3	_ton_alities
totalities	10	12	1078	3	_to_talities
amoralities	13	4	742	4	amo_ralities
analities	9	7	1587	4	__an_alities
banalities	12	4	981	4	_ban_alities
carnalities	13	4	878	4	carn_alities
centralities	14	4	862	4	_centralities
coevalities	16	4	680	4	_coevalities
concavities	18	4	612	4	_concavities
cordialities	15	4	615	4	cordialities
erectilities	14	4	712	4	erectilities
eventualities	16	5	351	4	eventualities
factualities	17	5	453	4	factualities
farcicalities	20	5	357	4	farcicalities
fertilities	14	4	882	4	f_ertilities
feudalities	15	4	534	4	f_eudalities
fortalices	15	4	551	4	f_ortali_ces
fortuities	13	4	632	4	f_ort_uities
fragilities	15	4	716	4	fr_agilities
frailties	12	4	585	4	fr___ailties
friabilities	17	8	918	4	friabilities
frivolities	17	4	405	4	fr_ivolities
frontages	13	11	618	4	fronta___ges
frontals	11	4	627	4	frontal____s
frontenises	14	5	247	4	fronteni_ses
frontlets	12	4	423	4	front_let__s
frontline	12	4	505	4	front_li_ne_
frontlists	13	4	452	4	front_li_sts
frontolyses	17	5	218	4	frontol_yses
frontolysis	17	5	228	4	frontolysi_s
frostbites	15	4	299	4	frost_bit_es
frostlines	13	4	519	4	frost_li_nes
futilities	13	4	886	4	f__utilities
genialities	12	14	864	4	_genialities
gentilities	12	4	914	4	_gentilities
horizontalities	27	7	176	4	horizontalities
hostilities	14	12	765	4	_hostilities
immortalities	17	5	420	4	immortalities
irrealities	11	4	621	4	ir_realities
jovialities	21	4	516	4	_jovialities
linealities	11	4	822	4	_linealities
localities	12	5	973	4	_lo_calities
modalities	13	13	881	4	_mo_dalities
molalities	12	11	1028	4	_mo_lalities
moralities	12	11	1192	4	_mo_ralities
motilities	12	4	1058	4	_mo_tilities
natalities	10	4	1066	4	__natalities
nodalities	11	13	858	4	_no_dalities
nonparities	13	4	858	4	_nonparities
nonutilities	12	5	668	4	_nonutilities
normalities	13	14	811	4	_normalities
oralities	9	12	1412	4	__o_ralities
ovalities	12	11	980	4	__o_valities
penalities	12	13	1347	4	_pen_alities
personalities	15	5	647	4	person_alities
primalities	15	4	829	4	pr_imalities
printabilities	18	4	732	4	printabilities
prodigalities	17	6	393	4	prodigalities
profanities	16	7	625	4	pro_fanities
prostatitis	13	5	587	4	prostatiti_s
prostatitises	15	5	382	4	prostatitises
rascalities	13	4	722	4	_rascalities
realities	9	3	1631	4	_r__ealities
regalities	11	4	1059	4	_r_egalities
rentabilities	15	4	1126	4	_rentabilities
royalties	12	4	491	4	_ro_yal_ties
ruralities	10	4	857	4	_r_uralities
socialities	13	4	929	4	_socialities
sodalities	11	13	870	4	_so_dalities
spontaneities	15	6	227	4	spontaneities
tantalites	10	9	928	4	_tantalit_es
trivialities	15	5	522	4	trivialities
venalities	13	15	1072	4	_ven_alities
venialities	14	16	893	4	_venialities
vitalities	13	4	909	4	__vitalities
vocalities	15	4	939	4	_vo_calities

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	124790	0.390	458182.1
2	DLD Change Limit	124790	88	7.250	17212.4
3	Display Results	88	88	0.050	1760.0
	(SQL Overall)	178691	88	7.690	23236.8