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

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

299 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
hating	10	49	2971	(None)
bating	9	51	3225	1	bating
dating	8	53	2648	1	dating
eating	7	51	3440	1	eating
fating	10	53	2867	1	fating
gating	8	48	2695	1	gating
hading	11	39	2294	1	hading
haeing	10	41	1892	1	haeing
hafting	14	40	1417	1	hafting
haling	10	42	2978	1	haling
halting	11	44	1907	1	halting
hanting	11	41	2448	1	hanting
haring	10	42	3300	1	haring
hasting	11	47	2519	1	hasting
hatting	11	39	2023	1	hatting
having	13	42	2037	1	having
hawing	13	43	2235	1	hawing
haying	13	44	2061	1	haying
hazing	19	42	1855	1	hazing
heating	11	40	2432	1	heating
mating	9	48	3291	1	mating
rating	7	49	3870	1	rating
sating	7	47	3545	1	sating
aahing	10	190	1576	2	aahing
abating	10	4	1397	2	abating
acing	8	74	2915	2	_acing
acting	9	59	2098	2	acting
aging	7	70	2635	2	_aging
ahing	9	89	2835	2	_ahing
anting	7	58	2702	2	anting
aping	8	73	2723	2	_aping
awing	9	68	2732	2	_awing
axing	13	85	2137	2	_axing
baaing	9	49	1616	2	baaing
baiting	10	39	1888	2	baiting
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
basting	10	42	2720	2	basting
bathing	13	48	1624	2	bathing
batting	10	44	2227	2	batting
batwing	13	50	981	2	batwing
baying	12	52	2258	2	baying
beating	10	43	2687	2	beating
biting	9	53	2182	2	biting
boating	10	37	2130	2	boating
caging	10	53	2102	2	caging
caking	13	46	2467	2	caking
caning	9	41	2862	2	caning
canting	10	47	2590	2	canting
caring	9	51	3799	2	caring
carting	10	42	2828	2	carting
casing	9	48	2910	2	casing
casting	10	46	2834	2	casting
catling	10	48	1979	2	catling
catting	10	39	2264	2	catting
caving	12	48	2261	2	caving
cawing	12	43	2261	2	cawing
chafing	16	39	1149	2	chafing
chanting	14	34	1353	2	chanting
charing	13	37	2132	2	charing
charting	14	26	1419	2	charting
chasing	13	37	1589	2	chasing
chatting	14	28	1014	2	chatting
chawing	16	48	1303	2	chawing
cheating	14	40	1452	2	cheating
chuting	13	29	1073	2	chuting
citing	9	42	2018	2	citing
coating	10	35	2531	2	coating
coting	9	46	2925	2	coting
crating	10	37	2520	2	crating
daring	8	49	2868	2	daring
darting	9	40	2066	2	darting
dauting	9	38	1476	2	dauting
dawing	11	48	1982	2	dawing
dawting	12	36	1067	2	dawting
dazing	17	55	1651	2	dazing
doating	9	38	1686	2	doating
doting	8	48	2191	2	doting
earing	7	52	3548	2	earing
easing	7	49	2646	2	easing
easting	8	49	2430	2	easting
eatings	8	46	1644	2	eatings
elating	8	34	2308	2	elating
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
farting	11	41	2075	2	farting
fasting	11	45	2283	2	fasting
fatling	11	38	1568	2	fatling
fatting	11	38	1870	2	fatting
faxing	17	51	1705	2	faxing
faying	13	45	2107	2	faying
fazing	19	44	1864	2	fazing
feting	10	44	1779	2	feting
gaeing	8	46	1722	2	gaeing
gaging	9	47	1840	2	gaging
gaiting	9	37	1658	2	gaiting
gaming	10	46	2204	2	gaming
gaping	10	56	1892	2	gaping
gasting	9	50	2276	2	gasting
gatings	9	52	1282	2	gatings
gazing	17	47	1717	2	gazing
grating	9	39	2318	2	grating
habiting	14	3	753	2	habiting
hacking	17	37	2061	2	hacking
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
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
happing	15	38	1723	2	happing
harking	15	41	2094	2	harking
harming	13	37	1793	2	harming
harping	13	41	1838	2	harping
hashing	14	50	2016	2	hashing
hasping	13	44	1490	2	hasping
hatching	17	33	1221	2	hatching
hatpin	11	26	1061	2	hatpin_
hatpins	12	34	1064	2	hatpins
hauling	11	37	1443	2	hauling
haunting	12	35	1005	2	haunting
hawking	18	37	1142	2	hawking
hayings	14	37	939	2	hayings
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
hearting	12	5	1312	2	hearting
heaving	14	41	1476	2	heaving
hefting	14	45	1091	2	hefting
henting	11	37	1965	2	henting
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
hilting	11	33	1689	2	hilting
hinting	11	39	1922	2	hinting
hiring	10	44	2160	2	hiring
histing	11	37	2037	2	histing
hitting	11	30	1727	2	hitting
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
hooting	11	39	1988	2	hooting
hoping	12	37	1974	2	hoping
hosing	10	34	2110	2	hosing
hosting	11	43	1838	2	hosting
hotting	11	31	1652	2	hotting
hunting	11	43	1712	2	hunting
hurting	11	39	1403	2	hurting
hutting	11	30	1603	2	hutting
hying	12	65	1474	2	h_ying
hyping	15	40	848	2	hyping
jading	15	42	1402	2	jading
japing	16	50	1357	2	japing
jawing	17	44	1496	2	jawing
karting	12	37	1606	2	karting
kiting	11	41	1709	2	kiting
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
lasting	8	47	2524	2	lasting
lathing	11	43	1569	2	lathing
latina	6	56	2114	2	latina
latino	6	41	2047	2	latino
laving	10	46	2357	2	laving
lawing	10	46	2528	2	lawing
laying	10	45	2570	2	laying
lazing	16	48	2147	2	lazing
luting	7	52	2175	2	luting
macing	11	42	2155	2	macing
making	13	48	2385	2	making
malting	10	32	1908	2	malting
marting	10	33	2501	2	marting
masting	10	43	2582	2	masting
matin	7	51	3285	2	matin_
matings	10	45	1621	2	matings
matins	8	45	2778	2	matins
matting	10	36	2014	2	matting
mawing	12	40	2080	2	mawing
maxing	16	48	1707	2	maxing
maying	12	44	2115	2	maying
mazing	18	44	1897	2	mazing
meting	9	43	2059	2	meting
moating	10	42	1815	2	moating
muting	9	39	2152	2	muting
naming	9	39	1789	2	naming
noting	7	41	2015	2	noting
oaring	7	42	2530	2	oaring
opting	9	45	1440	2	opting
orating	8	35	2032	2	orating
outing	7	41	2815	2	outing
pacing	11	45	2275	2	pacing
paging	10	40	2040	2	paging
paling	9	35	3013	2	paling
panting	10	40	2542	2	panting
paring	9	42	3649	2	paring
parting	10	35	2738	2	parting
pasting	10	38	2655	2	pasting
patin	7	68	3285	2	patin_
patina	8	60	2219	2	patina
patine	8	53	2812	2	patine
patins	8	75	2878	2	patins
patting	10	37	2234	2	patting
paving	12	45	1974	2	paving
pawing	12	45	1955	2	pawing
paying	12	37	2216	2	paying
phasing	13	32	1167	2	phasing
plating	10	38	2307	2	plating
prating	10	34	2445	2	prating
racing	9	50	3053	2	racing
rafting	11	38	1575	2	rafting
raging	8	51	2643	2	raging
raking	11	47	2842	2	raking
ranting	8	40	2541	2	ranting
raping	9	48	2985	2	raping
raring	7	43	3287	2	raring
rasing	7	43	3083	2	rasing
ratine	6	51	3182	2	ratine
ratings	8	42	1741	2	ratings
ratting	8	38	2236	2	ratting
raving	10	51	2885	2	raving
raxing	14	43	2102	2	raxing
raying	10	50	2719	2	raying
razing	16	45	2454	2	razing
salting	8	41	2079	2	salting
saning	7	51	2764	2	saning
satang	7	57	1156	2	satang
satin	5	59	3522	2	satin_
satins	6	49	3048	2	satins
satiny	9	38	1798	2	satiny
saving	10	47	2451	2	saving
sawing	10	43	2381	2	sawing
saying	10	43	2554	2	saying
seating	8	41	3068	2	seating
shading	12	31	1556	2	shading
shafting	15	27	868	2	shafting
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
shuting	11	32	1205	2	shuting
siting	7	41	2662	2	siting
skating	12	36	1385	2	skating
slating	8	37	2465	2	slating
stating	8	37	2516	2	stating
sting	6	53	3024	2	_sting
taking	11	47	2595	2	taking
taming	9	40	2343	2	taming
taping	9	42	2239	2	taping
taring	7	39	3228	2	taring
tarting	8	42	2265	2	tarting
tasting	8	46	2421	2	tasting
tatting	8	40	1952	2	tatting
tauting	8	33	1638	2	tauting
tawing	10	45	2155	2	tawing
taxing	14	38	1671	2	taxing
thawing	14	37	868	2	thawing
ting	5	61	3990	2	__ting
toting	7	41	2379	2	toting
vatting	11	36	1485	2	vatting
voting	10	39	1603	2	voting
wading	11	46	1953	2	wading
wafting	14	39	1166	2	wafting
waging	11	43	1838	2	waging
waiting	11	36	1895	2	waiting
waking	14	48	2138	2	waking
waling	10	45	2530	2	waling
waning	10	36	2380	2	waning
wanting	11	42	2017	2	wanting
waring	10	50	2944	2	waring
wasting	11	44	2284	2	wasting
waving	13	40	1820	2	waving
waxing	17	42	1528	2	waxing
whaling	14	39	1077	2	whaling
whiting	14	33	1130	2	whiting
witing	10	35	2282	2	witing
wyting	13	27	724	2	wyting
yawing	13	42	1561	2	yawing

Search took 4 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.626	285448.9
2	DLD Change Limit	82551	299	2.733	30205.3
3	Display Results	299	299	0.106	2820.8
	(SQL Overall)	178691	299	3.465	51570.3