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

Here are the results of your fuzzy-string dictionary search for “haying” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

226 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
haying	13	44	2061	(None)
baying	12	52	2258	1	baying
faying	13	45	2107	1	faying
hading	11	39	2294	1	hading
haeing	10	41	1892	1	haeing
haling	10	42	2978	1	haling
haring	10	42	3300	1	haring
hating	10	49	2971	1	hating
having	13	42	2037	1	having
hawing	13	43	2235	1	hawing
hayings	14	37	939	1	hayings
hazing	19	42	1855	1	hazing
hying	12	65	1474	1	h_ying
laying	10	45	2570	1	laying
maying	12	44	2115	1	maying
paying	12	37	2216	1	paying
raying	10	50	2719	1	raying
saying	10	43	2554	1	saying
aahing	10	190	1576	2	aahing
abying	12	44	1041	2	abying
acing	8	74	2915	2	_acing
aging	7	70	2635	2	_aging
ahing	9	89	2835	2	_ahing
aping	8	73	2723	2	_aping
awing	9	68	2732	2	_awing
axing	13	85	2137	2	_axing
ayin	7	63	3174	2	_ayin_
ayins	8	53	2161	2	_ayins
baaing	9	49	1616	2	baaing
babying	15	3	796	2	babying
baking	13	56	2662	2	baking
baling	9	48	2969	2	baling
baning	9	51	2783	2	baning
baring	9	51	3585	2	baring
basing	9	54	2766	2	basing
bating	9	51	3225	2	bating
braying	13	44	1631	2	braying
buying	12	42	1383	2	buying
caging	10	53	2102	2	caging
caking	13	46	2467	2	caking
caning	9	41	2862	2	caning
caring	9	51	3799	2	caring
casing	9	48	2910	2	casing
caving	12	48	2261	2	caving
cawing	12	43	2261	2	cawing
chafing	16	39	1149	2	chafing
charing	13	37	2132	2	charing
chasing	13	37	1589	2	chasing
chawing	16	48	1303	2	chawing
claying	13	36	1430	2	claying
coying	12	40	2148	2	coying
crying	12	36	1228	2	crying
daring	8	49	2868	2	daring
dating	8	53	2648	2	dating
dawing	11	48	1982	2	dawing
dazing	17	55	1651	2	dazing
draying	12	38	1384	2	draying
drying	11	34	1160	2	drying
dying	10	53	1603	2	_dying
earing	7	52	3548	2	earing
easing	7	49	2646	2	easing
eating	7	51	3440	2	eating
eying	9	61	1792	2	_eying
facing	12	53	2157	2	facing
fading	11	48	2111	2	fading
faking	14	55	2098	2	faking
faming	12	49	2297	2	faming
faring	10	52	3128	2	faring
fating	10	53	2867	2	fating
faxing	17	51	1705	2	faxing
fazing	19	44	1864	2	fazing
flaying	14	39	1446	2	flaying
flying	13	46	1215	2	flying
fraying	14	34	1343	2	fraying
frying	13	45	1140	2	frying
gaeing	8	46	1722	2	gaeing
gaging	9	47	1840	2	gaging
gaming	10	46	2204	2	gaming
gaping	10	56	1892	2	gaping
gating	8	48	2695	2	gating
gazing	17	47	1717	2	gazing
graying	12	41	1588	2	graying
guying	11	37	972	2	guying
hacking	17	37	2061	2	hacking
hafting	14	40	1417	2	hafting
hagging	13	31	1468	2	hagging
hailing	11	38	2069	2	hailing
haint	8	54	3632	2	ha_int
haloing	11	38	1413	2	haloing
halting	11	44	1907	2	halting
halving	14	35	1154	2	halving
hamming	15	30	1409	2	hamming
handing	12	35	1889	2	handing
hang	8	55	3555	2	ha__ng
hanging	12	35	1870	2	hanging
hanking	15	46	1910	2	hanking
hanting	11	41	2448	2	hanting
happing	15	38	1723	2	happing
harking	15	41	2094	2	harking
harming	13	37	1793	2	harming
harping	13	41	1838	2	harping
harrying	15	15	764	2	harrying
hashing	14	50	2016	2	hashing
hasping	13	44	1490	2	hasping
hasting	11	47	2519	2	hasting
hatting	11	39	2023	2	hatting
hauling	11	37	1443	2	hauling
hawking	18	37	1142	2	hawking
hazings	20	37	834	2	hazings
heading	12	29	1911	2	heading
healing	11	39	2296	2	healing
heaping	13	30	1585	2	heaping
hearing	11	33	2416	2	hearing
heating	11	40	2432	2	heating
heaving	14	41	1476	2	heaving
hewing	13	45	1424	2	hewing
hexing	17	42	1051	2	hexing
hiding	11	43	1933	2	hiding
hieing	10	42	1662	2	hieing
hiking	14	36	1710	2	hiking
hiring	10	44	2160	2	hiring
hiving	13	41	1552	2	hiving
hoaxing	18	30	776	2	hoaxing
hoeing	10	41	1702	2	hoeing
hoking	14	44	1951	2	hoking
holing	10	40	2507	2	holing
homing	12	37	1838	2	homing
honing	10	34	2150	2	honing
hoping	12	37	1974	2	hoping
hosing	10	34	2110	2	hosing
hyping	15	40	848	2	hyping
jading	15	42	1402	2	jading
japing	16	50	1357	2	japing
jawing	17	44	1496	2	jawing
joying	17	38	1080	2	joying
kayoing	15	3	540	2	kayoing
keying	14	3	804	2	keying
lacing	9	46	2623	2	lacing
lading	8	42	2712	2	lading
laking	11	50	2704	2	laking
laming	9	45	2836	2	laming
lasing	7	47	2798	2	lasing
laving	10	46	2357	2	laving
lawing	10	46	2528	2	lawing
layin	8	47	2033	2	layin_
layins	9	38	1765	2	layins
lazing	16	48	2147	2	lazing
lazying	20	4	667	2	lazying
lying	9	57	1745	2	_lying
macing	11	42	2155	2	macing
making	13	48	2385	2	making
mating	9	48	3291	2	mating
mawing	12	40	2080	2	mawing
maxing	16	48	1707	2	maxing
mayings	13	44	1051	2	mayings
mazing	18	44	1897	2	mazing
naming	9	39	1789	2	naming
oaring	7	42	2530	2	oaring
okaying	15	3	483	2	okaying
pacing	11	45	2275	2	pacing
paging	10	40	2040	2	paging
paling	9	35	3013	2	paling
paring	9	42	3649	2	paring
paving	12	45	1974	2	paving
pawing	12	45	1955	2	pawing
phasing	13	32	1167	2	phasing
playing	13	38	1609	2	playing
plying	12	43	1208	2	plying
praying	13	37	1732	2	praying
prying	12	41	1480	2	prying
racing	9	50	3053	2	racing
raging	8	51	2643	2	raging
raking	11	47	2842	2	raking
raping	9	48	2985	2	raping
raring	7	43	3287	2	raring
rasing	7	43	3083	2	rasing
rating	7	49	3870	2	rating
raving	10	51	2885	2	raving
raxing	14	43	2102	2	raxing
razing	16	45	2454	2	razing
saning	7	51	2764	2	saning
sating	7	47	3545	2	sating
saving	10	47	2451	2	saving
sawing	10	43	2381	2	sawing
sayings	11	36	1083	2	sayings
shading	12	31	1556	2	shading
shaking	15	33	1725	2	shaking
shaming	13	30	1674	2	shaming
shaping	13	31	1618	2	shaping
sharing	11	37	2324	2	sharing
shaving	14	34	1433	2	shaving
shawing	14	35	1488	2	shawing
shying	13	42	1184	2	shying
skying	14	39	998	2	skying
slaying	11	33	1684	2	slaying
spaying	13	30	1462	2	spaying
spying	12	39	1325	2	spying
staying	11	40	1732	2	staying
stying	10	54	1457	2	stying
swaying	14	36	1064	2	swaying
taking	11	47	2595	2	taking
taming	9	40	2343	2	taming
taping	9	42	2239	2	taping
taring	7	39	3228	2	taring
tawing	10	45	2155	2	tawing
taxing	14	38	1671	2	taxing
taxying	18	3	618	2	taxying
thawing	14	37	868	2	thawing
toying	10	50	1730	2	toying
trying	10	42	1407	2	trying
tying	9	60	1984	2	_tying
varying	14	2	972	2	varying
vying	12	51	1181	2	_vying
wading	11	46	1953	2	wading
waging	11	43	1838	2	waging
waking	14	48	2138	2	waking
waling	10	45	2530	2	waling
waning	10	36	2380	2	waning
waring	10	50	2944	2	waring
waving	13	40	1820	2	waving
waxing	17	42	1528	2	waxing
whaling	14	39	1077	2	whaling
wrying	13	37	962	2	wrying
yawing	13	42	1561	2	yawing
zayin	17	45	1204	2	zayin_
zayins	18	40	971	2	zayins

Search took 3 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	82551	0.360	496363.9
2	DLD Change Limit	82551	226	2.500	33020.4
3	Display Results	226	226	0.063	3587.3
	(SQL Overall)	178691	226	2.923	61132.7