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

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

301 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
gains	6	57	2951	(None)
ains	4	61	5888	1	_ains
cains	7	53	3430	1	cains
gain	5	60	4216	1	gain_
gainst	7	49	1469	1	gainst
gaits	6	57	2601	1	gaits
gamins	9	44	2004	1	gamins
gins	5	55	4395	1	g_ins
grains	7	42	2309	1	grains
grins	6	54	2722	1	grins
kains	9	61	2564	1	kains
mains	7	56	3509	1	mains
pains	7	51	3828	1	pains
rains	5	51	4023	1	rains
sains	5	56	3997	1	sains
tains	5	49	3632	1	tains
wains	8	69	3086	1	wains
again	6	52	1811	2	again_
against	8	3	838	2	against
agin	5	61	3271	2	agin_
aging	7	70	2635	2	aging
agings	8	63	1267	2	agings
agios	6	59	1986	2	agios
agons	6	64	2378	2	agons
aids	5	78	4635	2	_aids
ails	4	56	5471	2	_ails
aims	6	77	3818	2	_aims
ain	3	75	7909	2	_ain_
airns	5	55	2103	2	_airns
airs	4	64	4742	2	_airs
ais	3	90	8357	2	_ai_s
aits	4	63	5553	2	_aits
amins	7	55	3431	2	amins
anis	4	57	4646	2	_anis
awns	7	53	2443	2	_awns
ayins	8	53	2161	2	ayins
bails	7	59	3352	2	bails
bairns	8	67	1087	2	bairns
baits	7	66	3058	2	baits
banns	7	53	2123	2	banns
bans	6	65	5513	2	ba_ns
barns	7	63	3514	2	barns
basins	8	57	2276	2	basins
bins	6	65	4824	2	_bins
blains	8	45	1637	2	blains
brains	8	51	2547	2	brains
brins	7	55	3397	2	brins
cabins	10	44	1891	2	cabins
caids	8	52	2642	2	caids
cain	6	56	4391	2	cain_
cairns	8	53	1330	2	cairns
cans	6	50	5084	2	ca_ns
carns	7	59	3756	2	carns
chains	11	48	1970	2	chains
chins	10	56	3146	2	chins
coins	7	58	3455	2	coins
dais	5	70	4070	2	dai_s
damns	8	49	1692	2	damns
dans	5	67	4814	2	da_ns
darns	6	69	2789	2	darns
dawns	9	59	1659	2	dawns
dins	5	66	5204	2	_dins
djins	13	6	845	2	djins
drains	7	37	1940	2	drains
earns	5	59	2756	2	earns
elains	6	49	1985	2	elains
fagins	10	5	1386	2	fagins
fails	8	56	3148	2	fails
fain	7	58	4056	2	fain_
faint	8	58	3706	2	faint
faints	9	48	1878	2	faints
fairs	8	58	2544	2	fairs
fans	7	62	4736	2	fa_ns
fauns	8	45	1675	2	fauns
fawns	11	59	1426	2	fawns
fins	7	58	4909	2	_fins
foins	8	55	2338	2	foins
gabies	9	38	2072	2	gabies
gabions	10	24	1005	2	gabions
gabs	7	67	4042	2	ga_bs
gadids	9	56	1182	2	gadids
gadis	7	48	2529	2	gadis
gads	6	78	4338	2	ga_ds
gaeing	8	46	1722	2	gaeing
gaen	5	73	2960	2	gaen_
gaes	5	63	4803	2	ga_es
gaffs	12	49	1465	2	gaffs
gages	7	45	2997	2	gages
gaging	9	47	1840	2	gaging
gags	6	64	4106	2	ga_gs
gaily	9	50	2097	2	gaily
gained	8	46	1746	2	gained
gainer	7	41	1749	2	gainer
gainers	8	42	1459	2	gainers
gainly	10	4	932	2	gainly
gainsay	11	4	403	2	gainsay
gait	5	61	5019	2	gai_t
galas	6	57	3164	2	galas
gales	6	54	4248	2	gales
galls	6	47	2932	2	galls
gals	5	79	4650	2	ga_ls
gamas	8	54	3135	2	gamas
gambs	10	57	2112	2	gambs
games	8	62	3855	2	games
gamin	8	44	2299	2	gamin_
gamine	9	46	2015	2	gamine
gamines	10	36	1846	2	gamines
gaming	10	46	2204	2	gaming
gamings	11	46	1091	2	gamings
gamps	10	53	2371	2	gamps
gams	7	66	4888	2	ga_ms
gan	4	80	6012	2	ga_n_
gane	5	51	4529	2	ga_ne
gang	6	60	3196	2	ga_ng
gangs	7	62	2257	2	gangs
gaols	6	67	1757	2	gaols
gapes	8	60	3082	2	gapes
gaping	10	56	1892	2	gaping
gaps	7	60	4297	2	ga_ps
garbs	8	63	2141	2	garbs
garni	6	3	1570	2	garni
gars	5	57	5074	2	ga_rs
gas	4	88	7025	2	ga__s
gases	6	56	3399	2	gases
gaskins	12	35	1077	2	gaskins
gasps	8	54	1548	2	gasps
gasts	6	66	2863	2	gasts
gates	6	59	3950	2	gates
gating	8	48	2695	2	gating
gatings	9	52	1282	2	gatings
gats	5	67	5344	2	ga_ts
gauds	7	57	1772	2	gauds
gaums	8	62	1707	2	gaums
gaun	5	64	2771	2	gaun_
gaunt	6	54	3040	2	gaunt
gaurs	6	63	1799	2	gaurs
gauss	6	56	1345	2	gauss
gawks	13	68	1163	2	gawks
gawps	11	59	1101	2	gawps
gays	8	73	3802	2	ga_ys
gazes	15	54	2591	2	gazes
gazing	17	47	1717	2	gazing
gens	5	57	4007	2	g_ens
ghis	8	50	2016	2	ghi_s
giant	6	54	3059	2	giant
giants	7	47	1350	2	giants
gibs	7	55	2926	2	g_ibs
gids	6	59	3373	2	g_ids
gies	5	56	4142	2	g_ies
gigs	6	66	3118	2	g_igs
gin	4	60	5575	2	g_in_
gink	9	71	2952	2	g_ink
ginks	10	43	1956	2	g_inks
gips	7	56	3292	2	g_ips
girns	6	45	1680	2	girns
gits	5	57	4459	2	g_its
glairs	7	52	1133	2	glairs
glans	6	51	2583	2	glans
glens	6	65	1985	2	glens
glias	6	46	1849	2	glias
glims	8	74	1767	2	glims
glint	6	68	3018	2	glint
glints	7	57	1421	2	glints
going	7	52	1849	2	going
goings	8	49	1152	2	goings
goons	6	53	2677	2	goons
gowns	9	51	1510	2	gowns
gradins	9	34	1623	2	gradins
grails	7	75	1878	2	grails
grain	6	51	2625	2	grain_
grainy	10	39	1421	2	grainy
grans	6	48	3254	2	grans
gratins	8	41	1918	2	gratins
grids	7	53	2139	2	grids
grigs	7	53	1819	2	grigs
grin	5	57	3372	2	grin_
grind	7	59	1756	2	grind
grinds	8	45	1184	2	grinds
grips	8	55	2013	2	grips
grits	6	55	2958	2	grits
groins	7	39	1720	2	groins
guanins	8	8	1001	2	guanins
guans	6	44	1944	2	guans
guids	7	55	1615	2	guids
guns	5	55	3348	2	g_uns
gwine	9	55	1366	2	gwine
haiks	12	51	2093	2	haiks
hails	8	52	3164	2	hails
haint	8	54	3632	2	haint
haints	9	44	1758	2	haints
hairs	8	62	2517	2	hairs
hins	7	64	4799	2	_hins
ins	3	59	4560	2	__ins
jails	12	54	2294	2	jails
jins	11	56	3501	2	_jins
joins	12	58	1841	2	joins
kaifs	12	57	1564	2	kaifs
kails	9	55	2521	2	kails
kain	8	53	3429	2	kain_
kaons	9	50	1485	2	kaons
karns	9	66	2414	2	karns
kins	8	57	4790	2	_kins
laics	7	64	1925	2	laics
lain	4	61	4628	2	lain_
lairs	5	54	2587	2	lairs
lapins	8	45	2068	2	lapins
lawns	8	52	1542	2	lawns
layins	9	38	1765	2	layins
lins	4	70	5905	2	_lins
loins	5	67	2842	2	loins
maids	8	63	2713	2	maids
mails	7	60	3777	2	mails
maims	9	63	2178	2	maims
main	6	53	4550	2	main_
mairs	7	62	2829	2	mairs
mans	6	63	5453	2	ma_ns
matins	8	45	2778	2	matins
mavins	11	51	1918	2	mavins
naans	5	58	1525	2	naans
naifs	8	76	1742	2	naifs
nails	5	57	3040	2	nails
nans	4	61	3939	2	na_ns
paiks	11	47	1985	2	paiks
pails	7	58	3306	2	pails
pain	6	56	4724	2	pain_
paint	7	54	4369	2	paint
paints	8	59	2183	2	paints
pairs	7	53	2583	2	pairs
pans	6	58	5572	2	pa_ns
patins	8	75	2878	2	patins
pavins	11	49	1966	2	pavins
pawns	10	88	1813	2	pawns
peins	7	61	2806	2	peins
pians	7	51	2696	2	pians
pins	6	55	5845	2	_pins
plains	8	50	1959	2	plains
pyins	10	58	1586	2	pyins
qaids	15	61	1631	2	qaids
quins	14	48	1985	2	quins
raias	5	46	3112	2	raias
raids	6	58	2751	2	raids
rails	5	59	3740	2	rails
rain	4	62	5173	2	rain_
rainy	8	59	2108	2	rainy
rais	4	52	5262	2	rai_s
ranis	5	52	3583	2	ranis
ravins	9	46	2256	2	ravins
rawins	9	56	1762	2	rawins
regains	8	43	1658	2	regains
reins	5	62	3456	2	reins
rins	4	61	5319	2	_rins
ruins	5	58	2203	2	ruins
sabins	8	55	2197	2	sabins
saids	6	53	2885	2	saids
sails	5	57	3810	2	sails
sain	4	55	5129	2	sain_
saint	5	51	4707	2	saint
saints	6	51	2242	2	saints
sans	4	51	5335	2	sa_ns
sarins	6	39	3262	2	sarins
sasins	6	49	2310	2	sasins
satins	6	49	3048	2	satins
savins	9	39	2313	2	savins
shins	8	51	3104	2	shins
sins	4	67	5527	2	_sins
skins	9	47	2346	2	skins
spins	7	53	2798	2	spins
stains	6	49	2365	2	stains
swains	9	45	1395	2	swains
tails	5	56	3419	2	tails
tain	4	55	4807	2	tain_
taint	5	55	4228	2	taint
taints	6	45	2053	2	taints
takins	10	51	1740	2	takins
tans	4	61	5481	2	ta_ns
tarns	5	64	3395	2	tarns
thins	8	58	2632	2	thins
tins	4	52	5130	2	_tins
trains	6	47	2534	2	trains
twains	9	58	1118	2	twains
twins	8	51	1898	2	twins
vails	8	58	2593	2	vails
vain	7	52	3300	2	vain_
vairs	8	50	1913	2	vairs
vans	7	62	3672	2	va_ns
veins	8	46	2049	2	veins
waifs	11	57	1987	2	waifs
wails	8	66	3148	2	wails
wain	7	58	4019	2	wain_
wairs	8	64	2406	2	wairs
waits	8	83	3352	2	waits
wans	7	64	5226	2	wa_ns
warns	8	72	3100	2	warns
whins	11	49	2233	2	whins
wins	7	59	4917	2	_wins
yarns	8	56	2179	2	yarns
yawns	11	42	1327	2	yawns
yins	7	53	3512	2	_yins
zayins	18	40	971	2	zayins
zeins	14	47	1539	2	zeins
zins	13	57	3500	2	_zins

Search took 7 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	53800	0.530	337152.8
2	DLD Change Limit	53800	301	5.016	10725.7
3	Display Results	301	301	0.153	1967.3
	(SQL Overall)	178691	301	5.699	31354.8