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

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

398 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
shmear	11	7	693	(None)
schmear	14	8	404	1	schmear
shear	8	54	2483	1	sh_ear
shmears	12	7	707	1	shmears
smear	7	44	1639	1	s_mear
hear	7	61	4388	2	_h_ear
sambar	10	39	1416	2	sambar
schmears	15	8	409	2	schmears
schmeer	14	7	536	2	schmeer
sear	4	73	5384	2	s__ear
shea	7	60	3157	2	sh_ea_
sheaf	11	54	2412	2	sh_eaf
sheal	8	49	2770	2	sh_eal
shears	9	38	2090	2	sh_ears
sheas	8	63	3179	2	sh_eas
sheer	8	47	2689	2	sh_eer
shier	8	54	2894	2	shie_r
shikar	13	3	680	2	shikar
shoer	8	47	2215	2	shoe_r
shofar	12	3	630	2	shofar
shyer	11	47	1478	2	shye_r
simar	7	49	2081	2	sim_ar
smears	8	47	1443	2	s_mears
smeary	11	41	1080	2	s_meary
spear	7	58	2106	2	s_pear
swear	8	53	1685	2	s_wear
ahead	9	68	1705	3	ah_ead
aimer	7	59	2682	3	aime_r
almemar	11	4	430	3	almemar
ameer	7	56	1898	3	_ameer
anear	5	54	2032	3	_anear
appear	10	37	934	3	appear
armer	7	69	2444	3	arme_r
arrear	6	3	1025	3	arrear
ashier	9	47	1483	3	ashie_r
ashlar	9	33	819	3	ash_lar
ashler	9	45	997	3	ashle_r
ashman	11	4	838	3	ashm_an
ashmen	11	6	817	3	ashme_n
bear	6	68	4464	3	__bear
bemean	10	4	1068	3	bemean
besmear	11	3	483	3	besmear
blear	7	59	1868	3	_blear
camera	10	3	1367	3	camera
chadar	12	3	934	3	chadar
char	9	51	3215	3	ch__ar
cheap	12	69	1594	3	ch_eap
cheat	10	57	3245	3	ch_eat
cheer	10	54	2038	3	ch_eer
chimar	13	39	1146	3	chimar
chimer	13	55	1720	3	chime_r
chimera	14	38	926	3	chimera
chukar	15	3	463	3	chukar
clear	7	62	1905	3	_clear
comer	9	58	3269	3	come_r
cymar	12	57	1126	3	cym_ar
damar	8	41	1773	3	dam_ar
dammar	11	43	890	3	dammar
dear	5	53	4360	3	__dear
demean	9	5	1056	3	demean
dimer	8	56	2560	3	dime_r
dogear	8	3	819	3	dogear
drear	6	50	1690	3	_drear
ear	3	68	6788	3	___ear
embar	9	40	1159	3	_embar
emeer	7	48	1536	3	_emeer
emmer	9	43	1446	3	emme_r
endear	7	41	1001	3	endear
fear	7	53	3779	3	__fear
fishmeal	16	4	266	3	fishmeal
fumer	10	59	1823	3	fume_r
gamer	8	49	2894	3	game_r
gear	5	59	3497	3	__gear
gomer	8	52	2065	3	gome_r
haar	7	73	2349	3	_h_aar
head	8	71	3717	3	_h_ead
heal	7	56	4569	3	_h_eal
heap	9	64	3289	3	_h_eap
heard	9	52	2275	3	_h_eard
hears	8	67	3737	3	_h_ears
heart	8	54	4074	3	_h_eart
heat	7	70	6142	3	_h_eat
heir	7	75	2380	3	_h_eir
hemal	10	44	1980	3	_hemal
her	6	65	4781	3	_h_e_r
hilar	8	54	1814	3	_hilar
hoar	7	67	2916	3	_h_oar
hoer	7	65	3398	3	_hoe_r
homer	10	58	2845	3	home_r
isomer	8	3	1015	3	isome_r
lamer	7	52	3370	3	lame_r
lear	4	70	4595	3	__lear
linear	6	51	1333	3	linear
lumbar	10	36	1059	3	lumbar
maar	6	60	2505	3	__maar
mar	5	79	6594	3	__m_ar
mead	7	55	3160	3	__mead
meal	6	56	4317	3	__meal
mean	6	55	3808	3	__mean
meat	6	63	5960	3	__meat
mimbar	12	9	748	3	mimbar
mimer	9	48	2576	3	mime_r
mishear	12	3	839	3	mish_ear
namer	7	56	2210	3	name_r
near	4	52	3650	3	__near
omer	6	70	2839	3	_ome_r
ormer	7	52	1837	3	orme_r
pear	6	97	4523	3	__pear
phreak	15	3	615	3	phreak
phylar	14	43	737	3	phylar
rear	4	56	4455	3	__rear
redear	7	35	1517	3	redear
regear	7	35	1274	3	regear
rehear	9	37	1322	3	rehear
retear	6	31	1548	3	retear
rewear	9	30	1199	3	rewear
rhea	7	50	1743	3	rh_ea_
rheas	8	48	1695	3	rh_eas
rhymer	14	38	708	3	rhyme_r
rimer	7	54	2924	3	rime_r
saber	7	53	3024	3	sabe_r
safer	8	47	2181	3	safe_r
sager	6	54	3205	3	sage_r
saggar	8	40	1085	3	saggar
saker	9	51	3202	3	sake_r
samara	8	3	1385	3	sam_ara
samba	9	56	1877	3	samba_
sambal	10	52	1518	3	sambal
sambars	11	51	1384	3	sambars
sambas	10	42	1926	3	sambas
sambhar	14	4	485	3	sambhar
sambur	10	46	950	3	sambur
same	6	52	4564	3	same__
samech	13	27	703	3	samech
samek	11	49	1527	3	same_k
samekh	15	35	513	3	samekh
sameks	12	40	932	3	sameks
samovar	12	4	424	3	samovar
sampan	10	25	1189	3	sampan
samsara	9	3	691	3	samsara
saner	5	43	3432	3	sane_r
sangar	7	36	1768	3	sangar
sansar	6	36	1339	3	sansar
sardar	7	30	1317	3	sardar
sarsar	6	30	1184	3	sarsar
saver	8	48	3125	3	save_r
sawer	8	50	2621	3	sawe_r
sayer	8	49	2655	3	saye_r
scalar	8	36	1243	3	scalar
scar	6	64	3420	3	s__car
schema	13	8	837	3	schema_
schemas	14	6	816	3	schemas
schemer	14	7	795	3	schemer
schmeared	17	4	305	3	schmeared
schmeers	15	7	483	3	schmeers
scholar	12	3	694	3	scholar
scimetar	12	4	404	3	scimetar
sclera	8	3	888	3	sclera
screak	12	53	1105	3	screak
scream	10	48	1424	3	scream
sea	3	61	6129	3	s__ea_
seal	4	56	5437	3	s__eal
seam	6	66	4597	3	s__eam
seamer	8	42	2361	3	seame_r
sears	5	47	4491	3	s__ears
seas	4	57	5527	3	s__eas
seat	4	75	7556	3	s__eat
secpar	10	3	792	3	secpar
seder	6	48	2675	3	sede_r
seemer	8	44	1804	3	seemer
seer	4	55	4704	3	s__eer
seggar	8	35	781	3	seggar
seme	6	58	3665	3	seme__
sememe	10	12	998	3	sememe
semen	7	57	2410	3	seme_n
semens	8	46	1696	3	semens
semes	7	57	3158	3	seme_s
seminar	9	7	975	3	seminar
ser	3	67	5240	3	s__e_r
sera	4	61	4139	3	s__era
serer	5	59	3550	3	sere_r
sever	8	54	2605	3	seve_r
sewar	8	54	2109	3	s_ewar
sewer	8	44	2621	3	sewe_r
sha	6	98	3778	3	sh__a_
shad	8	62	3091	3	sh__ad
shader	10	42	1876	3	shader
shag	8	64	3056	3	sh__ag
shah	10	56	2778	3	sh__ah
shaker	13	43	1946	3	shaker
sham	9	64	3635	3	sh__am
shaman	11	33	1427	3	shaman
shamas	11	37	1793	3	shamas
shame	10	57	2670	3	shame__
shamed	12	51	2021	3	shame_d
shames	11	47	2622	3	shame_s
shammas	14	35	871	3	shammas
shammer	14	46	1314	3	shammer
shaper	11	41	1993	3	shaper
shard	9	61	2596	3	sh__ard
share	8	64	3708	3	sh__are
sharer	9	50	2548	3	sharer
shark	12	62	2502	3	sh__ark
sharn	8	48	2370	3	sh__arn
sharp	10	49	2253	3	sh__arp
shat	7	64	5659	3	sh__at
shaver	12	37	1891	3	shaver
shaw	10	81	3255	3	sh__aw
shay	10	71	3334	3	sh__ay
shazam	20	4	660	3	shazam
she	6	68	3769	3	sh_e__
sheafs	12	49	1288	3	sh_eafs
sheals	9	44	2064	3	sh_eals
sheared	11	45	1600	3	sh_eared
shearer	10	44	1468	3	sh_earer
sheath	12	4	1288	3	sh_eath
sheave	12	45	1400	3	sh_eave
shebean	12	3	576	3	shebean
shed	8	65	3615	3	sh_e_d
sheds	9	61	2270	3	sh_eds
sheen	8	50	2331	3	sh_een
sheens	9	51	1699	3	sheens
sheeny	12	49	1219	3	sheeny
sheep	10	53	2152	3	sh_eep
sheerer	10	38	1384	3	sheerer
sheers	9	43	2240	3	sheers
sheesh	12	3	781	3	sheesh
sheet	8	48	3695	3	sh_eet
sheeter	10	38	1490	3	sheeter
sheets	9	39	1849	3	sheets
sheeve	12	34	1284	3	sheeve
sheik	12	25	1465	3	sh_eik
shelf	11	52	2111	3	sh_elf
shell	8	44	2412	3	sh_ell
shend	9	47	1997	3	sh_end
shent	8	59	3349	3	sh_ent
sheol	8	43	1836	3	sh_eol
sherd	9	63	2115	3	sh_erd
sherry	12	45	1041	3	sh_erry
shes	7	57	3435	3	sh_e_s
shew	10	80	3076	3	sh_e_w
shewer	12	45	1510	3	shewer
shewn	11	57	1570	3	sh_ewn
shews	11	59	2471	3	sh_ews
shibah	14	38	746	3	shibah
shied	9	61	2549	3	shie_d
shiel	8	110	2377	3	shie_l
shield	10	62	1297	3	shield
shiels	9	54	1892	3	shiels
shiers	9	49	2175	3	shiers
shies	8	61	3655	3	shie_s
shiest	9	58	2152	3	shiest
shikari	14	4	449	3	shikari
shikars	14	3	618	3	shikars
shimmer	14	33	1087	3	shimmer
shiner	9	38	2087	3	shiner
shirr	8	47	1692	3	sh_irr
shiva	11	59	1500	3	shiva_
shivah	15	48	853	3	shivah
shivas	12	45	1241	3	shivas
shiver	12	45	1737	3	shiver
shlep	10	49	1483	3	shle_p
shlepp	13	36	619	3	shlepp
shleps	11	47	1033	3	shleps
shmo	9	53	1809	3	shm__o
shmoes	11	46	1209	3	shmoes
shmuck	17	3	424	3	shmuck
shoal	8	39	2026	3	sh_oal
shoat	8	56	3394	3	sh_oat
shoe	7	59	3343	3	shoe__
shoed	9	57	2300	3	shoe_d
shoepac	14	4	400	3	shoepac
shoers	9	45	1832	3	shoers
shoes	8	54	2965	3	shoe_s
shofars	13	3	581	3	shofars
shophar	15	5	545	3	shophar
shoran	9	40	1603	3	shoran
shover	12	45	1598	3	shover
shower	12	43	1510	3	shower
shred	9	81	2561	3	shre_d
shreds	10	56	1305	3	shreds
shrew	11	97	2016	3	shre_w
shrewd	13	68	1077	3	shrewd
shrews	12	93	1391	3	shrews
shtetl	9	3	643	3	shtetl
shwa	10	60	1496	3	sh_wa_
shwas	11	64	1510	3	sh_was
shyers	12	47	1220	3	shyers
shyest	12	55	1183	3	shyest
sidearm	10	3	596	3	sidearm
sidebar	10	4	556	3	sidebar
sidecar	10	4	523	3	sidecar
sieur	5	9	1189	3	s_ieur
siker	9	53	2603	3	sike_r
sima	6	47	3078	3	sim_a_
simars	8	49	1693	3	sim_ars
simas	7	57	2755	3	sim_as
simian	8	8	1115	3	simian
similar	9	3	785	3	similar
simitar	9	3	673	3	simitar
simmer	10	41	1535	3	simmer
simper	10	36	1629	3	simper
simular	9	3	867	3	simular
sirdar	7	26	910	3	sirdar
sitar	5	48	2054	3	s_itar
siver	8	57	2861	3	sive_r
sizar	14	52	1499	3	s_izar
sizer	14	55	2181	3	size_r
skean	9	44	1562	3	s_kean
skier	9	51	1959	3	skie_r
skiwear	14	4	252	3	skiwear
slier	5	48	2724	3	slie_r
slyer	8	55	1512	3	slye_r
smarm	9	55	1760	3	s_m_arm
smart	7	58	3409	3	s_m_art
smeared	10	45	1062	3	s_meared
smearer	9	41	1040	3	s_mearer
smeek	11	49	1235	3	s_meek
smell	7	49	1623	3	s_mell
smelt	7	47	2678	3	s_melt
smerk	11	54	1272	3	s_merk
smew	9	50	1773	3	s_me_w
smews	10	46	1229	3	s_mews
sneak	9	60	1617	3	s_neak
sneap	7	55	1482	3	s_neap
sneer	5	49	1995	3	s_neer
soar	4	68	3867	3	s__oar
sober	7	48	2240	3	sobe_r
sofar	8	61	1549	3	s_ofar
solar	5	59	2734	3	s_olar
soma	6	56	3529	3	som_a_
soman	7	50	2490	3	som_an
somas	7	60	3037	3	som_as
somber	10	37	1399	3	somber
some	6	60	4038	3	some__
someday	13	4	588	3	someday
someway	15	4	561	3	someway
sonar	5	65	2342	3	s_onar
sorer	5	62	3657	3	sore_r
soucar	8	3	932	3	soucar
sowar	8	58	2134	3	s_owar
sowcar	11	3	586	3	sowcar
sower	8	52	2931	3	sowe_r
spar	6	54	3330	3	s__par
speak	11	46	1867	3	s_peak
spean	7	46	2051	3	s_pean
spears	8	40	1947	3	s_pears
speer	7	46	2390	3	s_peer
speir	7	53	1536	3	s_peir
spier	7	57	2803	3	spie_r
spread	9	3	1253	3	spread
squeak	19	3	525	3	squeak
squeal	15	3	801	3	squeal
star	4	80	3776	3	s__tar
stead	6	55	2027	3	s_tead
steak	9	52	1980	3	s_teak
steal	5	61	2547	3	s_teal
steam	7	63	2292	3	s_team
steer	5	54	2386	3	s_teer
stelar	6	40	1386	3	stelar
streak	10	46	1362	3	streak
stream	8	47	1728	3	stream
stylar	9	35	811	3	stylar
suber	7	49	2450	3	sube_r
subpar	10	4	866	3	subpar
suer	4	53	3403	3	s_ue_r
sugar	6	3	1291	3	s_ugar
sumac	9	95	1488	3	sum_ac
summa	9	47	1331	3	summa_
summae	10	39	1101	3	summae
summary	14	29	735	3	summary
summas	10	43	1316	3	summas
summer	10	40	1771	3	summer
super	7	49	2448	3	supe_r
surer	5	48	3309	3	sure_r
swears	9	41	1407	3	s_wears
sweat	8	56	2840	3	s_weat
sweer	8	49	1857	3	s_weer
swimwear	16	4	167	3	swimwear
tamer	7	52	3010	3	tame_r
tear	4	52	4288	3	__tear
their	8	55	1215	3	th_eir
thenar	9	26	999	3	thenar
thread	10	50	1109	3	thread
threap	11	56	966	3	threap
threat	9	50	2046	3	threat
timer	7	56	2604	3	time_r
unbear	8	8	916	3	unbear
upbear	10	9	649	3	upbear
uprear	8	16	879	3	uprear
uptear	8	9	678	3	uptear
usher	8	45	1776	3	ush_e_r
vomer	10	55	1738	3	vome_r
wear	7	58	3672	3	__wear
wheal	11	57	1618	3	wh_eal
wheat	11	49	2457	3	wh_eat
womera	11	13	759	3	womera
year	7	65	3425	3	__year

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.190	940478.9
2	DLD Change Limit	112716	398	6.310	17863.1
3	Display Results	398	398	0.126	3158.7
	(SQL Overall)	178691	398	6.626	26968.2