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

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

450 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
puns	6	66	4148	(None)
buns	6	62	4372	1	buns
duns	5	51	4043	1	duns
funs	7	52	3573	1	funs
guns	5	55	3348	1	guns
huns	7	61	3693	1	huns
muns	6	55	3591	1	muns
nuns	4	52	2823	1	nuns
pans	6	58	5572	1	pans
pens	6	56	4964	1	pens
pins	6	55	5845	1	pins
pons	6	58	5060	1	pons
pubs	8	50	2921	1	pubs
puds	7	56	3051	1	puds
pugs	7	63	3277	1	pugs
puls	6	54	3756	1	puls
pun	5	88	4651	1	pun_
puna	6	53	3165	1	puna
punas	7	48	2675	1	punas
pung	7	54	2963	1	pung
pungs	8	54	2222	1	pungs
punk	10	57	2997	1	punk
punks	11	48	2268	1	punks
punt	6	57	4720	1	punt
punts	7	58	2800	1	punts
puny	9	55	2699	1	puny
pups	8	60	3223	1	pups
purs	6	56	4104	1	purs
pus	5	55	4784	1	pu_s
puss	6	48	3013	1	puss
puts	6	56	4175	1	puts
runs	4	64	3807	1	runs
suns	4	58	4190	1	suns
tuns	4	51	3866	1	tuns
uns	3	59	3675	1	_uns
ains	4	61	5888	2	ains
anus	4	71	3111	2	anus
auks	8	55	2526	2	auks
aunt	4	65	5365	2	aunt
aunts	5	52	2763	2	aunts
awns	7	53	2443	2	awns
bans	6	65	5513	2	bans
bens	6	59	4570	2	bens
bins	6	65	4824	2	bins
bubs	8	62	3549	2	bubs
buds	7	52	3517	2	buds
bugs	7	60	3591	2	bugs
bums	8	59	3459	2	bums
bun	5	63	4814	2	bun_
buna	6	47	3072	2	buna
bunas	7	51	2657	2	bunas
bund	7	55	3066	2	bund
bunds	8	55	2354	2	bunds
bung	7	57	3063	2	bung
bungs	8	53	2386	2	bungs
bunk	10	57	3135	2	bunk
bunks	11	51	2508	2	bunks
bunn	6	50	2365	2	bunn
bunns	7	47	1829	2	bunns
bunt	6	58	5085	2	bunt
bunts	7	57	2980	2	bunts
burns	7	49	2677	2	burns
burs	6	58	4742	2	burs
bus	5	69	5097	2	bu_s
buss	6	51	3491	2	buss
buts	6	72	4769	2	buts
buys	9	57	2679	2	buys
cans	6	50	5084	2	cans
cons	6	60	5769	2	cons
cubs	8	58	3238	2	cubs
cuds	7	67	3047	2	cuds
cues	6	54	3898	2	cues
cunt	6	62	4367	2	cunt
cunts	7	61	2512	2	cunts
cups	8	54	3082	2	cups
curns	7	49	2427	2	curns
curs	6	56	4554	2	curs
cuss	6	54	3061	2	cuss
cuts	6	58	4115	2	cuts
dans	5	67	4814	2	dans
dens	5	59	4507	2	dens
dins	5	66	5204	2	dins
dons	5	60	4870	2	dons
dubs	7	84	3219	2	dubs
duds	6	55	3014	2	duds
dues	5	60	4550	2	dues
dugs	6	148	3228	2	dugs
dun	4	65	4558	2	dun_
dune	5	61	3758	2	dune
dunes	6	53	3217	2	dunes
dung	6	63	2843	2	dung
dungs	7	58	2197	2	dungs
dunk	9	62	2857	2	dunk
dunks	10	56	2119	2	dunks
dunt	5	57	4687	2	dunt
dunts	6	58	2841	2	dunts
duos	5	67	2813	2	duos
dups	7	59	2951	2	dups
durns	6	48	1986	2	durns
ens	3	72	4592	2	_ens
eons	4	66	3871	2	eons
erns	4	54	2822	2	erns
fans	7	62	4736	2	fans
fauns	8	45	1675	2	fauns
fens	7	61	3976	2	fens
fins	7	58	4909	2	fins
fons	7	69	4389	2	fons
fubs	9	63	2879	2	fubs
fuds	8	65	2856	2	fuds
fugs	8	57	3069	2	fugs
fun	6	68	4114	2	fun_
fund	8	56	2498	2	fund
funds	9	41	1925	2	funds
funk	11	58	2562	2	funk
funks	12	53	1891	2	funks
furs	7	67	3504	2	furs
fuss	7	60	2793	2	fuss
gens	5	57	4007	2	gens
gins	5	55	4395	2	gins
gnus	5	65	1800	2	gnus
guans	6	44	1944	2	guans
guls	5	59	3085	2	guls
gums	7	50	3094	2	gums
gun	4	72	4080	2	gun_
gunk	9	54	2357	2	gunk
gunks	10	45	1772	2	gunks
guts	5	66	3725	2	guts
guvs	8	58	1681	2	guvs
guys	8	50	1964	2	guys
hens	7	56	4257	2	hens
hins	7	64	4799	2	hins
hons	7	73	5078	2	hons
hubs	9	60	2714	2	hubs
hues	7	52	3523	2	hues
hugs	8	61	2975	2	hugs
hums	9	68	3142	2	hums
hun	6	58	4471	2	hun_
hung	8	61	2635	2	hung
hunh	10	63	2373	2	hunh
hunk	11	60	2954	2	hunk
hunks	12	53	2145	2	hunks
hunt	7	64	4549	2	hunt
hunts	8	68	2617	2	hunts
huts	7	67	3744	2	huts
inns	4	69	2093	2	inns
ins	3	59	4560	2	_ins
ions	4	67	3785	2	ions
jins	11	56	3501	2	jins
jugs	12	55	2560	2	jugs
jun	10	59	3206	2	jun_
junk	15	51	2103	2	junk
junks	16	48	1597	2	junks
jus	10	69	3022	2	ju_s
juts	11	59	3016	2	juts
kens	8	54	3523	2	kens
kins	8	57	4790	2	kins
kues	8	64	2677	2	kues
kuna	8	51	2070	2	kuna
kune	8	54	2457	2	kune
lens	4	61	4649	2	lens
lins	4	70	5905	2	lins
lues	4	59	4355	2	lues
lugs	5	52	3352	2	lugs
lums	6	57	3424	2	lums
luna	4	62	2985	2	luna
lunas	5	50	2501	2	lunas
lune	4	71	4049	2	lune
lunes	5	53	3777	2	lunes
lung	5	57	3249	2	lung
lungs	6	52	2388	2	lungs
lunk	8	60	3072	2	lunk
lunks	9	48	2245	2	lunks
lunt	4	61	4884	2	lunt
lunts	5	58	2690	2	lunts
luny	7	73	2413	2	luny
luvs	7	58	1850	2	luvs
mans	6	63	5453	2	mans
mons	6	81	5225	2	mons
muds	7	55	3065	2	muds
mugs	7	62	3204	2	mugs
mums	8	57	3277	2	mums
mun	5	61	4385	2	mun_
muni	6	58	2440	2	muni
munis	7	50	2200	2	munis
muons	7	58	1617	2	muons
mus	5	59	4675	2	mu_s
muss	6	49	3376	2	muss
muts	6	48	3998	2	muts
nans	4	61	3939	2	nans
nouns	5	67	1731	2	nouns
nubs	6	59	2714	2	nubs
nun	3	55	3774	2	nun_
nus	3	79	3939	2	nu_s
nuts	4	50	3267	2	nuts
ons	3	61	4851	2	_ons
onus	4	58	2681	2	onus
opens	7	61	1855	2	opens
opus	6	64	2059	2	opu_s
ouds	5	64	3010	2	ouds
ours	4	72	3756	2	ours
outs	4	57	4696	2	outs
owns	7	68	1958	2	owns
pacs	8	58	4218	2	pacs
pads	7	67	4295	2	pads
pains	7	51	3828	2	pains
pals	6	69	5135	2	pals
pams	8	56	4176	2	pams
pan	5	84	6644	2	pan_
pane	6	49	5028	2	pane
panes	7	61	4869	2	panes
pang	7	53	3628	2	pang
pangs	8	46	2866	2	pangs
pansy	10	57	1797	2	pansy
pant	6	60	6125	2	pant
pants	7	65	3692	2	pants
paps	8	64	4345	2	paps
pars	6	75	6079	2	pars
pas	5	87	7574	2	p_as
pass	6	52	3995	2	pass
pats	6	64	6085	2	pats
pawns	10	88	1813	2	pawns
paws	9	60	3818	2	paws
pays	9	59	4022	2	pays
peans	7	54	3764	2	peans
peas	6	57	5506	2	peas
pecs	8	46	3410	2	pecs
peds	7	58	3524	2	peds
peens	7	64	2819	2	peens
pees	6	52	5737	2	pees
pegs	7	55	3176	2	pegs
pehs	9	56	2576	2	pehs
peins	7	61	2806	2	peins
pen	5	65	5884	2	pen_
pend	7	59	3453	2	pend
pends	8	55	2719	2	pends
penes	7	58	3922	2	penes
penis	7	51	2932	2	penis
pent	6	65	5907	2	pent
peons	7	53	2718	2	peons
peps	8	51	3451	2	peps
pes	5	72	5978	2	p_es
pets	6	62	4833	2	pets
pews	9	57	3153	2	pews
phis	9	57	2490	2	phis
phons	10	52	2114	2	phons
phuts	10	46	1350	2	phuts
pians	7	51	2696	2	pians
pias	6	65	4255	2	pias
pics	8	56	3391	2	pics
pies	6	69	4960	2	pies
pigs	7	66	3422	2	pigs
pin	5	70	6672	2	pin_
pina	6	58	4263	2	pina
pinas	7	54	3445	2	pinas
pine	6	77	5571	2	pine
pines	7	60	4886	2	pines
ping	7	59	4359	2	ping
pings	8	58	3088	2	pings
pink	10	70	3938	2	pink
pinks	11	57	2938	2	pinks
pint	6	69	6317	2	pint
pints	7	59	3622	2	pints
piny	9	118	3835	2	piny
pions	7	58	2639	2	pions
pips	8	58	3713	2	pips
pirns	7	60	2009	2	pirns
pis	5	63	6203	2	p_is
piss	6	50	3333	2	piss
pits	6	63	4874	2	pits
plans	7	57	3127	2	plans
plugs	8	52	1349	2	plugs
plums	9	46	1995	2	plums
plunk	11	45	1440	2	plunk
plunks	12	47	1116	2	plunks
plus	6	63	2483	2	plus
pods	7	65	4015	2	pods
pois	6	65	3904	2	pois
pols	6	60	4456	2	pols
poms	8	70	3774	2	poms
pond	7	55	3049	2	pond
ponds	8	53	2340	2	ponds
pone	6	57	4753	2	pone
pones	7	45	4704	2	pones
pong	7	62	3114	2	pong
pongs	8	55	2634	2	pongs
pony	9	64	3405	2	pony
poons	7	54	3096	2	poons
poos	6	59	4911	2	poos
pops	8	63	4095	2	pops
porns	7	55	2734	2	porns
pots	6	64	5236	2	pots
poufs	10	56	1606	2	poufs
pound	8	44	1786	2	pound
pounds	9	37	1438	2	pounds
pours	7	46	2318	2	pours
pouts	7	55	3032	2	pouts
pows	9	55	3766	2	pows
pros	6	57	4278	2	pros
prune	7	51	1963	2	prune
prunes	8	34	1906	2	prunes
prunus	8	39	936	2	prunus
psis	6	81	2034	2	psis
pub	7	60	3769	2	pu_b
pubes	9	44	2340	2	pubes
pubis	9	46	1646	2	pubis
puce	8	51	2788	2	puce
puces	9	49	2463	2	puces
puck	12	49	2794	2	puck
pucks	13	43	2210	2	pucks
pud	6	58	3665	2	pu_d
puff	12	55	2543	2	puff
puffs	13	41	1493	2	puffs
pug	6	53	3718	2	pu_g
pugh	10	66	1923	2	pugh
puja	13	57	1492	2	puja
pujas	14	55	1332	2	pujas
puke	10	50	2546	2	puke
pukes	11	45	2302	2	pukes
pul	5	61	3806	2	pu_l
pula	6	51	2937	2	pula
pule	6	50	4095	2	pule
pules	7	45	3881	2	pules
puli	6	55	2762	2	puli
pulis	7	42	2560	2	pulis
pull	6	47	3166	2	pull
pulls	7	44	2505	2	pulls
pulp	8	48	2535	2	pulp
pulps	9	51	1648	2	pulps
pulse	7	42	1997	2	pulse
puma	8	54	2412	2	puma
pumas	9	51	2156	2	pumas
pump	10	57	2685	2	pump
pumps	11	55	2060	2	pumps
punch	12	51	1842	2	punch
punish	11	14	1150	2	punish
punji	14	3	820	2	punji
punjis	15	3	669	2	punjis
punka	11	45	1548	2	punka
punkas	12	34	1067	2	punkas
punky	14	44	1939	2	punky
punny	10	42	1771	2	punny
punto	7	51	2132	2	punto
puntos	8	59	1579	2	puntos
punty	10	60	2161	2	punty
pup	7	63	3988	2	pu_p
pupa	8	54	2281	2	pupa
pupas	9	52	1928	2	pupas
pupu	8	76	2071	2	pupu
pupus	9	46	1404	2	pupus
pur	5	68	4055	2	pu_r
pure	6	55	4333	2	pure
puri	6	59	3144	2	puri
purins	8	37	2265	2	purins
puris	7	53	3202	2	puris
purl	6	56	3142	2	purl
purls	7	47	2335	2	purls
purr	6	49	2581	2	purr
purrs	7	53	2043	2	purrs
purse	7	60	2889	2	purse
pursy	10	50	1641	2	pursy
puses	7	55	3220	2	puses
push	9	55	2662	2	push
pussy	10	56	1484	2	pussy
put	5	57	5907	2	pu_t
putons	8	35	1515	2	putons
putt	6	69	3784	2	putt
putts	7	57	1927	2	putts
putz	15	83	2632	2	putz
pyas	9	62	2570	2	pyas
pyes	9	55	2899	2	pyes
pyins	10	58	1586	2	pyins
quins	14	48	1985	2	quins
rins	4	61	5319	2	rins
rubs	6	61	3349	2	rubs
rues	4	60	4448	2	rues
rugs	5	60	3368	2	rugs
ruins	5	58	2203	2	ruins
rums	6	48	3347	2	rums
run	3	62	4498	2	run_
rune	4	52	3629	2	rune
runes	5	55	3022	2	runes
rung	5	64	2997	2	rung
rungs	6	118	1940	2	rungs
runt	4	66	4798	2	runt
runts	5	59	2763	2	runts
ruts	4	45	4149	2	ruts
sans	4	51	5335	2	sans
shuns	8	50	1814	2	shuns
sins	4	67	5527	2	sins
sons	4	60	4955	2	sons
spans	7	45	2873	2	spans
spins	7	53	2798	2	spins
spuds	8	51	1367	2	spuds
spues	7	50	2538	2	spues
spun	6	62	2146	2	spun_
spunk	11	45	1340	2	spunk
spunks	12	34	933	2	spunks
spurns	8	48	1138	2	spurns
spurs	7	46	2152	2	spurs
stuns	5	47	1949	2	stuns
subs	6	60	3712	2	subs
suds	5	61	3529	2	suds
sues	4	62	4765	2	sues
suks	8	59	2712	2	suks
sums	6	58	3758	2	sums
sun	3	71	4903	2	sun_
sung	5	58	3217	2	sung
sunk	8	50	3181	2	sunk
sunn	4	54	2359	2	sunn
sunns	5	50	1735	2	sunns
sups	6	48	3443	2	sups
suqs	13	43	1965	2	suqs
suss	4	52	2930	2	suss
tans	4	61	5481	2	tans
tens	4	56	4741	2	tens
tins	4	52	5130	2	tins
tons	4	65	5305	2	tons
tubs	6	54	3006	2	tubs
tugs	5	62	3167	2	tugs
tuis	4	48	2964	2	tuis
tun	3	58	4519	2	tun_
tuna	4	51	2784	2	tuna
tunas	5	42	2412	2	tunas
tune	4	56	3586	2	tune
tunes	5	53	3219	2	tunes
tung	5	53	2816	2	tung
tungs	6	55	2062	2	tungs
tups	6	56	2876	2	tups
turns	5	56	2323	2	turns
tuts	4	58	3845	2	tuts
un	2	83	4113	2	_un_
upas	6	83	2238	2	upas
ups	5	56	2905	2	_ups
urns	4	63	2389	2	urns
us	2	69	3743	2	_u_s
uts	3	55	3437	2	_uts
vans	7	62	3672	2	vans
vugs	8	70	2287	2	vugs
wans	7	64	5226	2	wans
wens	7	63	3793	2	wens
wins	7	59	4917	2	wins
wons	7	49	4204	2	wons
wuss	7	52	1933	2	wuss
wyns	10	57	1703	2	wyns
yens	7	58	3226	2	yens
yins	7	53	3512	2	yins
yuans	8	46	1332	2	yuans
yuks	11	64	1802	2	yuks
yups	9	61	2160	2	yups
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	29872	0.076	2351197.4
2	DLD Change Limit	29872	450	1.516	19704.5
3	Display Results	450	450	0.220	2045.5
	(SQL Overall)	178691	450	1.812	98615.3