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

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

317 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
gloria	7	19	1055	(None)
glorias	8	16	1032	1	glorias
alodia	7	11	1245	2	alodia
aporia	8	3	1586	2	aporia
coria	7	58	2832	2	_coria
flora	8	53	1710	2	flor_a
florid	10	3	1145	2	florid
florin	9	3	1265	2	florin
glia	5	64	2315	2	gl__ia
globin	9	30	972	2	globin
gloried	9	16	952	2	gloried
glories	8	19	1592	2	glories
glorify	14	4	458	2	glorify
glory	9	64	1329	2	glor_y
glossa	7	52	916	2	glossa
gonia	6	41	1753	2	g_onia
logia	6	81	1660	2	_logia
lorica	8	3	1044	2	_lorica
loris	5	53	2915	2	_loris
noria	5	57	2218	2	_noria
peloria	9	3	1095	2	peloria
scoria	8	5	1350	2	scoria
thoria	9	30	1289	2	thoria
agnosia	8	3	764	3	agnosia
agora	6	9	1433	3	agor_a
agria	6	55	1714	3	_agria
aldrin	7	3	1124	3	aldrin
alexia	13	29	1046	3	alexia
alforja	17	8	231	3	alforja
allodia	8	12	879	3	allodia
alodial	8	9	995	3	alodial
aloha	8	5	1362	3	alo_ha
aloin	5	52	2742	3	alo_in
anopia	8	34	1239	3	anopia
anoxia	13	35	1002	3	anoxia
anuria	6	3	1313	3	anuria
aorta	5	59	2257	3	_aorta
aporias	9	3	1516	3	aporias
aria	4	62	4543	3	__aria
atonia	6	38	1651	3	atonia
atria	5	60	2235	3	_atria
blooie	8	39	1319	3	blooie
bora	6	61	4163	3	_bor_a
boric	9	80	2422	3	_boric
caloric	11	34	1322	3	caloric
calorie	9	27	1690	3	calorie
celosia	9	3	946	3	celosia
ceria	7	51	2536	3	_ceria
chloric	14	34	1061	3	chloric
chlorid	13	32	1184	3	chlorid
chlorin	12	31	1300	3	chlorin
chorea	11	52	1609	3	chorea
chorial	12	42	1414	3	chorial
choric	13	35	1590	3	choric
ciboria	11	4	704	3	ciboria
clarkia	13	3	487	3	clarkia
cleric	10	6	1213	3	cleric
clerid	9	3	1241	3	clerid
clivia	11	7	723	3	clivia
cloaca	10	3	726	3	cloaca
clonic	10	49	1467	3	clonic
cobia	9	41	1751	3	_cobia
curia	7	45	2378	3	_curia
deliria	8	6	831	3	deliria
dorsa	6	46	1728	3	_dorsa
elodea	7	3	867	3	elodea
eloin	5	59	2320	3	elo_in
eluvia	9	3	613	3	eluvia
emporia	11	4	875	3	emporia
eulogia	8	4	666	3	eulogia
exordia	15	4	498	3	exordia
feria	8	59	2271	3	_feria
filaria	10	3	965	3	filaria
flooie	9	37	1215	3	flooie
florae	9	47	1388	3	florae
floral	9	43	1381	3	floral
floras	9	47	1569	3	floras
floret	9	3	2112	3	floret
florins	10	3	1164	3	florins
florist	10	3	1424	3	florist
floruit	10	4	729	3	floruit
flota	8	53	1564	3	flo_ta
fluoric	12	4	581	3	fluoric
fluorid	11	3	678	3	fluorid
fluorin	10	3	723	3	fluorin
folia	8	36	1893	3	_folia
fora	7	59	3739	3	_for_a
galabia	10	3	833	3	galabia
galleria	9	4	649	3	galleria
galore	7	35	1487	3	galor_e
galores	8	26	1434	3	galores
gambia	11	59	1225	3	gambia
garda	7	3	1677	3	g_arda
geodic	10	4	800	3	geodic
geoid	7	42	1576	3	geo_id
georgic	11	4	429	3	georgic
gharial	11	3	734	3	gharial
giardia	9	4	556	3	giardia
glacial	10	3	814	3	glacial
glacis	9	40	1213	3	glacis
glair	6	53	1355	3	gl_air
glaire	7	44	1130	3	glaire
glairs	7	52	1133	3	glairs
glairy	10	44	827	3	glairy
glare	6	52	2296	3	glar_e
glared	8	47	1520	3	glared
glares	7	55	1887	3	glares
glarier	8	41	1221	3	glarier
glaring	9	37	1488	3	glaring
glary	9	60	1854	3	glar_y
gleba	8	39	1024	3	gl_eba
glial	6	67	1543	3	gl__ial
glias	6	46	1849	3	gl__ias
glib	7	94	2144	3	gl__ib
glim	7	60	2635	3	gl__im
glioma	9	3	595	3	glioma
gloam	8	60	1594	3	glo_am
gloams	9	52	1066	3	gloams
gloat	6	54	2768	3	glo_at
gloats	7	45	1542	3	gloats
glob	7	66	2339	3	glo__b
global	9	3	766	3	global
globby	14	3	468	3	globby
globe	8	49	1701	3	glo_be
globed	10	48	1176	3	globed
globes	9	43	1454	3	globes
globing	11	32	1000	3	globing
globins	10	27	895	3	globins
globoid	11	4	597	3	globoid
globs	8	56	1640	3	glo_bs
glochid	14	4	526	3	glochid
glogg	8	3	735	3	glo_gg
gloggs	9	3	503	3	gloggs
glom	7	54	2438	3	glo__m
glomera	10	3	594	3	glomera
gloms	8	52	1978	3	glo_ms
glomus	9	46	809	3	glomus
glonoin	8	7	567	3	glonoin
gloom	8	71	1652	3	glo_om
glooms	9	62	1168	3	glooms
gloomy	12	52	876	3	gloomy
glop	7	67	2463	3	glo__p
gloppy	14	5	472	3	gloppy
glops	8	56	1955	3	glo_ps
gloriole	9	4	430	3	gloriole
glorious	9	4	682	3	glorious
glorying	13	3	554	3	glorying
gloss	6	43	1962	3	glo_ss
glossae	8	47	728	3	glossae
glossal	8	44	705	3	glossal
glossas	8	43	819	3	glossas
glossina	9	27	554	3	glossina
glossy	10	54	900	3	glossy
glost	6	54	2293	3	glo_st
glosts	7	45	1381	3	glosts
glottal	8	3	510	3	glottal
glottic	10	3	665	3	glottic
glottis	8	3	717	3	glottis
glout	6	59	2581	3	glo_ut
glouts	7	44	1471	3	glouts
glove	9	45	1629	3	glo_ve
gloved	11	48	1187	3	gloved
glover	10	45	1353	3	glover
gloves	10	41	1518	3	gloves
gloving	12	30	844	3	gloving
glow	8	52	2252	3	glo__w
glowed	11	49	1383	3	glowed
glower	10	51	1493	3	glower
glowing	12	32	1179	3	glowing
glows	9	55	1803	3	glo_ws
gloxinia	16	4	269	3	gloxinia
gloze	15	48	1598	3	glo_ze
glozed	17	37	1122	3	glozed
glozes	16	43	1335	3	glozes
glozing	18	33	889	3	glozing
glycin	12	3	596	3	glycin
gnomic	11	24	859	3	gnomic
gnosis	7	57	1121	3	gnosis
goa	4	73	4380	3	g_o__a
gonif	9	43	2092	3	g_onif
goodie	8	36	1399	3	goodie
goonie	7	36	1556	3	goonie
gooral	7	3	1046	3	gooral
gopik	12	5	753	3	g_opik
gor	4	78	4826	3	g_or__
goral	6	51	2575	3	g_oral
gordita	9	4	509	3	g_ordita
gore	5	57	4496	3	g_or_e
gored	7	52	2708	3	g_ored
gores	6	57	4037	3	g_ores
gorge	7	64	2389	3	g_orge
gorier	7	37	1937	3	g_orier
gorilla	8	3	697	3	g_orilla
gorily	10	6	1250	3	g_orily
goring	8	41	1957	3	g_oring
gorm	7	55	2939	3	g_or_m
gorms	8	56	1959	3	g_orms
gorp	7	56	2590	3	g_or_p
gorps	8	53	1699	3	g_orps
gorse	6	59	2681	3	g_orse
gorsy	9	59	1578	3	g_orsy
gory	8	61	2966	3	g_or_y
goyim	11	4	860	3	g_oyim
grid	6	58	2962	3	g__rid
grig	6	54	2477	3	g__rig
grim	7	69	2942	3	g__rim
grin	5	57	3372	3	g__rin
grip	7	61	2702	3	g__rip
grit	5	52	4724	3	g__rit
groin	6	55	2108	3	gro_in
gyoza	18	3	611	3	gyo_za
gyri	8	54	1515	3	g_yri_
hora	7	61	3656	3	_hor_a
hydria	13	22	790	3	hydria
ilia	4	60	2682	3	il__ia
ixora	12	3	691	3	ixor_a
kerria	10	33	992	3	kerria
kora	8	64	3157	3	_kor_a
korai	9	70	1853	3	_korai
korma	11	59	1309	3	_korma
labia	7	52	1901	3	_labia
lamia	7	53	2432	3	_lamia
lari	4	58	3915	3	_lari_
lariat	6	6	2905	3	_lariat
laris	5	47	3746	3	_laris
larva	8	3	1249	3	_larva
latria	6	23	1361	3	latria
lira	4	69	2869	3	_lir_a
liri	4	51	2826	3	_liri_
loca	6	55	2768	3	_lo_ca
lochia	11	5	831	3	_lochia
loci	6	61	2628	3	_loci_
loggia	8	45	705	3	_loggia
logic	8	82	1783	3	_logic
login	6	60	2500	3	_login
loid	5	55	3150	3	_lo_id
loin	4	68	3872	3	_lo_in
loofa	8	59	1281	3	_loofa
looie	5	56	2424	3	_looie
loral	5	59	2782	3	_loral
loran	5	59	2509	3	_loran
lord	5	50	3208	3	_lor_d
lords	6	49	2350	3	_lords
lore	4	58	5035	3	_lor_e
loreal	6	38	1431	3	_loreal
lores	5	50	4540	3	_lores
loricae	9	3	825	3	_loricae
lories	6	49	3304	3	_lories
lorn	4	64	3525	3	_lor_n
lorry	8	63	1567	3	_lorry
lory	7	59	3171	3	_lor_y
lota	4	72	3350	3	_lo_ta
loti	4	64	3184	3	_loti_
lotic	7	64	2067	3	_lotic
louie	5	50	2351	3	_louie
louis	5	73	2232	3	_louis
louma	7	62	1363	3	_louma
lurid	6	46	1897	3	_lurid
lyric	10	45	1272	3	_lyric
malaria	9	3	1370	3	malaria
maria	7	50	3289	3	_maria
melodia	10	3	888	3	melodia
moira	7	10	1202	3	_moira
mora	6	66	4127	3	_mor_a
myopia	13	31	844	3	myopia
nori	4	71	3314	3	_nori_
norias	6	55	1820	3	_norias
noris	5	49	2827	3	_noris
nutria	6	3	991	3	nutria
obia	6	79	2311	3	__obia
ohia	7	57	1936	3	__ohia
oorie	5	30	2636	3	_oorie
ora	3	72	5083	3	__or_a
orca	6	55	2277	3	__orca
orra	4	61	2072	3	__orra
pelorian	10	4	888	3	pelorian
pelorias	10	4	1059	3	pelorias
peloric	11	3	1071	3	peloric
phobia	13	27	860	3	phobia
podia	8	4	1528	3	_podia
poori	7	48	1623	3	poori_
pooris	8	39	1684	3	pooris
propria	11	4	993	3	propria
pylori	11	4	716	3	pylori_
pyloric	14	3	806	3	pyloric
pyuria	11	3	695	3	pyuria
ria	3	67	4551	3	___ria
scoriae	9	3	1090	3	scoriae
scotia	8	3	1080	3	scotia
sharia	9	31	1673	3	sharia
shortia	10	4	819	3	shortia
sloid	6	46	1971	3	slo_id
solaria	7	3	1249	3	solaria
sora	4	57	4691	3	_sor_a
sori	4	60	3984	3	_sori_
sorta	5	71	2541	3	_sorta
stria	5	57	2321	3	_stria
talaria	7	4	1252	3	talaria
thorias	10	23	1205	3	thorias
thoric	11	43	1404	3	thoric
tora	4	75	4599	3	_tor_a
tori	4	75	4215	3	_tori_
toric	7	65	2931	3	_toric
torii	5	55	2159	3	_torii
torta	5	59	2535	3	_torta
tsoris	6	34	1119	3	tsoris
ultra	5	3	936	3	ultr_a
utopia	8	10	788	3	utopia
uxorial	14	4	632	3	uxorial
valonia	10	4	830	3	valonia
varia	8	58	2421	3	_varia
velaria	10	3	892	3	velaria
yttria	9	5	480	3	yttria
zoaria	15	4	838	3	zoaria
zori	13	77	2292	3	_zori_
zoril	14	39	1669	3	_zoril
zoris	14	53	2001	3	_zoris

Search took 6 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	112716	0.406	440125.6
2	DLD Change Limit	112716	317	5.373	20978.2
3	Display Results	317	317	0.093	3408.6
	(SQL Overall)	178691	317	5.872	30431.0