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

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

332 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
shofar	12	3	630	(None)
shofars	13	3	581	1	shofars
sofar	8	61	1549	1	s_ofar
hoar	7	67	2916	2	_ho_ar
scholar	12	3	694	2	scholar
shear	8	54	2483	2	sh_ear
shikar	13	3	680	2	shikar
shmear	11	7	693	2	shmear
shoal	8	39	2026	2	sho_al
shoat	8	56	3394	2	sho_at
shoer	8	47	2215	2	sho_er
shophar	15	5	545	2	shophar
shoran	9	40	1603	2	shoran
shover	12	45	1598	2	shover
shower	12	43	1510	2	shower
soar	4	68	3867	2	s_o_ar
sofa	7	56	2560	2	s_ofa_
sofars	9	47	1278	2	s_ofars
sofas	8	53	2071	2	s_ofas
solar	5	59	2734	2	s_olar
sonar	5	65	2342	2	s_onar
sowar	8	58	2134	2	s_owar
afar	7	67	2078	3	__afar
ashlar	9	33	819	3	ash_lar
boar	6	61	3429	3	_bo_ar
bolar	7	51	2347	3	_bolar
boyar	10	60	1376	3	_boyar
chadar	12	3	934	3	chadar
chafer	14	47	1457	3	chafer
char	9	51	3215	3	ch__ar
chimar	13	39	1146	3	chimar
choir	10	53	1359	3	cho_ir
choker	15	43	1437	3	choker
chola	10	47	1803	3	chola_
cholas	11	48	1799	3	cholas
choler	11	37	1715	3	choler
choral	11	51	1849	3	choral
chufa	13	48	911	3	chufa_
chufas	14	39	767	3	chufas
chukar	15	3	463	3	chukar
deodar	8	3	771	3	deodar
dhoora	10	3	565	3	dhoora
escolar	9	4	605	3	escolar
far	6	77	6260	3	___far
gofer	9	48	1428	3	_gofer
haar	7	73	2349	3	_h_aar
hear	7	61	4388	3	_h_ear
hilar	8	54	1814	3	_hilar
hoard	9	49	1831	3	_ho_ard
hoars	8	59	2554	3	_ho_ars
hoary	11	45	1676	3	_ho_ary
hoax	14	77	1829	3	_ho_ax
hodad	10	3	1135	3	_hodad
hoer	7	65	3398	3	_ho_er
hogan	9	78	1770	3	_hogan
holard	10	4	1057	3	_holard
homer	10	58	2845	3	_homer
honan	8	53	1977	3	_honan
honer	8	53	3209	3	_honer
honor	8	57	1862	3	_honor
hoofer	12	40	1495	3	hoofer
hoper	10	58	2914	3	_hoper
hora	7	61	3655	3	_hora_
horah	11	79	2204	3	_horah
horal	8	63	2867	3	_horal
horary	12	3	1038	3	_horary
horas	8	63	3309	3	_horas
hoser	8	115	2976	3	_hoser
hour	7	58	2731	3	_ho_ur
hover	11	55	2413	3	_hover
hoya	10	74	1837	3	_hoya_
hoyas	11	50	1616	3	_hoyas
insofar	10	4	354	3	insofar
isobar	8	3	614	3	isobar
jowar	15	52	1143	3	_jowar
lobar	7	3	1301	3	_lobar
loofa	8	59	1281	3	loofa_
loofah	12	37	581	3	loofah
loofas	9	42	983	3	loofas
molar	7	52	2309	3	_molar
oar	3	70	5795	3	__o_ar
ofay	10	64	1610	3	__ofay
osar	4	68	2095	3	__osar
osmolar	9	4	448	3	osmolar
phonal	11	3	1038	3	phonal
phylar	14	43	737	3	phylar
polar	7	56	2345	3	_polar
prowar	11	41	1094	3	prowar
roar	4	63	2857	3	_ro_ar
roofer	9	44	1528	3	roofer
safari	9	11	1022	3	s_afari
safer	8	47	2181	3	s_afer
saggar	8	40	1085	3	saggar
sambar	10	39	1416	3	sambar
samovar	12	4	424	3	samovar
sangar	7	36	1768	3	sangar
sansar	6	36	1339	3	sansar
sardar	7	30	1317	3	sardar
sarsar	6	30	1184	3	sarsar
scalar	8	36	1243	3	scalar
scar	6	64	3420	3	s__car
schmear	14	8	404	3	schmear
scholars	13	3	667	3	scholars
scoff	13	44	1334	3	scof_f
scoffer	15	31	702	3	scoffer
scoffs	14	34	750	3	scoffs
scorer	8	48	1825	3	scorer
scoter	8	38	1547	3	scoter
scour	7	53	1553	3	sco_ur
sear	4	73	5384	3	s__ear
secpar	10	3	792	3	secpar
seggar	8	35	781	3	seggar
serovar	10	4	614	3	serovar
sewar	8	54	2109	3	s_ewar
sha	6	98	3778	3	sh__a_
shad	8	62	3091	3	sh__ad
shader	10	42	1876	3	shader
shaft	11	57	2525	3	shaf_t
shafts	12	54	1143	3	shafts
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
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
shea	7	60	3157	3	sh_ea_
sheaf	11	54	2412	3	sh_eaf
sheafs	12	49	1288	3	sheafs
sheal	8	49	2770	3	sh_eal
shears	9	38	2090	3	sh_ears
sheas	8	63	3179	3	sh_eas
sheer	8	47	2689	3	sh_eer
shewer	12	45	1510	3	shewer
shibah	14	38	746	3	shibah
shier	8	54	2894	3	sh_ier
shift	11	42	2513	3	shif_t
shifter	13	29	1107	3	shifter
shifts	12	44	1293	3	shifts
shifty	15	40	925	3	shifty
shikari	14	4	449	3	shikari
shikars	14	3	618	3	shikars
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
shmears	12	7	707	3	shmears
shoaler	10	26	1007	3	shoaler
shoals	9	42	1578	3	shoals
shoaly	12	40	1076	3	shoaly
shoats	9	41	1707	3	shoats
shock	14	49	1702	3	sho_ck
shocker	16	34	1142	3	shocker
shocks	15	44	1457	3	shocks
shod	8	62	2505	3	sho__d
shoddy	14	3	453	3	shoddy
shoe	7	59	3343	3	sho__e
shoed	9	57	2300	3	sho_ed
shoepac	14	4	400	3	shoepac
shoers	9	45	1832	3	shoers
shoes	8	54	2965	3	sho_es
shog	8	60	2513	3	sho__g
shogi	9	50	1399	3	sho_gi
shogis	10	38	1092	3	shogis
shogs	9	53	1970	3	sho_gs
shogun	10	4	570	3	shogun
shoji	15	41	994	3	sho_ji
shojis	16	34	847	3	shojis
sholom	11	9	1009	3	sholom
shone	8	37	2597	3	sho_ne
shoo	7	59	2988	3	sho__o
shooed	10	39	1607	3	shooed
shoofly	16	3	434	3	shoofly
shook	12	49	2015	3	sho_ok
shooks	13	45	1562	3	shooks
shool	8	45	2314	3	sho_ol
shools	9	49	1900	3	shools
shoon	8	40	2200	3	sho_on
shoos	8	42	2635	3	sho_os
shoot	8	42	3589	3	sho_ot
shooter	10	30	1397	3	shooter
shoots	9	46	1934	3	shoots
shop	9	56	2983	3	sho__p
shophars	16	4	635	3	shophars
shopman	14	24	725	3	shopman
shoppe	13	31	1031	3	shoppe
shopper	14	33	1262	3	shopper
shops	10	42	2289	3	sho_ps
shorans	10	28	1240	3	shorans
shore	8	54	3264	3	sho_re
shored	10	57	2364	3	shored
shores	9	48	3040	3	shores
shorl	8	47	2024	3	sho_rl
shorls	9	45	1619	3	shorls
shorn	8	57	2217	3	sho_rn
short	8	50	4052	3	sho_rt
shorter	10	35	1549	3	shorter
shorts	9	53	2173	3	shorts
shorty	12	43	1319	3	shorty
shot	7	61	5024	3	sho__t
shote	8	55	2608	3	sho_te
shotes	9	53	2189	3	shotes
shots	8	47	3083	3	sho_ts
shott	8	53	3217	3	sho_tt
shotts	9	36	1468	3	shotts
should	10	3	802	3	should
shout	8	54	3316	3	sho_ut
shouter	10	32	1307	3	shouter
shouts	9	40	1771	3	shouts
shove	11	44	2103	3	sho_ve
shoved	13	42	1427	3	shoved
shovel	12	46	1131	3	shovel
shovers	13	46	1299	3	shovers
shoves	12	49	1941	3	shoves
show	10	62	2918	3	sho__w
showed	13	50	1696	3	showed
showers	13	46	1266	3	showers
showery	16	43	723	3	showery
showier	13	3	909	3	showier
showman	15	25	728	3	showman
shown	11	52	1647	3	sho_wn
shows	11	53	2457	3	sho_ws
showy	14	57	1400	3	sho_wy
shoyu	11	3	890	3	sho_yu
shoyus	12	6	599	3	shoyus
shroff	15	3	849	3	shrof_f
shroffs	16	3	435	3	shroffs
shwa	10	60	1496	3	sh_wa_
shwas	11	64	1510	3	sh_was
shyer	11	47	1478	3	sh_yer
simar	7	49	2081	3	s_imar
sirdar	7	26	910	3	sirdar
sitar	5	48	2054	3	s_itar
sizar	14	52	1499	3	s_izar
skoal	9	38	1145	3	sko_al
slogan	7	53	922	3	slogan
sloper	8	46	1591	3	sloper
slower	9	40	1615	3	slower
smear	7	44	1639	3	s_mear
smoker	12	43	1169	3	smoker
snorer	6	43	1676	3	snorer
soak	8	72	2766	3	s_o_ak
soap	6	58	3113	3	s_o_ap
soars	5	47	3251	3	s_o_ars
soba	6	49	2792	3	s_oba_
sobas	7	44	2425	3	s_obas
sober	7	48	2240	3	s_ober
soca	6	63	3005	3	s_oca_
socas	7	40	2618	3	s_ocas
soda	5	63	2938	3	s_oda_
sodas	6	41	2354	3	s_odas
soft	7	69	4282	3	s_of_t
softa	8	64	1518	3	s_ofta
softas	9	44	1040	3	s_oftas
softer	9	40	1531	3	s_ofter
softs	8	50	1923	3	s_ofts
softy	11	54	1448	3	s_ofty
soja	11	56	1951	3	s_oja_
sojas	12	47	1639	3	s_ojas
sola	4	55	4186	3	s_ola_
solan	5	53	2815	3	s_olan
soma	6	56	3529	3	s_oma_
soman	7	50	2490	3	s_oman
somas	7	60	3037	3	s_omas
sonars	6	48	1897	3	s_onars
sooner	6	42	2046	3	sooner
sopor	7	40	1649	3	s_opor
sora	4	57	4691	3	s_ora_
soras	5	50	4101	3	s_oras
sorer	5	62	3657	3	s_orer
souari	6	3	1137	3	s_ouari
soucar	8	3	932	3	soucar
sour	4	59	3589	3	s_o_ur
sowars	9	43	1800	3	s_owars
sowcar	11	3	586	3	sowcar
sower	8	52	2931	3	s_ower
soya	7	57	2443	3	s_oya_
soyas	8	45	2091	3	s_oyas
spar	6	54	3330	3	s__par
spear	7	58	2106	3	s_pear
spoofer	12	36	872	3	spoofer
spoor	7	50	1635	3	spo_or
sporal	8	29	1545	3	sporal
star	4	80	3776	3	s__tar
stelar	6	40	1386	3	stelar
stoa	4	54	2591	3	sto_a_
stoae	5	50	2426	3	sto_ae
stoai	5	54	1786	3	sto_ai
stoas	5	51	2602	3	sto_as
stoat	5	71	3595	3	sto_at
stoker	10	44	1762	3	stoker
stoma	7	59	1827	3	stoma_
stomal	8	52	1331	3	stomal
stomas	8	48	1632	3	stomas
stoner	6	58	2320	3	stoner
stoper	8	43	2009	3	stoper
storax	13	8	978	3	storax
storer	6	47	2167	3	storer
stour	5	49	1674	3	sto_ur
stover	9	41	1564	3	stover
stylar	9	35	811	3	stylar
subpar	10	4	866	3	subpar
suffari	13	4	550	3	suffari
suffer	12	43	1451	3	suffer
sugar	6	3	1291	3	s_ugar
sulfa	8	3	1392	3	sulfa_
sulfas	9	3	1156	3	sulfas
sulfur	9	3	791	3	sulfur
surfer	9	35	1588	3	surfer
swear	8	53	1685	3	s_wear
thenar	9	26	999	3	thenar
thorax	16	3	825	3	thorax
tolar	5	55	2411	3	_tolar
trocar	8	4	876	3	trocar
twofer	12	3	435	3	twofer
volar	8	69	1741	3	_volar
whoa	10	66	1520	3	who_a_
woofer	12	44	1136	3	woofer
zaffar	21	38	504	3	zaffar

Search took 10 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.123	1452772.4
2	DLD Change Limit	112716	332	9.203	12247.7
3	Display Results	332	332	0.110	3018.2
	(SQL Overall)	178691	332	9.436	18937.2