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

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

320 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
hummus	13	3	624	(None)
humus	10	62	1507	1	hu_mus
gummas	11	48	1051	2	gummas
gummous	12	3	626	2	gummous
hommos	13	12	850	2	hommos
humans	11	23	1243	2	humans
humbug	14	3	480	2	humbug
humbugs	15	3	424	2	humbugs
humerus	12	3	691	2	humerus
hummed	14	48	1267	2	hummed
hummer	13	36	1527	2	hummer
hummers	14	38	1306	2	hummers
hummuses	15	4	445	2	hummuses
humors	11	12	963	2	humors
humour	11	11	675	2	humour
humours	12	8	641	2	humours
humphs	16	52	816	2	humphs
humps	12	63	2280	2	hu_mps
hums	9	68	3142	2	hu_m_s
mumms	8	55	1315	2	mumm_s
mumus	9	55	1728	2	mu_mus
rumpus	10	45	889	2	rumpus
summas	10	43	1316	2	summas
wammus	13	42	673	2	wammus
alumnus	9	3	522	3	alumnus
ammos	9	48	1582	3	_ammos
amus	6	55	2961	3	__amus
animus	8	42	1161	3	animus
aureus	6	53	1488	3	aureus
aurous	6	41	1926	3	aurous
aurums	8	4	938	3	aurums
awmous	11	5	771	3	awmous
brumous	11	10	743	3	brumous
bubus	9	51	1545	3	bu_bus
bumfs	12	54	1405	3	bu_mfs
bummed	13	42	1172	3	bummed
bummer	12	40	1410	3	bummer
bummers	13	37	1244	3	bummers
bummest	13	29	862	3	bummest
bumphs	15	46	710	3	bumphs
bumps	11	59	2114	3	bu_mps
bums	8	59	3459	3	bu_m_s
bupkus	14	38	568	3	bupkus
campus	12	52	1392	3	campus
chummed	17	39	644	3	chummed
chummy	18	38	589	3	chumm_y
chumps	15	43	1382	3	chu_mps
chums	12	50	1583	3	chu_m_s
chymous	17	7	569	3	chymous
commas	12	48	1457	3	commas
comous	10	8	1650	3	comous
culms	9	53	1419	3	culm_s
cultus	8	51	1073	3	cultus
cumins	10	33	1493	3	cumins
cummer	12	44	1459	3	cummer
cummers	13	37	1347	3	cummers
cummin	12	8	878	3	cummin
cummins	13	5	896	3	cummins
cumulus	11	3	545	3	cumulus
cuscus	10	3	811	3	cuscus
cymous	13	8	840	3	cymous
dufus	9	40	1081	3	du_fus
dumas	8	54	2043	3	du_mas
dumbos	11	41	1108	3	dumbos
dumbs	10	59	1575	3	du_mbs
dumdum	12	4	452	3	dumdum
dumdums	13	4	304	3	dumdums
dummies	12	30	1213	3	dummies
dummy	13	47	1278	3	dumm_y
dumps	10	52	2010	3	du_mps
duomos	9	3	682	3	duomos
durums	9	4	815	3	durums
emeus	7	69	1333	3	_emeus
emmys	12	44	602	3	_emmys
emus	6	68	2168	3	__emus
famous	11	4	1239	3	famous
femmes	13	54	1021	3	femmes
fucous	11	39	986	3	fucous
fucus	10	55	1589	3	fu_cus
fugus	9	59	1401	3	fu_gus
fumers	11	36	1338	3	fumers
fumes	10	52	2470	3	fu_mes
fumets	11	43	1181	3	fumets
fumulus	12	3	444	3	fumulus
fundus	10	42	917	3	fundus
fungus	10	41	818	3	fungus
gammas	11	57	1469	3	gammas
gimmes	11	30	1090	3	gimmes
glomus	9	46	809	3	glomus
grumous	10	8	660	3	grumous
gumbos	11	46	1087	3	gumbos
gumma	10	53	1310	3	gumm_a
gummed	12	38	1166	3	gummed
gummer	11	46	1545	3	gummer
gummers	12	37	1219	3	gummers
gummose	12	3	533	3	gummose
gummy	13	54	1365	3	gumm_y
gums	7	50	3094	3	gu_m_s
gurus	6	43	1819	3	gu_rus
habus	10	63	1714	3	h_abus
haems	10	55	1701	3	haem_s
haikus	13	53	829	3	haikus
hakus	12	51	1411	3	h_akus
halmas	11	70	1789	3	halmas
halms	10	52	2521	3	halm_s
hamals	11	48	1681	3	hamals
hamaul	11	42	1086	3	hamaul
hamauls	12	38	780	3	hamauls
hames	10	61	3870	3	h_ames
hammal	13	45	1206	3	hammal
hammals	14	40	921	3	hammals
hammam	12	41	933	3	hammam
hammams	13	38	643	3	hammams
hammed	14	41	1697	3	hammed
hammer	13	81	2003	3	hammer
hammers	14	42	1605	3	hammers
hammy	15	51	1343	3	hamm_y
hams	9	64	4613	3	h_am_s
hamulus	12	3	532	3	hamulus
hamzas	20	11	901	3	hamzas
harms	10	68	2901	3	harm_s
haulms	11	55	850	3	haulm_s
helms	10	56	1946	3	helm_s
hemes	10	50	3108	3	h_emes
hemins	11	34	1756	3	hemins
hemmed	14	42	1146	3	hemmed
hemmer	13	41	1264	3	hemmer
hemmers	14	33	1084	3	hemmers
hemps	12	69	1733	3	h_emps
hems	9	55	3494	3	h_em_s
herms	10	56	2643	3	herm_s
hiatus	9	3	822	3	hiatus
hilus	8	48	1764	3	h_ilus
hims	9	52	3097	3	h_im_s
hmm	10	62	1899	3	h_mm__
hocus	10	47	1520	3	h_ocus
hokums	15	3	392	3	hokums
holms	10	51	1780	3	holm_s
homers	11	48	2197	3	homers
homes	10	69	3881	3	h_omes
homeys	14	50	1287	3	homeys
homies	11	45	2472	3	homies
homos	10	59	2178	3	h_omos
hubbub	12	4	360	3	hubbub
hubbubs	13	4	260	3	hubbubs
hubris	11	21	897	3	hubris
hubs	9	60	2714	3	hu__bs
hucks	14	43	2217	3	hu_cks
hues	7	52	3523	3	hu__es
huffs	14	45	1474	3	hu_ffs
hugeous	11	3	713	3	hugeous
hugs	8	61	2975	3	hu__gs
hulas	8	49	2088	3	hu_las
hulks	12	57	1548	3	hu_lks
hullos	9	49	1629	3	hullos
hulls	8	49	2356	3	hu_lls
hum	8	55	4293	3	hu_m__
human	10	27	1603	3	hu_man
humane	11	28	1217	3	humane
humate	11	32	1444	3	humate
humates	12	28	1319	3	humates
humble	13	36	1505	3	humble
humbles	14	32	1580	3	humbles
humbly	16	40	1052	3	humbly
humdrum	15	4	352	3	humdrum
humdrums	16	4	270	3	humdrums
humeri	11	3	852	3	humeri
humic	12	41	1324	3	hu_mic
humid	11	42	1376	3	hu_mid
humming	15	33	1067	3	humming
hummock	20	6	379	3	hummock
hummocks	21	6	345	3	hummocks
humor	10	11	1051	3	hu_mor
humorous	13	4	644	3	humorous
hump	11	62	2872	3	hu_m_p
humped	14	40	1524	3	humped
humper	13	41	1588	3	humper
humpers	14	27	1352	3	humpers
humph	15	57	1221	3	hu_mph
humpy	15	51	1567	3	hu_mpy
humuses	12	3	759	3	humuses
humvee	14	3	920	3	humvee
humvees	15	3	468	3	humvees
hunks	12	53	2145	3	hu_nks
huns	7	61	3693	3	hu__ns
hunts	8	68	2617	3	hu_nts
hurds	9	52	1907	3	hu_rds
hurls	8	65	2271	3	hu_rls
hursts	9	72	1309	3	hursts
hurts	8	69	2282	3	hu_rts
hushes	12	47	1859	3	hushes
husks	12	50	1545	3	hu_sks
huts	7	67	3744	3	hu__ts
huzzas	17	3	586	3	huzzas
hymens	14	3	799	3	hymens
hymns	13	3	752	3	h_ymns
iambus	10	46	890	3	iambus
jugums	16	10	467	3	jugums
jujus	11	34	746	3	ju_jus
jukus	16	39	867	3	ju_kus
jumbos	17	37	912	3	jumbos
jumps	16	51	1649	3	ju_mps
kombus	14	3	552	3	kombus
kudus	10	49	1080	3	ku_dus
kudzus	20	44	395	3	kudzus
kumiss	12	3	592	3	kumiss
kummel	14	26	617	3	kummel
kummels	15	23	479	3	kummels
kumys	14	3	593	3	ku_mys
kurus	9	80	1563	3	ku_rus
lemmas	10	34	916	3	lemmas
limbus	10	57	1038	3	limbus
litmus	8	3	632	3	litmus
luaus	5	45	1490	3	lu_aus
lulus	5	43	1516	3	lu_lus
lumas	7	56	2291	3	lu_mas
lumens	8	50	1397	3	lumens
lummox	17	3	305	3	lummox
lumps	9	56	2498	3	lu_mps
lums	6	57	3424	3	lu_m_s
lupous	8	4	943	3	lupous
lupus	7	45	1252	3	lu_pus
lusus	5	48	1387	3	lu_sus
mammas	9	46	1640	3	mammas
mommas	9	41	1065	3	mommas
momus	9	61	1611	3	_momus
mucous	10	44	1165	3	mucous
mucus	9	40	1574	3	mu_cus
mumm	7	57	1886	3	mumm__
mummed	10	44	1155	3	mummed
mummer	9	36	1454	3	mummer
mummers	10	37	1284	3	mummers
mummies	10	38	1284	3	mummies
mummy	11	49	1362	3	mumm_y
mumps	11	56	1910	3	mu_mps
mums	8	57	3277	3	mu_m_s
mumu	8	60	2206	3	mu_mu_
murmur	10	3	485	3	murmur
murmurs	11	3	452	3	murmurs
mus	5	59	4675	3	___mus
muumuu	10	4	237	3	muumuu
muumuus	11	4	176	3	muumuus
nimbus	10	37	728	3	nimbus
numbs	9	49	1309	3	nu_mbs
osmous	8	13	818	3	osmous
primus	10	37	1217	3	primus
pumas	9	51	2156	3	pu_mas
pummel	12	27	804	3	pummel
pummels	13	23	654	3	pummels
pumps	11	55	2060	3	pu_mps
pupus	9	46	1404	3	pu_pus
quipus	17	45	800	3	quipus
ramous	8	4	1710	3	ramous
ramus	7	64	1828	3	_ramus
rhamnus	12	3	313	3	rhamnus
rhombus	14	24	389	3	rhombus
rhumbas	14	30	516	3	rhumbas
rhumbs	13	36	677	3	rhu_mbs
rimous	8	3	1191	3	rimous
rubus	7	64	1505	3	ru_bus
ruckus	12	40	779	3	ruckus
rufous	9	4	826	3	rufous
rugous	7	3	964	3	rugous
rumbas	10	25	1201	3	rumbas
rumens	8	36	1181	3	rumens
rummer	10	47	1548	3	rummer
rummers	11	35	1365	3	rummers
rummest	11	27	983	3	rummest
rummies	11	32	1279	3	rummies
rummy	12	42	1241	3	rumm_y
rumors	8	11	1039	3	rumors
rumour	8	12	737	3	rumour
rumours	9	7	636	3	rumours
rumps	9	59	2229	3	ru_mps
rums	6	48	3347	3	ru_m_s
shammas	14	35	871	3	shammas
shammes	14	43	1283	3	shammes
shammos	14	30	720	3	shammos
shamus	11	41	1281	3	shamus
spumous	11	3	585	3	spumous
sulcus	8	4	1049	3	sulcus
sulus	5	48	2188	3	su_lus
sumacs	10	55	1210	3	sumacs
summa	9	47	1331	3	summ_a
summae	10	39	1101	3	summae
summed	11	40	1404	3	summed
summer	10	40	1771	3	summer
summers	11	36	1650	3	summers
summit	10	3	1154	3	summit
summits	11	3	797	3	summits
summon	10	3	762	3	summon
summons	11	5	800	3	summons
sumos	7	57	2009	3	su_mos
sumps	9	50	2343	3	su_mps
sums	6	58	3758	3	su_m_s
thumbs	13	37	744	3	thu_mbs
thumps	13	44	935	3	thu_mps
thymus	14	32	473	3	thymus
tummies	11	30	1203	3	tummies
tummy	12	47	1199	3	tumm_y
tumors	8	8	1060	3	tumors
tumour	8	13	739	3	tumour
tumours	9	7	673	3	tumours
tumps	9	54	2079	3	tu_mps
tumulus	9	3	503	3	tumulus
tutus	5	52	1481	3	tu_tus
ulus	4	56	2256	3	_u_lus
umamis	10	3	827	3	_umamis
umbos	9	46	1307	3	_umbos
umm	7	119	2126	3	_umm__
umps	8	57	2194	3	_u_mps
unaus	5	32	1657	3	_unaus
uncus	7	40	1498	3	_uncus
urus	4	64	2613	3	_u_rus
vulgus	10	3	578	3	vulgus
wampus	13	49	901	3	wampus
wamus	10	55	1468	3	_wamus
whumps	16	42	709	3	whu_mps
yummies	14	35	953	3	yummies
yummy	15	42	915	3	yumm_y

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	112716	0.296	603685.8
2	DLD Change Limit	112716	320	6.626	17011.2
3	Display Results	320	320	0.203	1576.4
	(SQL Overall)	178691	320	7.125	25079.4