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

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

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
gaming	10	46	2204	(None)
faming	12	49	2297	1	faming
gaeing	8	46	1722	1	gaeing
gaging	9	47	1840	1	gaging
gamin	8	44	2300	1	gamin_
gamine	9	46	2015	1	gamine
gamings	11	46	1091	1	gamings
gamins	9	44	2005	1	gamins
gamming	13	31	1262	1	gamming
gaping	10	56	1892	1	gaping
gating	8	48	2695	1	gating
gauming	11	31	971	1	gauming
gazing	17	47	1717	1	gazing
laming	9	45	2836	1	laming
naming	9	39	1789	1	naming
taming	9	40	2343	1	taming
aahing	10	190	1576	2	aahing
acing	8	74	2915	2	_acing
ageing	8	42	1340	2	ageing
aging	7	70	2635	2	_aging
ahing	9	89	2835	2	_ahing
aiming	9	43	2084	2	aiming
amin	6	60	4225	2	_amin_
amine	7	58	3538	2	_amine
amino	7	54	2550	2	_amino
amins	7	55	3432	2	_amins
among	8	58	1330	2	_among
amping	11	43	1757	2	_amping
aping	8	73	2723	2	_aping
arming	9	47	1980	2	arming
awing	9	68	2732	2	_awing
axing	13	85	2137	2	_axing
baaing	9	49	1616	2	baaing
baking	13	56	2662	2	baking
baling	9	48	2969	2	baling
bamming	14	46	1181	2	bamming
baning	9	51	2783	2	baning
baring	9	51	3585	2	baring
basing	9	54	2766	2	basing
bating	9	51	3225	2	bating
baying	12	52	2258	2	baying
beaming	12	36	1880	2	beaming
blaming	12	35	1569	2	blaming
caging	10	53	2102	2	caging
caking	13	46	2467	2	caking
calming	12	39	1597	2	calming
camping	14	31	1897	2	camping
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
coaming	12	38	1832	2	coaming
coming	11	42	2545	2	coming
damming	13	38	1274	2	damming
damning	11	42	1163	2	damning
damping	13	34	1400	2	damping
daring	8	49	2868	2	daring
dating	8	53	2648	2	dating
dawing	11	48	1982	2	dawing
dazing	17	55	1651	2	dazing
doming	10	42	1839	2	doming
earing	7	52	3548	2	earing
easing	7	49	2646	2	easing
eating	7	51	3440	2	eating
facing	12	53	2157	2	facing
fading	11	48	2111	2	fading
faking	14	55	2098	2	faking
famine	11	43	1819	2	famine
faring	10	52	3128	2	faring
farming	13	35	1508	2	farming
fating	10	53	2867	2	fating
faxing	17	51	1705	2	faxing
faying	13	45	2107	2	faying
fazing	19	44	1864	2	fazing
flaming	13	42	1644	2	flaming
foaming	13	36	1299	2	foaming
framing	13	30	1479	2	framing
fuming	12	40	1329	2	fuming
gabbing	13	35	1203	2	gabbing
gabling	11	35	1454	2	gabling
gadding	11	34	1145	2	gadding
gaffing	15	37	973	2	gaffing
gagging	9	30	1352	2	gagging
gain	5	60	4216	2	ga_in_
gaining	9	40	1566	2	gaining
gains	6	57	2951	2	ga_ins
gaiting	9	37	1658	2	gaiting
galling	9	39	2196	2	galling
gambling	14	21	896	2	gambling
gamic	10	39	1620	2	gami_c
gamier	9	36	1793	2	gamier
gamily	12	37	1218	2	gamily
gamines	10	36	1846	2	gamines
gang	6	60	3197	2	ga__ng
ganging	10	32	1619	2	ganging
gaoling	9	33	1465	2	gaoling
gapping	13	42	1478	2	gapping
garbing	11	36	1327	2	garbing
garring	9	31	1671	2	garring
gashing	12	51	1923	2	gashing
gasking	13	44	1591	2	gasking
gasping	11	37	1436	2	gasping
gassing	9	42	1633	2	gassing
gasting	9	50	2276	2	gasting
gatings	9	52	1282	2	gatings
gauging	10	33	996	2	gauging
gawking	16	39	882	2	gawking
gawping	14	41	846	2	gawping
gearing	9	28	1884	2	gearing
geeing	8	43	1377	2	geeing
gemming	13	28	915	2	gemming
gibing	10	37	1235	2	gibing
gieing	8	36	1485	2	gieing
gimping	13	37	1076	2	gimping
giving	11	43	1388	2	giving
glaring	9	37	1488	2	glaring
glazing	18	36	1100	2	glazing
gleaming	12	27	793	2	gleaming
gliming	11	33	1013	2	gliming
gloaming	12	26	801	2	gloaming
gluing	8	38	1205	2	gluing
gnawing	12	37	790	2	gnawing
goading	10	31	1285	2	goading
goaling	9	35	1533	2	goaling
going	7	52	1849	2	g_oing
goring	8	41	1957	2	goring
gorming	11	28	1083	2	gorming
gracing	11	32	1644	2	gracing
grading	10	39	1871	2	grading
grating	9	39	2318	2	grating
graving	12	31	1456	2	graving
graying	12	41	1588	2	graying
grazing	18	35	1455	2	grazing
griming	11	36	1249	2	griming
gumming	13	38	1019	2	gumming
guying	11	37	972	2	guying
gybing	13	35	593	2	gybing
gyring	11	39	1036	2	gyring
gyving	14	41	571	2	gyving
hading	11	39	2294	2	hading
haeing	10	41	1892	2	haeing
haling	10	42	2978	2	haling
hamming	15	30	1409	2	hamming
haring	10	42	3300	2	haring
harming	13	37	1793	2	harming
hating	10	49	2971	2	hating
having	13	42	2037	2	having
hawing	13	43	2235	2	hawing
haying	13	44	2061	2	haying
hazing	19	42	1855	2	hazing
homing	12	37	1838	2	homing
jading	15	42	1402	2	jading
jambing	19	32	853	2	jambing
jamming	19	32	979	2	jamming
japing	16	50	1357	2	japing
jawing	17	44	1496	2	jawing
lacing	9	46	2623	2	lacing
lading	8	42	2712	2	lading
laking	11	50	2704	2	laking
lambing	12	34	1241	2	lambing
lamina	8	49	2044	2	lamina
lamming	12	30	1458	2	lamming
lamping	12	31	1600	2	lamping
lasing	7	47	2798	2	lasing
laving	10	46	2357	2	laving
lawing	10	46	2528	2	lawing
laying	10	45	2570	2	laying
lazing	16	48	2147	2	lazing
liming	9	40	2124	2	liming
loaming	10	36	1373	2	loaming
macing	11	42	2155	2	macing
maiming	12	29	1272	2	maiming
making	13	48	2385	2	making
mating	9	48	3291	2	mating
mawing	12	40	2080	2	mawing
maxing	16	48	1707	2	maxing
maying	12	44	2115	2	maying
mazing	18	44	1897	2	mazing
miming	11	43	1726	2	miming
oaring	7	42	2530	2	oaring
pacing	11	45	2275	2	pacing
paging	10	40	2040	2	paging
paling	9	35	3013	2	paling
palming	12	39	1401	2	palming
paring	9	42	3649	2	paring
paving	12	45	1974	2	paving
pawing	12	45	1955	2	pawing
paying	12	37	2216	2	paying
racing	9	50	3053	2	racing
raging	8	51	2643	2	raging
raking	11	47	2842	2	raking
ramming	12	31	1506	2	ramming
ramping	12	33	1687	2	ramping
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
raying	10	50	2719	2	raying
razing	16	45	2454	2	razing
reaming	10	39	2401	2	reaming
riming	9	33	2222	2	riming
roaming	10	32	1579	2	roaming
saning	7	51	2764	2	saning
sating	7	47	3545	2	sating
saving	10	47	2451	2	saving
sawing	10	43	2381	2	sawing
saying	10	43	2554	2	saying
seaming	10	32	2211	2	seaming
shaming	13	30	1674	2	shaming
taking	11	47	2595	2	taking
tamping	12	28	1581	2	tamping
taping	9	42	2239	2	taping
taring	7	39	3228	2	taring
tawing	10	45	2155	2	tawing
taxing	14	38	1671	2	taxing
teaming	10	39	1759	2	teaming
timing	9	36	1930	2	timing
vamping	15	28	1023	2	vamping
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
warming	13	35	1508	2	warming
waving	13	40	1820	2	waving
waxing	17	42	1528	2	waxing
yawing	13	42	1561	2	yawing

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	231	2.313	35690.0
3	Display Results	231	231	0.076	3039.5
	(SQL Overall)	178691	231	2.749	65002.2