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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

116 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
frivolities	17	4	404	(None)
civilities	15	4	784	3	_civilities
fidelities	14	4	593	3	f_idelities
finalities	13	4	990	3	f_inalities
fragilities	15	4	716	3	fragilities
friabilities	17	8	917	3	friabilities
frigidities	16	4	402	3	frigidities
frivolity	18	4	306	3	frivolit__y
frugalities	15	4	416	3	frugalities
primalities	15	4	829	3	primalities
priorities	12	4	915	3	pri_orities
privities	14	3	1204	3	priv__ities
rimosities	12	4	663	3	_rimosities
trivialities	15	5	522	3	trivialities
abilities	11	7	1414	4	abi__lities
adiposities	14	4	510	4	adiposities
agilities	10	8	1097	4	agi__lities
anilities	9	5	1600	4	ani__lities
animalities	13	4	899	4	animalities
animosities	13	4	491	4	animosities
apriorities	13	4	540	4	apri_orities
arabilities	13	4	1310	4	arabilities
aridities	10	9	1163	4	ari__dities
axialities	17	4	773	4	axi_alities
brevities	14	4	642	4	brev__ities
briolettes	12	4	385	4	bri_olettes
brutalities	13	4	544	4	brutalities
cariosities	13	4	647	4	cari_osities
chiralities	16	4	651	4	chiralities
coevalities	16	4	680	4	coevalities
credulities	14	4	413	4	credulities
crinolines	12	4	673	4	crinoli_nes
cryolites	14	4	696	4	cr_yolit_es
curiosities	13	4	498	4	curi_osities
divinities	14	4	773	4	_divinities
drivabilities	19	4	726	4	drivabilities
drivelines	14	4	459	4	driveli_nes
edibilities	14	5	870	4	edibilities
facilities	15	4	982	4	f_acilities
farcicalities	20	5	357	4	farcicalities
fatalities	13	4	944	4	f_atalities
favorites	15	4	658	4	f_avorit_es
febrilities	16	4	514	4	febrilities
ferocities	15	4	824	4	f_erocities
fertilities	14	4	882	4	fertilities
fervidities	18	6	394	4	fervidities
feudalities	15	4	534	4	feudalities
fissilities	14	4	564	4	fissilities
fixities	18	3	821	4	f_i__xities
formalities	16	13	782	4	formalities
frailties	12	4	585	4	fr_ail_ties
frijoles	18	3	437	4	frijol___es
frivoled	15	3	404	4	frivol___ed
frivoler	14	4	393	4	frivol___er
frivolers	15	4	347	4	frivol__ers
frivoling	16	4	449	4	frivol__ing
frivolled	16	4	238	4	frivol__led
frivoller	15	4	243	4	frivol__ler
frivollers	16	4	207	4	frivol_lers
frivolling	17	4	276	4	frivol_ling
frivolous	15	5	316	4	frivol__ous
frivols	13	3	474	4	frivol____s
frontalities	15	5	557	4	frontalities
fusibilities	17	4	623	4	fusibilities
futilities	13	4	886	4	f_utilities
gracilities	14	4	768	4	gracilities
gravidities	16	4	413	4	gravidities
gravities	13	3	830	4	grav__ities
incivilities	17	5	633	4	incivilities
iolites	7	38	1948	4	__i_olit_es
iridologies	13	4	458	4	iridologies
irrealities	11	4	621	4	irrealities
jovialities	21	4	516	4	jovialities
kilolitres	14	4	272	4	_kilolitres
kryolites	16	4	399	4	kr_yolit_es
lividities	14	4	558	4	_lividities
minorities	12	4	946	4	_minorities
nervosities	14	5	467	4	nervosities
nihilities	13	4	866	4	_nihilities
oralities	9	12	1412	4	or__alities
otiosities	10	4	645	4	oti_osities
ovalities	12	11	980	4	__ovalities
pilosities	12	4	780	4	_pilosities
piosities	11	3	1172	4	_pi_osities
pisolites	11	4	938	4	_pisolit_es
polities	10	27	2234	4	___polities
precocities	17	4	816	4	precocities
prioritizes	22	5	427	4	pri_oritizes
probities	13	3	1265	4	pr__obities
ramosities	12	4	686	4	_ramosities
realities	9	3	1631	4	_r_ealities
regalities	11	4	1059	4	_regalities
rhyolites	15	4	503	4	_rhyolit_es
rigidities	12	4	629	4	_rigidities
rivalries	12	4	500	4	_rival_ries
rugosities	11	4	472	4	_rugosities
ruralities	10	4	857	4	_ruralities
servilities	14	4	705	4	servilities
slivovitzes	26	5	64	4	slivovitzes
spinosities	13	4	494	4	spinosities
spiralities	13	4	801	4	spiralities
tremolites	12	5	605	4	tremolit_es
tribologies	14	4	612	4	tribologies
tricolettes	13	5	327	4	tricolettes
trilobites	12	4	438	4	trilobit_es
trinities	9	3	1334	4	tri__nities
triplites	11	4	828	4	tri_plit_es
triploidies	14	5	260	4	triploidies
triunities	10	4	610	4	tri_unities
utilities	9	6	1080	4	uti__lities
varicosities	17	5	346	4	varicosities
variolites	13	4	667	4	vari_olit_es
vinosities	13	4	680	4	_vinosities
virilities	13	7	912	4	_virilities
vitalities	13	4	909	4	_vitalities
vivacities	18	4	448	4	_vivacities

Search took 10 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.436	409841.7
2	DLD Change Limit	148819	116	9.203	16170.7
3	Display Results	116	116	0.063	1841.3
	(SQL Overall)	178691	116	9.702	18418.0