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

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

348 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
pains	7	51	3828	(None)
ains	4	61	5888	1	_ains
cains	7	53	3430	1	cains
gains	6	57	2951	1	gains
kains	9	61	2564	1	kains
mains	7	56	3511	1	mains
paiks	11	47	1985	1	paiks
pails	7	58	3306	1	pails
pain	6	56	4724	1	pain_
paint	7	54	4369	1	paint
paints	8	59	2183	1	paints
pairs	7	53	2583	1	pairs
pans	6	58	5573	1	pa_ns
patins	8	75	2878	1	patins
pavins	11	49	1966	1	pavins
pawns	10	88	1813	1	pawns
peins	7	61	2806	1	peins
pians	7	51	2696	1	pians
pins	6	55	5845	1	p_ins
plains	8	50	1959	1	plains
pyins	10	58	1586	1	pyins
rains	5	51	4023	1	rains
sains	5	56	3997	1	sains
tains	5	49	3632	1	tains
wains	8	69	3087	1	wains
aids	5	78	4636	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	3432	2	amins
anis	4	57	4646	2	_anis
aping	8	73	2723	2	aping
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	5514	2	ba_ns
barns	7	63	3514	2	barns
basins	8	57	2276	2	basins
bins	6	65	4825	2	_bins
blains	8	45	1637	2	blains
brains	8	51	2547	2	brains
brins	7	55	3397	2	brins
cabins	10	44	1892	2	cabins
caids	8	52	2642	2	caids
cain	6	56	4391	2	cain_
cairns	8	53	1330	2	cairns
cans	6	50	5085	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	4815	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	4737	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
gain	5	60	4216	2	gain_
gainst	7	49	1470	2	gainst
gaits	6	57	2601	2	gaits
gamins	9	44	2005	2	gamins
gins	5	55	4395	2	_gins
grains	7	42	2309	2	grains
grins	6	54	2722	2	grins
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	4791	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	2714	2	maids
mails	7	60	3778	2	mails
maims	9	63	2179	2	maims
main	6	53	4552	2	main_
mairs	7	62	2830	2	mairs
mans	6	63	5455	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	3940	2	na_ns
opsins	8	4	1171	2	opsins
pacas	9	60	2940	2	pacas
paces	9	67	4111	2	paces
pacing	11	45	2275	2	pacing
packs	13	55	2893	2	packs
pacs	8	58	4218	2	pa_cs
pacts	9	51	2580	2	pacts
padis	8	62	2714	2	padis
pads	7	67	4295	2	pa_ds
paeans	8	51	1826	2	paeans
paeons	8	39	1552	2	paeons
pagans	9	57	1792	2	pagans
pages	8	52	3507	2	pages
paging	10	40	2040	2	paging
pagings	11	44	1106	2	pagings
paid	7	57	3748	2	pai_d
paik	10	57	2680	2	pai_k
pail	6	61	4183	2	pai_l
painch	13	35	1132	2	painch
pained	9	56	2285	2	pained
painty	11	47	1475	2	painty
pair	6	60	3151	2	pai_r
paisa	7	60	2107	2	paisa
paisans	9	36	1475	2	paisans
paisas	8	43	1749	2	paisas
paise	7	50	2833	2	paise
pales	7	57	5380	2	pales
paling	9	35	3013	2	paling
palings	10	39	1582	2	palings
palls	7	43	3256	2	palls
palms	9	49	2175	2	palms
palps	9	47	1956	2	palps
pals	6	69	5135	2	pa_ls
pams	8	56	4176	2	pa_ms
pan	5	84	6645	2	pa_n_
pane	6	49	5029	2	pa_ne
panes	7	61	4869	2	panes
pang	7	53	3629	2	pa_ng
pangs	8	46	2866	2	pangs
panic	9	39	2390	2	panic
panics	10	38	1536	2	panics
panini	8	3	1427	2	panini
panino	8	3	1568	2	panino
panne	7	66	2365	2	panne
pannes	8	55	2285	2	pannes
pansy	10	57	1797	2	pa_nsy
pant	6	60	6126	2	pa_nt
pants	7	65	3692	2	pants
papains	11	3	1236	2	papains
papas	9	49	2749	2	papas
paps	8	64	4345	2	pa_ps
paras	7	61	4304	2	paras
pards	8	56	3433	2	pards
pares	7	71	6448	2	pares
parians	9	35	1973	2	parians
paries	8	47	4251	2	paries
paring	9	42	3649	2	paring
parings	10	42	1921	2	parings
paris	7	51	4594	2	paris
parks	11	61	3446	2	parks
parrs	7	59	2867	2	parrs
pars	6	75	6079	2	pa_rs
parts	7	77	4337	2	parts
pas	5	87	7574	2	pa__s
pases	7	53	4650	2	pases
pass	6	52	3995	2	pa_ss
pasts	7	59	3650	2	pasts
patens	8	48	2086	2	patens
pates	7	60	4789	2	pates
paths	10	55	2138	2	paths
patin	7	68	3285	2	patin_
patina	8	60	2219	2	patina
patinas	9	63	1852	2	patinas
patine	8	53	2812	2	patine
patines	9	52	2576	2	patines
patios	8	52	2178	2	patios
pats	6	64	6085	2	pa_ts
paulins	9	3	1261	2	paulins
pavans	11	57	1559	2	pavans
paves	10	48	3392	2	paves
pavin	10	56	2320	2	pavin_
paving	12	45	1974	2	paving
pavings	13	40	1163	2	pavings
pavis	10	64	2273	2	pavis
pawing	12	45	1955	2	pawing
pawls	10	56	1766	2	pawls
pawn	9	46	2530	2	pawn_
paws	9	60	3818	2	pa_ws
paxes	14	49	2842	2	paxes
paying	12	37	2216	2	paying
pays	9	59	4022	2	pa_ys
peans	7	54	3764	2	peans
peens	7	64	2819	2	peens
pein	6	58	3494	2	pein_
pekins	12	18	1223	2	pekins
penis	7	51	2932	2	penis
pens	6	56	4964	2	p_ens
peons	7	53	2718	2	peons
phis	9	57	2490	2	phi_s
phons	10	52	2114	2	phons
pian	6	61	3609	2	pian_
piano	7	61	1871	2	piano
pianos	8	43	1593	2	pianos
pias	6	65	4255	2	p_ias
pics	8	56	3391	2	p_ics
pies	6	69	4960	2	p_ies
pigs	7	66	3422	2	p_igs
piing	8	52	1883	2	piing
pin	5	70	6672	2	p_in_
pina	6	58	4263	2	p_ina
pinas	7	54	3445	2	p_inas
pine	6	77	5571	2	p_ine
pines	7	60	4886	2	p_ines
ping	7	59	4359	2	p_ing
pings	8	58	3088	2	p_ings
pink	10	70	3938	2	p_ink
pinks	11	57	2938	2	p_inks
pint	6	69	6317	2	p_int
pints	7	59	3622	2	p_ints
piny	9	118	3835	2	p_iny
pions	7	58	2639	2	pions
pips	8	58	3713	2	p_ips
pirns	7	60	2009	2	pirns
pis	5	63	6203	2	p_i_s
piss	6	50	3333	2	p_iss
pits	6	63	4874	2	p_its
plaids	9	43	1244	2	plaids
plain	7	48	2330	2	plain_
plaint	8	53	2320	2	plaint
plaints	9	40	1205	2	plaints
plaits	8	38	1647	2	plaits
plans	7	57	3127	2	plans
plies	7	45	2651	2	plies
plink	11	52	1912	2	plink
plinks	12	49	1326	2	plinks
poind	8	42	1791	2	poind
poinds	9	35	1114	2	poinds
point	7	53	3873	2	point
points	8	56	1853	2	points
pois	6	65	3904	2	poi_s
pons	6	58	5060	2	p_ons
poons	7	54	3097	2	poons
porns	7	55	2734	2	porns
prawns	11	50	902	2	prawns
pries	7	43	3953	2	pries
prigs	8	52	1970	2	prigs
prims	9	54	2593	2	prims
prink	11	47	1967	2	prink
prinks	12	43	1538	2	prinks
print	7	48	3746	2	print
prints	8	43	2010	2	prints
prions	8	43	1778	2	prions
priss	7	46	2389	2	priss
psis	6	81	2034	2	psi_s
puns	6	66	4148	2	p_uns
purins	8	37	2265	2	purins
pyin	9	68	2323	2	pyin_
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
reins	5	62	3456	2	reins
rins	4	61	5319	2	_rins
ruins	5	58	2203	2	ruins
sabins	8	55	2198	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	5336	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
spails	8	48	1782	2	spails
spaits	8	50	1747	2	spaits
spans	7	45	2873	2	spa_ns
spavins	12	41	932	2	spavins
spawns	11	57	792	2	spawns
spins	7	53	2798	2	spins
sprains	9	30	1359	2	sprains
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	5482	2	ta_ns
tarns	5	64	3395	2	tarns
thins	8	58	2633	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	3673	2	va_ns
veins	8	46	2049	2	veins
waifs	11	57	1987	2	waifs
wails	8	66	3148	2	wails
wain	7	58	4020	2	wain_
wairs	8	64	2406	2	wairs
waits	8	83	3352	2	waits
wans	7	64	5227	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 2 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.326	548131.9
2	DLD Change Limit	53800	348	1.470	36598.6
3	Display Results	348	348	0.106	3283.0
	(SQL Overall)	178691	348	1.902	93949.0