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

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

247 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
pht	8	60	3052	(None)
pat	5	80	8946	1	pat
pet	5	64	7730	1	pet
phat	9	58	3786	1	phat
phi	8	65	2420	1	phi
phot	9	55	3435	1	phot
phut	9	69	2597	1	phut
pit	5	64	7192	1	pit
pot	5	80	7843	1	pot
pst	5	79	3251	1	pst
put	5	57	5907	1	put
act	5	95	5784	2	act
aft	6	68	4901	2	aft
ah	5	138	6879	2	ah_
aha	6	112	4664	2	aha
ahi	6	80	4023	2	ahi
ahs	6	86	4482	2	ahs
ait	3	80	9390	2	ait
alt	3	64	6796	2	alt
ant	3	72	7078	2	ant
apt	5	73	5254	2	apt
art	3	86	7914	2	art
at	2	123	9340	2	_at
att	3	54	5465	2	att
baht	9	67	4001	2	baht
bat	5	109	8895	2	bat
bet	5	83	7667	2	bet
bhut	9	54	2571	2	bhut
bit	5	70	7089	2	bit
bot	5	96	8040	2	bot
but	5	59	6302	2	but
cat	5	82	8234	2	cat
chat	9	55	4613	2	chat
chi	8	62	2865	2	chi
chit	9	69	3746	2	chit
cot	5	104	8322	2	cot
cut	5	79	5766	2	cut
dit	4	70	7133	2	dit
dot	4	75	7318	2	dot
eat	3	69	8905	2	eat
echt	9	57	2290	2	echt
eft	6	60	3882	2	eft
eh	5	83	3996	2	eh_
epha	9	3	1005	2	epha
et	2	69	6419	2	_et
eth	6	66	3098	2	eth
fat	6	81	7808	2	fat
fet	6	64	7163	2	fet
fit	6	63	6545	2	fit
gat	4	68	8051	2	gat
get	4	74	6746	2	get
ghat	8	64	3528	2	ghat
ghi	7	70	1988	2	ghi
git	4	62	6605	2	git
got	4	98	7044	2	got
gut	4	67	5385	2	gut
ha	5	102	5994	2	_ha
hat	6	72	8996	2	hat
he	5	81	5195	2	_he
het	6	76	7431	2	het
hi	5	79	4758	2	_hi
hit	6	65	6919	2	hit
hm	7	81	2673	2	_hm
ho	5	102	5827	2	_ho
hot	6	77	7605	2	hot
hut	6	64	5729	2	hut
it	2	84	5568	2	_it
jet	10	67	5482	2	jet
jot	10	82	5902	2	jot
jut	10	59	4401	2	jut
kat	7	74	6829	2	kat
khat	11	67	3072	2	khat
khet	11	63	2862	2	khet
khi	10	63	1830	2	khi
kit	7	85	5987	2	kit
lat	3	75	9340	2	lat
let	3	64	8147	2	let
lit	3	93	7731	2	lit
lot	3	81	7926	2	lot
mat	5	80	8393	2	mat
met	5	60	7243	2	met
mho	8	66	2462	2	mho
mot	5	72	7942	2	mot
mut	5	83	5718	2	mut
net	3	66	7029	2	net
nit	3	70	6594	2	nit
not	3	94	7466	2	not
nth	6	63	2059	2	nth
nut	3	66	5196	2	nut
oat	3	98	8826	2	oat
oft	6	77	4406	2	oft
oh	5	74	4700	2	oh_
ohm	8	65	2301	2	ohm
oho	6	65	3438	2	oho
ohs	6	62	3231	2	ohs
oot	3	112	7469	2	oot
opt	5	75	4554	2	opt
ort	3	94	6523	2	ort
out	3	80	7215	2	out
pa	4	104	5648	2	p_a
pac	7	90	5408	2	pac
pact	8	66	4872	2	pact
pad	6	80	5732	2	pad
pah	8	88	5359	2	pah
pal	5	67	6167	2	pal
pam	7	78	5839	2	pam
pan	5	84	6644	2	pan
pant	6	60	6125	2	pant
pap	7	67	5840	2	pap
par	5	74	6702	2	par
part	6	59	6746	2	part
pas	5	87	7574	2	pas
past	6	59	5901	2	past
pate	6	53	5046	2	pate
path	9	91	3491	2	path
pats	6	64	6085	2	pats
paty	9	52	3456	2	paty
paw	8	76	5117	2	paw
pax	12	73	4685	2	pax
pay	8	84	6118	2	pay
pe	4	76	4903	2	p_e
pea	5	66	5724	2	pea
peat	6	59	6793	2	peat
pec	7	67	4441	2	pec
ped	6	67	5152	2	ped
pee	5	60	6651	2	pee
peg	6	58	4306	2	peg
peh	8	67	4096	2	peh
pehs	9	56	2576	2	pehs
pelt	6	76	5108	2	pelt
pen	5	65	5884	2	pen
pent	6	65	5907	2	pent
pep	7	64	4708	2	pep
per	5	63	5309	2	per
pert	6	67	5932	2	pert
pes	5	72	5978	2	pes
pest	6	55	5529	2	pest
pets	6	62	4833	2	pets
pew	8	64	4230	2	pew
pfft	12	3	1188	2	pfft
phew	12	84	1711	2	phew
phis	9	57	2490	2	phis
phiz	18	67	1884	2	phiz
phon	9	59	2538	2	phon
photo	10	44	1722	2	photo
phots	10	54	1849	2	phots
phpht	15	3	806	2	phpht
phuts	10	46	1350	2	phuts
pi	4	81	4536	2	p_i
pia	5	68	4803	2	pia
pic	7	60	4682	2	pic
pie	5	54	5740	2	pie
pig	6	57	4497	2	pig
pin	5	70	6672	2	pin
pint	6	69	6317	2	pint
pip	7	80	5104	2	pip
pis	5	63	6203	2	pis
pita	6	54	3643	2	pita
pith	9	54	3269	2	pith
pits	6	63	4874	2	pits
pity	9	60	3193	2	pity
piu	5	66	3954	2	piu
pix	12	64	3793	2	pix
plat	6	60	4887	2	plat
plot	6	61	4123	2	plot
ply	8	63	2355	2	ply
pod	6	63	5148	2	pod
poet	6	55	5290	2	poet
poh	8	67	4053	2	poh
poi	5	72	4466	2	poi
pol	5	64	4938	2	pol
pom	7	82	4991	2	pom
poo	5	77	5711	2	poo
pop	7	62	5225	2	pop
port	6	60	5963	2	port
post	6	79	5336	2	post
pots	6	64	5236	2	pots
pout	6	57	5255	2	pout
pow	8	71	4728	2	pow
pox	12	61	4069	2	pox
prat	6	59	5204	2	prat
pro	5	58	3726	2	pro
pry	8	57	2805	2	pry
psi	5	66	2162	2	psi
psst	6	61	1840	2	psst
pub	7	60	3769	2	pub
pud	6	58	3665	2	pud
pug	6	53	3718	2	pug
pul	5	61	3806	2	pul
pun	5	88	4651	2	pun
punt	6	57	4720	2	punt
pup	7	63	3988	2	pup
pur	5	68	4055	2	pur
pus	5	55	4784	2	pus
puts	6	56	4175	2	puts
putt	6	69	3784	2	putt
putz	15	83	2632	2	putz
pya	8	70	2375	2	pya
pye	8	64	3250	2	pye
pyx	15	78	1701	2	pyx
qat	12	52	5333	2	qat
rat	3	78	9274	2	rat
ret	3	59	8283	2	ret
rho	6	59	2483	2	rho
rot	3	72	8295	2	rot
rut	3	55	6052	2	rut
sat	3	62	8848	2	sat
set	3	66	8125	2	set
sh	5	68	2852	2	sh_
sha	6	98	3778	2	sha
shat	7	64	5659	2	shat
she	6	68	3769	2	she
shh	9	71	2107	2	shh
shit	7	67	4593	2	shit
shot	7	61	5024	2	shot
shut	7	61	3758	2	shut
shy	9	67	2819	2	shy
sit	3	58	7775	2	sit
sot	3	103	8429	2	sot
spat	6	65	4852	2	spat
spit	6	55	4508	2	spit
spot	6	55	4068	2	spot
tat	3	76	9029	2	tat
tet	3	92	7498	2	tet
that	7	56	3932	2	that
the	6	74	3605	2	the
tho	6	74	3396	2	tho
thy	9	70	2291	2	thy
tit	3	67	7104	2	tit
tot	3	88	8477	2	tot
tut	3	67	5809	2	tut
uh	5	74	2985	2	uh_
ut	2	86	4703	2	_ut
vat	6	78	6345	2	vat
vet	6	59	5852	2	vet
wat	6	73	7892	2	wat
wet	6	59	6662	2	wet
wha	9	64	2207	2	wha
what	10	54	3407	2	what
whet	10	51	3378	2	whet
whit	10	48	3417	2	whit
who	9	55	2677	2	who
why	12	69	2001	2	why
wit	6	65	6377	2	wit
wot	6	104	6748	2	wot
yet	6	69	6069	2	yet
zit	12	60	4999	2	zit

Search took 1 second 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	14084	0.063	2836365.1
2	DLD Change Limit	14084	247	0.373	37758.7
3	Display Results	247	247	0.046	5369.6
	(SQL Overall)	178691	247	0.482	370728.2