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

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

231 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
valkyr	16	3	240	(None)
valkyrs	17	3	216	1	valkyrs
alky	11	59	2034	2	_alky_
alkyd	13	53	709	2	_alkyd
alkyl	12	51	804	2	_alkyl
balker	12	45	1916	2	balker
balky	14	54	1824	2	balky_
calker	12	49	1708	2	calker
talker	10	39	1622	2	talker
talky	12	62	1568	2	talky_
valkyrie	18	4	185	2	valkyrie
valor	8	36	1489	2	val_or
valour	9	30	1037	2	valour
valuer	9	39	1144	2	valuer
valvar	12	38	865	2	valvar
walker	13	39	1399	2	walker
alar	4	63	4007	3	_al_ar
alary	8	61	2344	3	_alary
alder	6	54	2191	3	_alder
algor	6	5	1305	3	_algor
aliya	8	37	1348	3	_aliya
alkie	9	55	2003	3	_alkie
alkyds	14	40	436	3	_alkyds
alkyls	13	46	572	3	_alkyls
alkyne	13	43	686	3	_alkyne
ally	7	69	3564	3	_ally_
allyl	8	53	1054	3	_allyl
altar	5	55	2064	3	_altar
alter	5	48	2850	3	_alter
asker	9	64	1878	3	_asker
backer	14	45	2552	3	backer
baker	11	56	2954	3	ba_ker
balder	9	53	1886	3	balder
baldy	11	55	1893	3	baldy_
baler	7	56	3527	3	bal_er
balk	10	51	3222	3	balk__
balked	13	52	1941	3	balked
balkers	13	49	1572	3	balkers
balkier	13	41	1198	3	balkier
balks	11	49	2629	3	balk_s
baller	8	38	2520	3	baller
bally	10	55	3010	3	bally_
balmy	12	52	1747	3	balmy_
banker	12	42	2273	3	banker
barker	12	48	2286	3	barker
barky	14	57	2161	3	barky_
baulky	15	44	631	3	baulky_
bilker	12	49	1344	3	bilker
bulky	14	62	1557	3	bulky_
caky	13	62	2244	3	ca_ky_
calcar	10	3	1275	3	calcar
calk	10	55	2766	3	calk__
calked	13	46	1740	3	calked
calkers	13	44	1469	3	calkers
calkin	12	35	1549	3	calkin
calks	11	54	2160	3	calk_s
caller	8	51	2548	3	caller
calmer	10	52	1693	3	calmer
calory	11	3	1284	3	calory
caloyer	12	3	814	3	caloyer
calyx	17	51	819	3	cal_yx
canker	12	44	2252	3	canker
casky	14	45	1268	3	casky_
caulker	13	45	689	3	caulker
chalky	18	46	877	3	chalky_
dacker	13	49	2075	3	dacker
daiker	11	51	1303	3	daiker
dally	9	53	2474	3	dally_
danker	11	43	1966	3	danker
darker	11	47	1869	3	darker
darky	13	60	1883	3	darky_
faker	12	48	2459	3	fa_ker
fakir	12	51	1149	3	fa_kir
faller	9	46	2123	3	faller
falser	9	39	1241	3	falser
falter	9	45	1905	3	falter
flaker	13	49	1617	3	flaker
flaky	15	57	1558	3	flaky_
folky	15	92	1471	3	folky_
gally	9	50	2617	3	gally_
gawker	14	55	935	3	gawker
gawky	16	56	999	3	gawky_
hacker	15	48	2269	3	hacker
haler	8	50	3352	3	hal_er
halter	9	44	2088	3	halter
hanker	13	46	2209	3	hanker
hanky	15	54	1829	3	hanky_
hawker	16	48	1266	3	hawker
hulky	15	53	1247	3	hulky_
jacker	19	44	1758	3	jacker
jacky	21	54	1234	3	jacky_
lacker	12	53	2562	3	lacker
laker	9	54	3287	3	la_ker
laky	11	67	2582	3	la_ky_
lanker	10	41	2300	3	lanker
lanky	12	55	1748	3	lanky_
larker	10	45	1924	3	larker
larky	12	52	1887	3	larky_
makar	11	56	1497	3	ma_kar
maker	11	41	2781	3	ma_ker
malar	7	64	2444	3	mal_ar
malkin	12	29	1315	3	malkin
malmy	12	48	1634	3	malmy_
malty	10	67	2170	3	malty_
marker	12	44	2039	3	marker
martyr	11	3	569	3	martyr
masker	12	44	1610	3	masker
milker	12	48	1432	3	milker
milky	14	40	1444	3	milky_
narky	12	60	1780	3	narky_
oaky	11	64	1995	3	oa_ky_
ovally	12	27	844	3	ovally_
packer	14	42	2340	3	packer
paler	7	54	3693	3	pal_er
palier	8	50	2356	3	palier
palikar	13	3	545	3	palikar
pallor	8	3	1367	3	pallor
pally	10	57	2712	3	pally_
palmar	10	41	1346	3	palmar
palmer	10	58	1654	3	palmer
palmy	12	60	1673	3	palmy_
palmyra	14	4	414	3	palmyra
palsy	10	54	1746	3	palsy_
palter	8	44	2326	3	palter
paltry	11	49	1040	3	paltry
paly	9	58	3553	3	pal_y_
parker	12	41	2137	3	parker
pawky	17	38	1015	3	pawky_
racker	12	48	2455	3	racker
raker	9	45	2979	3	ra_ker
rally	8	47	2590	3	rally_
rallye	9	51	1016	3	rallye
ranker	10	50	2190	3	ranker
sacker	12	51	2484	3	sacker
saker	9	51	3202	3	sa_ker
salary	9	5	1521	3	salary
sally	8	51	2971	3	sally_
salter	6	43	2508	3	salter
salty	8	55	2438	3	salty_
salver	9	46	1775	3	salver
salvor	9	47	1109	3	salvor
sarky	12	55	2178	3	sarky_
satyr	8	4	848	3	sa_tyr
silky	12	53	1582	3	silky_
slaker	10	42	1927	3	slaker
stalker	11	39	1225	3	stalker
stalky	13	49	930	3	stalky_
sulker	10	40	1592	3	sulker
sulky	12	47	1536	3	sulky_
tacker	12	42	2450	3	tacker
tacky	14	56	1744	3	tacky_
taker	9	52	2900	3	ta_ker
talar	5	62	2538	3	tal_ar
talcky	15	29	472	3	talcky_
taler	5	60	3486	3	tal_er
talk	8	62	3009	3	talk__
talked	11	40	1540	3	talked
talkers	11	35	1321	3	talkers
talkie	10	39	1444	3	talkie
talkier	11	40	1184	3	talkier
talks	9	43	2269	3	talk_s
taller	6	37	2196	3	taller
tally	8	45	2686	3	tally_
tanker	10	45	2112	3	tanker
vagary	13	3	733	3	vagary
vaguer	10	44	844	3	vaguer
vainer	9	37	1457	3	vainer
vair	7	56	2414	3	va__ir
vakil	12	5	979	3	va_kil
vale	7	49	3734	3	val__e
vales	8	54	3426	3	val_es
valet	8	43	3787	3	val_et
valets	9	37	1562	3	valets
valgus	10	4	710	3	valgus
valid	9	46	1839	3	val_id
valine	9	46	2309	3	valine
valise	9	29	1764	3	valise
valkyries	19	5	263	3	valkyr~~ies~~
valley	12	43	1160	3	valley
valleys	13	40	748	3	valleys
valors	9	34	1377	3	valors
valours	10	24	874	3	valours
valse	8	51	1752	3	val_se
valses	9	45	1461	3	valses
value	8	57	1909	3	val_ue
valued	10	40	1115	3	valued
valuers	10	32	894	3	valuers
values	9	43	1494	3	values
valuta	9	3	874	3	valuta
valval	12	39	886	3	valval
valve	11	45	1593	3	val_ve
valved	13	67	1104	3	valved
valves	12	41	1378	3	valves
vamper	13	42	1265	3	vamper
vampy	15	53	940	3	vampy_
vanner	9	42	1584	3	vanner
vapor	10	40	1309	3	va_por
vapory	14	39	876	3	vapory
vapour	11	37	887	3	vapour
var	6	61	4833	3	va___r
varier	9	46	1935	3	varier
vary	10	52	2606	3	va_ry_
vaster	9	45	2102	3	vaster
vasty	11	62	1592	3	vasty_
vaulter	10	25	771	3	vaulter
vaulty	12	38	844	3	vaulty_
vealer	9	40	1654	3	veal_er
vealier	10	27	1217	3	vealier
vealy	11	58	1777	3	veal_y_
velar	8	58	1763	3	vel_ar
velour	9	32	876	3	velour
viler	8	63	2416	3	vil_er
volar	8	69	1741	3	vol_ar
volery	12	3	787	3	volery
vulgar	10	42	682	3	vulgar
vulvar	12	42	796	3	vulvar
wacker	15	49	2012	3	wacker
wacky	17	47	1493	3	wacky_
waker	12	55	2659	3	wa_ker
waler	8	42	2926	3	wal_er
walk	11	56	2561	3	walk__
walked	14	53	1378	3	walked
walkers	14	34	1147	3	walkers
walks	12	62	1850	3	walk_s
walkup	15	3	419	3	walkup
walkyrie	18	4	188	3	walkyrie
wally	11	46	2509	3	wally_
waly	10	58	3090	3	wal_y_
wanker	13	42	1997	3	wanker
yakker	12	40	553	3	yakker
yolky	15	52	952	3	yolky_

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.390	458182.1
2	DLD Change Limit	112716	231	5.063	22262.7
3	Display Results	231	231	0.080	2887.5
	(SQL Overall)	178691	231	5.533	32295.5