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

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

329 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
whence	14	18	792	(None)
hence	10	49	2004	1	_hence
thence	11	20	1084	1	thence
chance	13	46	1709	2	chance
fence	10	53	1991	2	_fence
hance	10	54	2415	2	_hance
henge	9	48	1983	2	_henge
pence	9	49	2445	2	_pence
spence	10	38	1379	2	spence
weenie	9	26	1202	2	weenie
wench	13	62	1478	2	w_ench
whee	10	54	2959	2	whe__e
wheeze	21	27	681	2	wheeze
when	10	57	2304	2	when__
whenas	12	46	1046	2	whenas
whens	11	46	1876	2	when_s
where	11	70	1942	2	whe_re
wherve	15	56	811	2	wherve
whine	11	60	2281	2	whin_e
whinge	13	43	1154	2	whinge
wienie	9	22	997	2	wienie
wince	10	52	2088	2	w_ince
wrench	14	43	935	2	wrench
absence	11	3	771	3	absence
achene	11	3	1381	3	achen_e
agency	12	3	703	3	agency
agene	6	56	2158	3	agen_e
akene	9	58	1866	3	aken_e
amerce	10	3	1051	3	amerce
arene	5	53	2941	3	aren_e
avenge	10	8	755	3	avenge
avenue	9	5	795	3	avenue
bench	12	56	1950	3	_bench
bene	6	64	3949	3	_ben_e
benne	7	65	2112	3	_benne
blench	13	37	1045	3	blench
blende	9	54	1344	3	blende
bounce	10	40	1483	3	bounce
cadence	12	3	906	3	cadence
cense	7	51	2140	3	_cense
chanced	15	41	1321	3	chanced
chancel	14	40	1177	3	chancel
chancer	14	42	1563	3	chancer
chances	14	52	1809	3	chances
chancre	14	34	878	3	chancre
chancy	16	40	1086	3	chancy
change	12	41	1675	3	change
chebec	15	3	696	3	chebec
check	16	47	1471	3	che_ck
cheese	11	38	1276	3	cheese
chegoe	12	3	727	3	chegoe
chelae	11	36	1460	3	chelae
cheque	20	3	666	3	cheque
chevre	14	31	831	3	chevre
chinch	16	39	1123	3	chinch
chine	10	52	3172	3	chin_e
choice	13	20	1052	3	choice
clench	13	39	1005	3	clench
coerce	10	3	1040	3	coerce
dance	8	52	2313	3	_dance
defence	13	3	989	3	defence
deice	8	43	2003	3	_deice
dene	5	66	4341	3	_den_e
dense	6	59	2350	3	_dense
deuce	8	45	1749	3	_deuce
diene	6	57	2013	3	dien_e
drench	12	36	959	3	drench
duende	8	3	692	3	duende
dunce	8	63	1926	3	_dunce
enhance	12	3	969	3	enhance
essence	9	4	767	3	essence
ethene	9	33	1292	3	ethen_e
evince	11	3	776	3	evince
faience	12	3	751	3	faience
fenced	12	44	1271	3	_fenced
fencer	11	46	1353	3	_fencer
fences	11	46	1711	3	_fences
fiance	11	3	1074	3	fiance
fierce	11	34	891	3	fierce
fleece	11	36	990	3	fleece
flench	14	40	1081	3	flench
flense	9	3	890	3	flense
french	14	35	1121	3	french
gene	5	62	3722	3	_gen_e
genie	6	61	2492	3	_genie
genre	6	60	1680	3	_genre
ghee	8	57	2611	3	ghe__e
glance	9	43	1231	3	glance
hances	11	56	2128	3	_hances
hanse	8	57	2279	3	_hanse
heave	11	45	2181	3	_heave
hebe	9	64	2470	3	_he_be
heck	13	58	2649	3	_he_ck
hedge	10	53	1735	3	_hedge
heeze	17	53	1348	3	_heeze
heinie	9	25	1266	3	_heinie
helve	11	50	1809	3	_helve
heme	9	50	3441	3	_he_me
hen	6	75	5527	3	_hen__
henges	10	45	1646	3	_henges
henley	12	3	748	3	_henley
henna	8	44	1404	3	_henna
henry	11	40	1447	3	_henry
hens	7	56	4257	3	_hen_s
hent	7	66	5638	3	_hen_t
hented	10	42	1875	3	_hented
hents	8	73	3074	3	_hents
here	7	64	4710	3	_he_re
heuch	13	53	1233	3	_heuch
hinge	9	53	2345	3	_hinge
hone	7	75	4932	3	_hon_e
hunch	13	64	1621	3	_hunch
jaunce	15	36	743	3	jaunce
jounce	15	33	1073	3	jounce
kench	14	55	1392	3	_kench
kente	9	58	2107	3	_kente
lance	7	51	2672	3	_lance
launce	8	46	918	3	launce
lense	5	45	2343	3	_lense
licence	11	11	936	3	licence
lucence	11	14	800	3	lucence
menace	10	32	1694	3	_menace
mense	7	50	2563	3	_mense
mince	9	53	2523	3	_mince
nance	7	47	2184	3	_nance
nene	4	59	3206	3	_nen_e
niece	7	48	1450	3	nie_ce
nonce	7	57	1982	3	_nonce
nuance	8	5	904	3	nuance
offence	15	4	535	3	offence
once	6	54	2308	3	__once
ounce	7	70	1993	3	_ounce
peace	9	50	2608	3	_peace
pencel	10	38	1291	3	_pencel
penne	7	54	2385	3	_penne
phenate	12	4	1219	3	phenate
phenix	18	3	713	3	phenix
phenol	11	4	925	3	phenol
phenom	13	3	947	3	phenom
phenyl	14	3	532	3	phenyl
phone	10	56	2193	3	phon_e
piece	9	67	1799	3	pie_ce
pierce	10	40	1039	3	pierce
plench	13	40	1081	3	plench
ponce	9	52	2251	3	_ponce
potence	11	7	1136	3	potence
pounce	10	52	1409	3	pounce
prance	10	43	1857	3	prance
prince	10	41	1476	3	prince
quench	20	3	663	3	quench
quince	17	39	1013	3	quince
rance	7	50	2851	3	_rance
recce	9	5	1456	3	_recce
refence	12	3	1223	3	refence
rente	5	47	3378	3	_rente
rheme	10	62	1405	3	rhe_me
scene	7	72	2057	3	scen_e
science	11	3	878	3	science
sconce	10	47	1172	3	sconce
seance	8	37	1669	3	seance
sene	4	68	4805	3	_sen_e
sense	5	55	2682	3	_sense
sente	5	64	3288	3	_sente
sheave	12	45	1400	3	sheave
sheenie	10	15	949	3	sheenie
sheeve	12	34	1284	3	sheeve
shelve	12	40	1276	3	shelve
shend	9	47	1997	3	shen_d
shends	10	53	1377	3	shends
shent	8	59	3350	3	shen_t
sheuch	14	26	704	3	sheuch
shine	8	55	3309	3	shin_e
shone	8	37	2598	3	shon_e
silence	9	3	1021	3	silence
since	7	50	2417	3	_since
sithence	13	4	479	3	sithence
skene	9	61	1812	3	sken_e
spencer	11	36	1097	3	spencer
spences	11	34	1392	3	spences
spense	8	39	1243	3	spense
sphene	11	34	1240	3	sphen_e
stance	8	43	1691	3	stance
stench	11	41	1116	3	stench
tenace	8	27	1569	3	_tenace
tench	10	56	2000	3	_tench
tenge	6	57	2044	3	_tenge
tense	5	52	2584	3	_tense
terce	7	57	2184	3	_terce
thane	8	61	2253	3	than_e
thebe	10	75	1543	3	the_be
theca	10	33	1145	3	the_ca
thecae	11	29	965	3	thecae
thee	7	80	3906	3	the__e
theine	9	48	1492	3	theine
theme	10	59	2173	3	the_me
then	7	84	2969	3	then__
thenage	11	10	784	3	thenage
thenal	9	27	1242	3	thenal
thenar	9	26	1000	3	thenar
thens	8	59	2183	3	then_s
there	8	75	2739	3	the_re
therme	11	58	1499	3	therme
these	8	65	1901	3	the_se
thine	8	50	2686	3	thin_e
thrice	11	43	1157	3	thrice
tierce	8	33	984	3	tierce
trance	8	47	1876	3	trance
trench	11	42	1161	3	trench
twopence	15	4	295	3	twopence
unfence	12	3	919	3	unfence
usance	8	5	801	3	usance
valence	12	6	877	3	valence
venae	8	59	2098	3	_venae
venge	9	51	1799	3	_venge
venue	8	49	1821	3	_venue
wahine	12	38	1301	3	wahin_e
wane	7	63	4472	3	w_an_e
weave	11	52	1853	3	w_eave
wedge	10	52	1566	3	w_edge
wee	6	67	6081	3	w_e__e
ween	7	58	3546	3	ween__
weened	10	40	1373	3	weened
weenier	10	32	1080	3	weenier
weenies	10	29	1509	3	weenies
weens	8	52	2405	3	ween_s
weensy	12	41	682	3	weensy
weeny	11	53	1616	3	ween_y
weepie	11	25	879	3	weepie
weewee	12	3	1008	3	weewee
welch	13	44	1149	3	w_elch
wen	6	62	4960	3	w_en__
wenched	16	39	1091	3	w_enched
wencher	15	38	1113	3	w_encher
wenches	15	29	1413	3	w_enches
wend	8	53	3045	3	w_en_d
wended	11	36	1615	3	w_ended
wends	9	58	2281	3	w_ends
wenny	11	44	1246	3	w_enny
wens	7	63	3793	3	w_en_s
went	7	60	5187	3	w_en_t
were	7	62	3833	3	w_e_re
whack	17	48	1302	3	wh_ack
whale	11	55	1743	3	wh_ale
whang	12	48	1338	3	whan_g
whanged	15	44	761	3	whanged
whangee	14	26	861	3	whangee
whangs	13	43	972	3	whangs
wharve	15	45	620	3	wharve
wheal	11	57	1618	3	whe_al
wheals	12	45	1252	3	wheals
wheat	11	49	2457	3	whe_at
wheaten	13	3	640	3	wheaten
wheats	12	50	1322	3	wheats
wheedle	14	3	482	3	wheedle
wheel	11	55	1533	3	whe_el
wheeled	14	31	846	3	wheeled
wheeler	13	29	877	3	wheeler
wheelie	13	3	619	3	wheelie
wheels	12	38	1171	3	wheels
wheen	11	50	1605	3	whe_en
wheens	12	46	1061	3	wheens
wheep	13	62	1435	3	whe_ep
wheeped	16	38	750	3	wheeped
wheeple	15	3	485	3	wheeple
wheeps	14	43	995	3	wheeps
wheezed	23	29	645	3	wheezed
wheezer	22	29	667	3	wheezer
wheezes	22	30	680	3	wheezes
wheezy	24	24	452	3	wheezy
whelk	15	43	1106	3	whe_lk
whelks	16	36	732	3	whelks
whelky	19	31	497	3	whelky
whelm	13	46	1198	3	whe_lm
whelmed	16	37	515	3	whelmed
whelms	14	37	757	3	whelms
whelp	13	60	1209	3	whe_lp
whelped	16	35	563	3	whelped
whelps	14	43	784	3	whelps
whenever	17	4	277	3	whenever
wheres	12	59	1743	3	wheres
wherry	15	47	733	3	wherry
wherves	16	54	805	3	wherves
whet	10	51	3378	3	whe__t
whether	16	34	662	3	whether
whets	11	50	1961	3	whe_ts
whetted	14	25	669	3	whetted
whetter	13	34	880	3	whetter
whew	13	76	1878	3	whe__w
whews	14	51	1449	3	whe_ws
whey	13	50	1871	3	whe__y
wheyey	18	3	432	3	wheyey
wheyface	22	6	155	3	wheyface
wheys	14	59	1155	3	whe_ys
which	16	39	1008	3	wh_ich
while	11	54	1869	3	wh_ile
whin	10	52	2569	3	whin__
whined	13	47	1520	3	whined
whiner	12	45	1663	3	whiner
whines	12	51	2010	3	whines
whiney	15	50	1264	3	whiney
whinged	15	40	915	3	whinged
whinger	14	108	1091	3	whinger
whinges	14	36	1063	3	whinges
whinier	13	41	1063	3	whinier
whinny	15	58	749	3	whinny
whins	11	49	2233	3	whin_s
whiny	14	49	1557	3	whin_y
white	11	49	2030	3	wh_ite
whole	11	44	1809	3	wh_ole
whore	11	60	1804	3	wh_ore
whose	11	49	1453	3	wh_ose
wiener	9	45	1354	3	wiener
wienies	10	22	1368	3	wienies
winced	12	44	1534	3	w_inced
wincer	11	50	1819	3	w_incer
winces	11	48	1911	3	w_inces
wincey	14	41	1038	3	w_incey
winch	13	50	1666	3	w_inch
wine	7	49	5342	3	w_in_e
winze	17	50	1485	3	w_inze
wreck	14	46	1104	3	wre_ck
wren	7	82	2168	3	wren__
wrenched	17	74	813	3	wrenched
wrencher	16	28	778	3	wrencher
wrenches	16	32	1023	3	wrenches
wrens	8	50	1624	3	wren_s
wretch	14	32	653	3	wretch
yente	8	62	2004	3	_yente
yince	10	52	1425	3	_yince

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.376	475242.0
2	DLD Change Limit	112716	329	5.326	21163.3
3	Display Results	329	329	0.110	2990.9
	(SQL Overall)	178691	329	5.812	30745.2