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

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

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

285 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
finials	10	32	1015	(None)
finals	9	43	1616	1	fin_als
finial	9	28	1418	1	finial_
denials	8	41	1413	2	denials
facials	12	33	1074	2	facials
fecials	12	35	1033	2	fecials
fetials	10	37	1174	2	fetials
filial	9	30	1325	2	filial_
final	8	39	2203	2	fin_al_
finale	9	41	1676	2	fin_ale
finales	10	40	1601	2	fin_ales
finalis	10	33	1366	2	fin_alis
fincas	11	35	1207	2	finca_s
finialed	12	5	550	2	finialed
finical	12	3	969	2	finical_
finings	11	43	1177	2	finings
finis	8	68	2426	2	fini__s
finises	10	3	1290	2	finises
finites	10	3	1592	2	finites
fiscals	12	3	800	2	fiscals
fungals	11	27	678	2	fungals
gingals	9	10	931	2	gingals
jingals	15	8	807	2	jingals
menials	9	40	1568	2	menials
minimals	12	32	743	2	minimals
pineals	9	32	1284	2	pineals
tincals	9	36	1064	2	tincals
vinals	9	47	1648	2	vin_als
aerials	7	40	1755	3	aerials
agnails	8	3	700	3	agnails
anils	5	63	2672	3	_ani_ls
animals	9	41	1170	3	animals
annals	6	64	1592	3	_annals
anneals	7	44	994	3	anneals
annuals	7	38	819	3	annuals
banians	9	3	1203	3	banians
biennials	11	8	363	3	biennials
binal	7	53	2382	3	bin_al_
binits	8	57	1667	3	bini_ts
binomials	13	4	390	3	binomials
burials	9	36	1208	3	burials
canals	8	44	2166	3	can_als
cantals	9	39	1957	3	cantals
centals	9	43	1705	3	centals
cineols	9	12	885	3	cineols
citrals	9	11	1167	3	citrals
denial	7	47	2051	3	denial_
dentals	8	39	1539	3	dentals
dials	6	49	2534	3	__dials
digitals	10	4	543	3	digitals
dinars	7	54	1756	3	din_ars
dismals	10	20	1024	3	dismals
espials	9	3	709	3	espials
facial	11	36	1563	3	facial_
facias	11	34	1580	3	facia_s
fails	8	56	3148	3	f_ai_ls
fallals	10	33	1019	3	fallals
fangas	10	50	1719	3	fanga_s
fanions	10	37	1307	3	fanions
fantails	11	3	969	3	fantails
farfals	13	26	850	3	farfals
faucals	12	32	656	3	faucals
fecial	11	47	1462	3	fecial_
fennels	10	38	790	3	fennels
ferals	9	42	1664	3	f_erals
ferial	9	46	2125	3	ferial_
ferias	9	50	2039	3	feria_s
fetial	9	57	1619	3	fetial_
fetiales	11	31	961	3	fetiales
fetialis	11	35	866	3	fetialis
fiars	8	67	2083	3	f__iars
fiats	8	53	2448	3	f__iats
fibrils	12	3	684	3	fibrils
fibulas	12	22	856	3	fibulas
ficins	11	35	1398	3	fici_ns
filially	14	4	700	3	filially
filiate	10	4	1423	3	filiate
filiates	11	4	1266	3	filiates
filings	11	52	1307	3	filings
fills	8	46	3237	3	f__ills
fils	7	58	3869	3	f__i_ls
finable	12	22	1362	3	finable
finagle	11	23	831	3	finagle
finagles	12	23	755	3	finagles
finalise	11	31	1257	3	fin_alise
finalism	13	30	1036	3	fin_alism
finalist	11	30	1473	3	fin_alist
finally	13	3	1010	3	finally
finback	18	6	582	3	finback
finbacks	19	6	536	3	finbacks
finca	10	47	1450	3	finca__
finches	15	39	1419	3	finches
findable	14	17	902	3	findable
finders	11	37	1787	3	finders
findings	13	32	844	3	findings
finds	9	54	2482	3	fin__ds
fineable	13	18	1033	3	fineable
finely	12	30	1156	3	fin_ely
fines	8	66	4426	3	fin__es
fingers	11	34	1843	3	fingers
finically	17	4	795	3	finically
finicky	19	4	371	3	finicky
finikin	14	26	686	3	finikin
fining	10	42	2321	3	fini_ng
finish	12	46	1341	3	fini_sh
finishes	14	3	898	3	finishes
finite	9	3	1682	3	fini_te
finitely	14	4	566	3	finitely
finito	9	3	1030	3	fini_to
finks	12	54	2422	3	fin__ks
finless	10	28	1078	3	finless
finmark	16	15	488	3	finmark
finmarks	17	15	447	3	finmarks
finos	8	62	2695	3	fin__os
fins	7	58	4909	3	fin___s
firings	11	41	1233	3	firings
firmans	12	23	852	3	firmans
fiscal	11	3	933	3	fiscal_
fixings	18	34	744	3	fixings
flails	9	43	1300	3	flai_ls
florals	10	42	1006	3	florals
foals	8	57	2169	3	f__oals
foils	8	50	2581	3	f_oi_ls
fontal	9	3	1314	3	fontal_
formals	12	33	1289	3	formals
frails	9	37	1647	3	frai_ls
friars	9	38	1209	3	f_riars
frills	9	44	1422	3	f_rills
frontals	11	4	627	3	frontals
funerals	11	4	645	3	funerals
fungal	10	38	873	3	fungal_
funicle	12	23	748	3	funicle
funicles	13	24	683	3	funicles
funkias	14	3	538	3	funkia_s
funnels	10	34	817	3	funnels
fusils	9	39	1234	3	fusi_ls
fuzils	18	40	796	3	fuzi_ls
gavials	11	3	660	3	gavials
genial	7	49	1761	3	genial_
genitals	9	3	724	3	genitals
gimbals	12	25	782	3	gimbals
gimmals	12	22	582	3	gimmals
gingal	8	10	1015	3	gingal_
gingall	9	11	733	3	gingall
gingalls	10	9	643	3	gingalls
ideals	7	50	1250	3	_ideals
iliads	7	44	867	3	_iliads
ilial	5	53	1784	3	_ilial_
indols	7	47	1420	3	_indols
infall	9	3	940	3	_infall
infalls	10	3	894	3	_infalls
inhale	9	4	1151	3	_inhale
inhales	10	5	1186	3	_inhales
inhauls	10	3	552	3	_inhauls
inia	4	50	2470	3	_inia__
inions	6	44	1700	3	_inions
initials	8	4	810	3	initials
inlays	9	38	987	3	_inlays
instals	7	6	1171	3	_instals
invars	9	3	1000	3	_invars
inwall	9	3	834	3	_inwall
inwalls	10	3	728	3	_inwalls
ixias	12	48	837	3	_ixia_s
jingal	14	9	859	3	jingal_
jingall	15	6	617	3	jingall
jingalls	16	8	533	3	jingalls
kinas	9	56	2691	3	kin_a_s
kinins	10	40	1458	3	kini_ns
labials	9	29	987	3	labials
lanitals	8	3	772	3	lanitals
linacs	8	3	1081	3	lin_acs
lineal	6	56	1602	3	lineal_
lingams	10	45	1019	3	lingams
lingas	7	51	1657	3	linga_s
linguals	9	31	722	3	linguals
linings	8	43	1307	3	linings
linins	6	59	2214	3	lini_ns
lintels	7	33	1116	3	lintels
lintols	7	33	955	3	lintols
maniacs	11	43	1306	3	maniacs
manias	8	40	2903	3	mania_s
manilas	9	39	1587	3	manilas
manuals	9	3	1121	3	manuals
medials	10	39	1473	3	medials
menial	8	42	2303	3	menial_
minas	7	54	3411	3	min_a_s
minerals	10	3	1137	3	minerals
minibars	12	9	655	3	minibars
minibus	11	3	634	3	minibus
minicabs	14	13	506	3	minicabs
minicams	14	12	686	3	minicams
minicars	12	11	851	3	minicars
minilab	11	12	600	3	minilab
minilabs	12	12	457	3	minilabs
minimal	11	40	1060	3	minimal_
minims	10	45	1481	3	mini_ms
minings	10	39	1207	3	minings
minions	9	33	1462	3	minions
minis	7	54	3299	3	mini__s
miniums	11	39	1022	3	miniums
minivans	13	4	541	3	minivans
minyans	12	3	726	3	minyans
misdials	11	3	749	3	misdials
miskals	13	36	976	3	miskals
missals	9	39	1442	3	missals
nails	5	57	3040	3	__nails
nihils	9	3	757	3	nihi_ls
nills	5	49	2667	3	__nills
nils	4	61	3245	3	__ni_ls
ninjas	13	8	630	3	ninja_s
officials	17	4	340	3	officials
penial	8	41	2089	3	penial_
phials	11	5	887	3	_phials
pibals	10	38	1308	3	pi_bals
pinas	7	54	3445	3	pin_a_s
pinball	11	3	793	3	pinball
pinballs	12	4	693	3	pinballs
pineal	8	48	1768	3	pineal_
pinions	9	34	1360	3	pinions
pinites	9	3	1953	3	pinites
pinitols	10	4	610	3	pinitols
pinnal	8	48	1427	3	pinnal_
pinnas	8	53	1551	3	pinna_s
pintails	10	3	1016	3	pintails
pintas	8	50	2139	3	pinta_s
pinwale	12	5	784	3	pinwale
pinwales	13	6	796	3	pinwales
pipals	10	42	1364	3	pi_pals
qindars	17	26	742	3	qindars
qintars	16	26	857	3	qintars
quintals	17	28	800	3	quintals
radials	8	36	1463	3	radials
redials	8	44	1688	3	redials
renails	7	49	1726	3	renails
rentals	7	40	1747	3	rentals
rials	5	50	2667	3	__rials
ringhals	12	5	626	3	ringhals
rituals	7	3	835	3	rituals
rivals	9	42	1318	3	ri_vals
riyals	9	41	1108	3	ri_yals
sandals	8	27	1520	3	sandals
sendals	8	19	1226	3	sendals
serials	7	39	1974	3	serials
sials	5	42	2724	3	__sials
sigils	7	39	1236	3	sigi_ls
signals	8	35	916	3	signals
simians	9	5	920	3	simians
sisals	6	30	1357	3	si_sals
snails	6	48	1665	3	_snails
socials	9	9	963	3	socials
spinals	9	39	1186	3	spin_als
sundials	9	4	675	3	sundials
tenails	7	37	1392	3	tenails
tenias	6	47	2007	3	tenia_s
tibial	8	4	984	3	tibial_
tibias	8	3	995	3	tibia_s
ticals	8	32	1471	3	ti_cals
timbals	11	23	953	3	timbals
tincal	8	39	1336	3	tincal_
tineal	6	62	1616	3	tineal_
tineas	6	46	1648	3	tinea_s
tinfuls	10	3	659	3	tinfuls
tinily	9	40	1443	3	tini_ly
tinsels	7	3	837	3	tinsels
titians	7	27	1045	3	titians
trials	6	43	1988	3	_trials
uncials	9	25	1052	3	uncials
unnails	7	3	822	3	unnails
urials	6	44	1519	3	_urials
urinals	7	6	1025	3	urin_als
vandals	11	32	1166	3	vandals
venial	9	42	1828	3	venial_
vials	8	58	2238	3	__vials
vigias	10	41	1089	3	vigia_s
vigils	10	42	1019	3	vigi_ls
vinal	8	57	2581	3	vin_al_
vinas	8	51	2634	3	vin_a_s
vincas	11	39	1245	3	vinca_s
vineal	9	48	1474	3	vineal_
vinyls	12	46	700	3	vin_yls
visuals	10	3	685	3	visuals
vitals	9	45	1430	3	vi_tals
xenial	13	34	1490	3	xenial_
xenias	13	37	1297	3	xenia_s
zinnias	16	3	586	3	zinnia_s

Search took 7 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	134027	0.156	1145455.1
2	DLD Change Limit	134027	285	6.690	20033.9
3	Display Results	285	285	0.110	2590.9
	(SQL Overall)	178691	285	6.956	25688.8