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

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

236 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
gamers	9	44	2083	(None)
gagers	8	40	2133	1	gagers
gamer	8	49	2894	1	gamer_
games	8	62	3855	1	game_s
gammers	12	32	1456	1	gammers
gapers	9	45	2047	1	gapers
gaters	7	47	2864	1	gaters
gazers	16	45	1630	1	gazers
gomers	9	41	1688	1	gomers
namers	8	45	1733	1	namers
tamers	8	42	2403	1	tamers
agers	6	50	2785	2	_agers
aggers	8	58	1779	2	aggers
aimers	8	46	2191	2	aimers
ambers	10	45	1958	2	_ambers
ameers	8	40	1557	2	_ameers
amens	7	56	2484	2	_amens
amirs	7	59	2492	2	_amirs
apers	7	66	2913	2	_apers
armers	8	55	2027	2	armers
avers	8	51	2731	2	_avers
bakers	12	53	2345	2	bakers
balers	8	56	2693	2	balers
blamers	11	53	1421	2	blamers
cabers	10	50	2392	2	cabers
cagers	9	56	2419	2	cagers
cambers	13	40	1744	2	cambers
camels	10	52	1708	2	camels
cameos	10	58	1800	2	cameos
camera	10	3	1369	2	camera
cameras	11	3	1336	2	cameras
cames	9	70	4731	2	came_s
campers	13	42	2029	2	campers
caners	8	46	2920	2	caners
capers	10	54	2814	2	capers
carers	8	51	3396	2	carers
caters	8	53	3650	2	caters
cavers	11	50	2684	2	cavers
comers	10	53	2808	2	comers
damars	9	38	1500	2	damars
dames	8	54	3585	2	dame_s
dammers	12	32	1427	2	dammers
damners	10	41	1211	2	damners
dampers	12	39	1569	2	dampers
darers	7	59	2187	2	darers
daters	7	48	2737	2	daters
dimers	9	43	2109	2	dimers
eagers	7	45	2368	2	eagers
eaters	6	55	3595	2	eaters
emmers	10	40	1322	2	emmers
facers	11	55	1944	2	facers
faders	10	51	1746	2	faders
fakers	13	42	1953	2	fakers
fames	10	57	3592	2	fame_s
farers	9	59	2405	2	farers
farmers	12	43	1526	2	farmers
flamers	12	46	1636	2	flamers
foamers	12	38	1210	2	foamers
framers	12	51	1382	2	framers
fumers	11	36	1338	2	fumers
gabbers	12	46	1283	2	gabbers
gadders	10	36	1150	2	gadders
gaes	5	63	4803	2	ga_e_s
gaffers	14	42	871	2	gaffers
gager	7	47	2629	2	gager_
gages	7	45	2997	2	gage_s
gaggers	10	34	1366	2	gaggers
gainers	8	42	1459	2	gainers
gaiters	8	35	1654	2	gaiters
galeas	7	46	1851	2	galeas
galere	7	37	1668	2	galere
galeres	8	35	1434	2	galeres
gales	6	54	4248	2	gale_s
gamas	8	54	3136	2	gam_as
gamays	12	63	1091	2	gamays
gambas	11	58	1751	2	gambas
gambes	11	63	1831	2	gambes
gambiers	13	33	707	2	gambiers
gambirs	12	35	908	2	gambirs
gamblers	13	36	973	2	gamblers
gambs	10	57	2112	2	gam_bs
game	7	66	4432	2	game__
gamed	9	51	2639	2	game_d
gamely	12	47	1191	2	gamely
gamest	9	49	1993	2	gamest
gamete	9	3	1359	2	gamete
gametes	10	3	1225	2	gametes
gamey	11	53	2055	2	game_y
gamier	9	36	1793	2	gamier_
gamins	9	44	2005	2	gamins
gammas	11	57	1469	2	gammas
gammer	11	123	1833	2	gammer_
gamps	10	53	2371	2	gam_ps
gams	7	66	4888	2	gam__s
gamuts	9	5	878	2	gamuts
ganders	9	35	2170	2	ganders
ganefs	10	48	920	2	ganefs
ganevs	10	45	691	2	ganevs
gangers	9	44	1860	2	gangers
gaolers	8	35	1156	2	gaolers
gaper	8	61	2512	2	gaper_
gapes	8	60	3082	2	gape_s
garners	8	38	1598	2	garners
gars	5	57	5074	2	ga__rs
garters	8	42	1823	2	garters
gases	6	56	3399	2	gase_s
gaspers	10	50	1413	2	gaspers
gassers	8	47	1463	2	gassers
gasters	8	56	2429	2	gasters
gater	6	45	3365	2	gater_
gates	6	59	3951	2	gate_s
gathers	11	43	1507	2	gathers
gators	7	41	1584	2	gators
gaugers	9	42	1171	2	gaugers
gaurs	6	63	1799	2	ga_urs
gavels	10	59	1109	2	gavels
gawkers	15	34	745	2	gawkers
gawpers	13	44	831	2	gawpers
gayer	9	45	1919	2	gayer_
gazars	16	48	1155	2	gazars
gazer	15	57	2007	2	gazer_
gazes	15	54	2591	2	gaze_s
gibers	9	51	1466	2	gibers
gimels	9	3	889	2	gimels
givers	10	48	1771	2	givers
glamors	10	6	812	2	glamors
glazers	17	44	1004	2	glazers
gleamers	11	30	656	2	gleamers
gluers	7	50	1115	2	gluers
gnawers	11	35	639	2	gnawers
goers	6	55	2025	2	g_oers
gofers	10	47	1151	2	gofers
gomer	8	52	2065	2	gomer_
goners	7	44	2017	2	goners
graders	9	47	1601	2	graders
graters	8	54	1974	2	graters
gravers	11	45	1527	2	gravers
grazers	17	51	1245	2	grazers
gummers	12	37	1220	2	gummers
halers	9	49	2691	2	halers
hames	10	61	3870	2	hame_s
hammers	14	42	1606	2	hammers
hampers	14	36	1695	2	hampers
harmers	12	41	1659	2	harmers
haters	9	49	3040	2	haters
havers	12	47	2148	2	havers
hayers	12	44	1594	2	hayers
hazers	18	46	1595	2	hazers
homers	11	48	2198	2	homers
jagers	14	44	1572	2	jagers
jammers	18	37	1070	2	jammers
japers	15	46	1617	2	japers
kames	11	50	2469	2	kame_s
lacers	8	52	2525	2	lacers
laders	7	49	2776	2	laders
lagers	7	48	2614	2	lagers
lakers	10	52	2515	2	lakers
lambers	11	38	1711	2	lambers
lameds	9	48	1203	2	lameds
lamer	7	52	3370	2	lamer_
lames	7	54	4554	2	lame_s
lampers	11	38	1733	2	lampers
lasers	6	49	2570	2	lasers
lavers	9	45	2636	2	lavers
layers	9	39	2118	2	layers
macers	10	53	2127	2	macers
maimers	11	38	1304	2	maimers
makers	12	39	2173	2	makers
mameys	13	44	952	2	mameys
mammers	10	46	1569	2	mammers
mamzers	20	40	916	2	mamzers
masers	8	46	2345	2	masers
maters	8	50	3239	2	maters
mazers	17	39	1709	2	mazers
mimers	10	55	2018	2	mimers
namer	7	56	2210	2	namer_
names	7	48	3336	2	name_s
oaters	6	50	2979	2	oaters
omers	7	69	2319	2	_omers
ormers	8	43	1614	2	ormers
pacers	10	51	2454	2	pacers
pagers	9	44	2325	2	pagers
palmers	11	35	1362	2	palmers
pampers	13	36	1593	2	pampers
papers	10	51	2532	2	papers
parers	8	55	3074	2	parers
paters	8	49	3583	2	paters
pavers	11	50	2182	2	pavers
pawers	11	48	1878	2	pawers
payers	11	46	2182	2	payers
racers	8	47	2543	2	racers
rakers	10	41	2357	2	rakers
ramees	8	46	2089	2	ramees
ramets	8	35	1739	2	ramets
rammers	11	37	1504	2	rammers
rapers	8	43	2718	2	rapers
rasers	6	45	2678	2	rasers
raters	6	39	3658	2	raters
ravers	9	46	2818	2	ravers
razers	15	49	1961	2	razers
reamers	9	42	2108	2	reamers
rimers	8	45	2255	2	rimers
roamers	9	37	1346	2	roamers
sabers	8	52	2473	2	sabers
sakers	10	41	2543	2	sakers
sameks	12	40	932	2	sameks
savers	9	38	2592	2	savers
sawers	9	46	2016	2	sawers
sayers	9	42	2159	2	sayers
seamers	9	47	1943	2	seamers
tabers	8	46	2157	2	tabers
takers	10	39	2374	2	takers
talers	6	46	2814	2	talers
tamer	7	52	3010	2	tamer_
tames	7	52	4201	2	tame_s
tampers	11	35	1674	2	tampers
tapers	8	40	2581	2	tapers
taters	6	49	3220	2	taters
tawers	9	41	1860	2	tawers
taxers	13	40	1528	2	taxers
timers	8	44	2099	2	timers
vampers	14	31	1162	2	vampers
vomers	11	56	1494	2	vomers
waders	10	91	2064	2	waders
wafers	12	43	1614	2	wafers
wagers	10	51	2220	2	wagers
wakers	13	48	2249	2	wakers
walers	9	48	2446	2	walers
wames	10	64	3280	2	wame_s
warmers	12	45	1429	2	warmers
waters	9	50	3063	2	waters
wavers	12	50	2247	2	wavers
waxers	16	40	1430	2	waxers
yagers	10	51	1453	2	yagers
yamens	11	40	1082	2	yamens
yammers	14	34	1032	2	yammers

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.343	520965.0
2	DLD Change Limit	82551	236	2.233	36968.7
3	Display Results	236	236	0.080	2950.0
	(SQL Overall)	178691	236	2.656	67278.2