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

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

328 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
summae	10	39	1101	(None)
summa	9	47	1331	1	summa_
summas	10	43	1316	1	summas
summate	11	36	1166	1	summate
gemmae	11	50	779	2	gemmae
gumma	10	53	1310	2	gumma_
gummas	11	48	1051	2	gummas
mammae	9	46	1321	2	mammae
rummage	12	3	458	2	rummage
squamae	18	4	572	2	squamae
sumac	9	95	1488	2	su_mac
summable	14	3	690	2	summable
summand	12	3	626	2	summand
summary	14	29	735	2	summary
summated	13	29	883	2	summated
summates	12	26	1049	2	summates
summed	11	40	1404	2	summed
summer	10	40	1771	2	summer
summit	10	3	1154	2	summit
summon	10	3	762	2	summon
sundae	7	3	1287	2	sundae
alumnae	9	5	540	3	alumnae
aurae	5	41	2811	3	au_rae
bullae	8	34	1616	3	bullae
bumble	12	42	1689	3	bumble
bummalo	13	5	379	3	bummalo
bummed	13	42	1172	3	bummed
bummer	12	40	1410	3	bummer
bursae	8	45	1560	3	bursae
busman	10	3	1025	3	busman
cammie	12	46	1529	3	cammie
comae	9	71	2842	3	_comae
comma	11	45	1479	3	comma_
commas	12	48	1457	3	commas
commie	12	42	1552	3	commie
crummie	13	3	615	3	crummie
culpae	10	38	926	3	culpae
cummer	12	44	1459	3	cummer
cummin	12	8	878	3	cummin
curiae	8	45	1837	3	curiae
cymae	12	67	1301	3	_cymae
dammar	11	43	890	3	dammar
duma	7	55	2445	3	du_ma_
dumas	8	54	2043	3	du_mas
dumka	12	43	883	3	dumka_
dummied	13	34	672	3	dummied
dummies	12	30	1213	3	dummies
dummy	13	47	1278	3	dumm_y
femme	12	50	1143	3	femm_e
fulmar	11	3	725	3	fulmar
fumble	13	32	1426	3	fumble
fume	9	67	2763	3	fu_m_e
gamma	10	61	1610	3	gamma_
gammas	11	57	1469	3	gammas
gemma	10	63	1177	3	gemma_
gemmate	12	41	838	3	gemmate
gimmal	11	24	751	3	gimmal
gimme	10	24	1134	3	gimm_e
gimmie	11	29	818	3	gimmie
guimpe	11	3	472	3	guimpe
gummata	12	4	461	3	gummata
gummed	12	38	1166	3	gummed
gummer	11	46	1545	3	gummer
gummier	12	34	947	3	gummier
gummite	12	3	613	3	gummite
gummose	12	3	533	3	gummose
gummy	13	54	1365	3	gumm_y
gunman	9	29	945	3	gunman
guttae	7	32	1058	3	guttae
hammal	13	45	1206	3	hammal
hammam	12	41	933	3	hammam
hermae	11	53	1447	3	hermae
human	10	27	1603	3	hu_man
humane	11	28	1217	3	humane
humate	11	32	1444	3	humate
humble	13	36	1505	3	humble
hummable	17	4	458	3	hummable
hummed	14	48	1267	3	hummed
hummer	13	36	1527	3	hummer
hummus	13	3	624	3	hummus
humvee	14	3	920	3	humvee
immane	10	3	888	3	_immane
jimmie	17	37	647	3	jimmie
jumbal	17	5	846	3	jumbal
jumble	17	40	1265	3	jumble
kummel	14	26	617	3	kummel
lamiae	8	48	1745	3	lamiae
lemma	9	48	1103	3	lemma_
lemmas	10	34	916	3	lemmas
luma	6	55	2752	3	lu_ma_
lumas	7	56	2291	3	lu_mas
lumbar	10	36	1059	3	lumbar
lummox	17	3	305	3	lummox
mae	5	76	5911	3	___mae
mamma	8	63	1791	3	mamma_
mammal	9	51	1275	3	mammal
mammas	9	46	1640	3	mammas
mammate	10	44	1127	3	mammate
mammee	9	44	1785	3	mammee
mammie	9	43	1378	3	mammie
momma	8	51	1105	3	momma_
mommas	9	41	1065	3	mommas
mumble	12	36	1434	3	mumble
mumm	7	57	1886	3	mumm__
mummed	10	44	1155	3	mummed
mummer	9	36	1454	3	mummer
mummied	11	32	710	3	mummied
mummies	10	38	1284	3	mummies
mumms	8	55	1315	3	mumm_s
mummy	11	49	1362	3	mumm_y
muscae	10	4	1067	3	muscae
nuchae	11	21	851	3	nuchae
numbat	10	3	1208	3	numbat
nummary	14	31	465	3	nummary
outman	8	31	1503	3	outman
pommee	12	28	1328	3	pommee
pommie	12	37	1050	3	pommie
puma	8	54	2412	3	pu_ma_
pumas	9	51	2156	3	pu_mas
pumice	12	3	822	3	pumice
pummel	12	27	804	3	pummel
pupae	9	65	1564	3	pu_pae
rugae	6	51	1476	3	ru_gae
rumba	9	36	1251	3	rumba_
rumbaed	12	28	749	3	rumbaed
rumbas	10	25	1201	3	rumbas
rumble	10	37	1881	3	rumble
rummaged	14	4	327	3	rummaged
rummager	13	4	359	3	rummager
rummages	13	4	493	3	rummages
rummer	10	47	1548	3	rummer
rummier	11	30	956	3	rummier
rummies	11	32	1279	3	rummies
rummy	12	42	1241	3	rumm_y
rumple	10	39	1301	3	rumple
sae	3	83	6518	3	s___ae
salpae	8	46	1427	3	salpae
samba	9	56	1877	3	samba_
sambaed	12	3	830	3	sambaed
sambal	10	52	1518	3	sambal
sambar	10	39	1416	3	sambar
sambas	10	42	1926	3	sambas
same	6	52	4564	3	s_am_e
samite	8	30	2060	3	samite
sampan	10	25	1189	3	sampan
sample	10	42	1501	3	sample
schmoe	13	32	833	3	schmoe
scrummage	16	4	187	3	scrummage
scumbag	14	4	357	3	scumbag
scumble	13	3	701	3	scumble
scummed	14	34	791	3	scummed
scummer	13	39	875	3	scummer
scummier	14	4	508	3	scummier
scummy	15	26	522	3	scumm_y
seaman	8	40	1590	3	seaman
seme	6	58	3665	3	s_em_e
sememe	10	12	998	3	sememe
semimat	11	4	1291	3	semimat
semple	10	32	1275	3	semple
sempre	10	27	1009	3	sempre
sesame	8	3	1101	3	sesame
setae	5	60	2622	3	s_etae
shaman	11	33	1428	3	shaman
shamas	11	37	1794	3	shamas
shame	10	57	2670	3	sham_e
shammas	14	35	872	3	shammas
shmear	11	7	693	3	shmear
sigma	8	45	1383	3	sigma_
sigmas	9	41	1136	3	sigmas
sigmate	10	7	1014	3	sigmate
silvae	9	28	1109	3	silvae
sima	6	47	3078	3	s_ima_
simar	7	49	2081	3	s_imar
simas	7	57	2755	3	s_imas
simian	8	8	1116	3	simian
simile	8	31	1563	3	simile
simmer	10	41	1535	3	simmer
simple	10	43	1517	3	simple
skyman	15	3	531	3	skyman
slime	7	49	2575	3	slim_e
slummed	12	35	927	3	slummed
slummer	11	37	1120	3	slummer
slummier	12	3	547	3	slummier
slummy	13	32	586	3	slumm_y
smaze	16	50	1293	3	s_maze
smear	7	44	1639	3	s_mear
smile	7	48	2392	3	s_mile
smite	7	52	2487	3	s_mite
smoke	11	50	1582	3	s_moke
smote	7	58	2028	3	s_mote
smudge	10	38	791	3	smudge
socman	10	3	981	3	socman
soma	6	56	3529	3	s_oma_
soman	7	50	2490	3	s_oman
somas	7	60	3037	3	s_omas
sombre	10	72	947	3	sombre
some	6	60	4038	3	s_om_e
somite	8	45	1937	3	somite
soulmate	10	4	719	3	soulmate
spae	6	50	3432	3	s__pae
spicae	10	43	1370	3	spicae
spume	9	58	1731	3	spum_e
spumone	11	5	438	3	spumone
squama	17	3	653	3	squama_
squamate	19	4	578	3	squamate
stelae	6	37	1648	3	stelae
stemma	10	32	813	3	stemma_
stemmas	11	25	697	3	stemmas
stime	7	65	2180	3	stim_e
stoae	5	50	2426	3	s_toae
stoma	7	59	1827	3	stoma_
stomal	8	52	1331	3	stomal
stomas	8	48	1632	3	stomas
stomate	9	3	1312	3	stomate
striae	6	54	2227	3	striae
strumae	9	36	809	3	strumae
stumble	11	4	755	3	stumble
stummed	12	34	855	3	stummed
stumpage	13	4	330	3	stumpage
stymie	11	3	762	3	stymie
suable	8	39	2055	3	suable
suave	8	35	1987	3	su_ave
suba	6	49	2660	3	su_ba_
subah	10	60	1521	3	su_bah
subas	7	47	2407	3	su_bas
subbase	11	3	932	3	subbase
subdue	9	12	849	3	subdue
sublate	9	3	1536	3	sublate
submit	10	3	1267	3	submit
subpar	10	4	866	3	subpar
subrace	11	3	1300	3	subrace
subsale	9	3	1054	3	subsale
subsea	8	26	1019	3	subsea
subtle	8	21	1343	3	subtle
subway	14	4	707	3	subway
succah	13	3	664	3	succah
suckle	12	40	1596	3	suckle
sucrase	9	3	1034	3	sucrase
sucre	7	50	1910	3	su_cre
sue	3	56	5146	3	su___e
suede	6	44	1975	3	su_ede
sugar	6	3	1291	3	su_gar
suite	5	48	2956	3	su_ite
sukkah	12	12	373	3	sukkah
sulcal	8	3	1127	3	sulcal
sulcate	9	3	1442	3	sulcate
suldan	7	26	1104	3	suldan
sulfa	8	3	1392	3	sulfa_
sulfas	9	3	1156	3	sulfas
sulfate	10	3	1165	3	sulfate
sullage	8	5	991	3	sullage
sultan	6	30	1259	3	sultan
sum	5	63	4601	3	su_m__
sumach	13	53	1011	3	sumach
sumacs	10	55	1210	3	sumacs
summands	13	4	471	3	summands
summaries	13	11	818	3	summaries
summarise	13	11	573	3	summa~~ris~~e
summarize	22	10	565	3	summa~~riz~~e
summative	16	4	620	3	summa~~tiv~~e
summered	13	3	814	3	summered
summers	11	36	1650	3	summers
summery	14	32	941	3	summery
summing	12	29	1238	3	summing
summital	12	4	470	3	summital
summited	13	24	641	3	summited
summits	11	3	798	3	summits
summoned	13	4	572	3	summoned
summoner	12	4	553	3	summoner
summons	11	5	800	3	summons
sumo	6	73	2631	3	su_m_o
sumos	7	57	2009	3	su_mos
sump	8	63	3153	3	su_m_p
sumps	9	50	2343	3	su_mps
sumpter	11	3	887	3	sumpter
sums	6	58	3758	3	su_m_s
sundaes	8	3	1309	3	sundaes
sunna	5	50	1606	3	sunna_
sunnah	9	36	935	3	sunnah
sunnas	6	39	1456	3	sunnas
sunray	9	3	1012	3	sunray
suntan	6	26	1300	3	suntan
supe	6	59	3276	3	su__pe
supine	8	42	1669	3	supine
supple	10	4	1020	3	supple
supra	7	36	1425	3	supra_
sura	4	57	4029	3	su_ra_
surah	8	68	2325	3	su_rah
sural	5	59	3126	3	su_ral
suras	5	53	3633	3	su_ras
surbase	9	3	979	3	surbase
sure	4	54	4741	3	su__re
surface	12	3	865	3	surface
surfman	12	3	620	3	surfman
surge	6	50	2769	3	su_rge
surmise	9	3	1108	3	surmise
surname	9	3	760	3	surname
surra	5	55	2134	3	surra_
surras	6	59	1953	3	surras
surtax	13	3	784	3	surtax
sutra	5	42	1793	3	sutra_
sutras	6	48	1859	3	sutras
sutta	5	40	1533	3	sutta_
suttas	6	38	1379	3	suttas
suttee	6	37	2154	3	suttee
suture	6	3	1320	3	suture
sylvae	12	23	686	3	sylvae
tammie	10	42	1269	3	tammie
tubae	7	47	1664	3	tu_bae
tumble	10	32	1564	3	tumble
tummies	11	30	1203	3	tummies
tummler	11	26	661	3	tummler
tummy	12	47	1199	3	tumm_y
ulnae	5	52	1457	3	_ulnae
umami	9	3	988	3	_umami
umbrae	10	3	868	3	_umbrae
umiac	9	3	896	3	_umiac
umiak	11	3	767	3	_umiak
umiaq	16	5	682	3	_umiaq
umm	7	119	2126	3	_umm__
unmade	9	29	1106	3	_unmade
unmake	12	28	1121	3	_unmake
unman	7	27	1542	3	_unman
ursae	5	52	1445	3	_ursae
vulvae	12	43	803	3	vulvae
yummier	14	30	684	3	yummier
yummies	14	35	953	3	yummies
yummy	15	42	915	3	yumm_y

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	112716	0.373	479064.3
2	DLD Change Limit	112716	328	5.656	19928.6
3	Display Results	328	328	0.110	2981.8
	(SQL Overall)	178691	328	6.139	29107.5