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

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

108 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
opah	9	62	1840	(None)
odah	8	70	1893	1	odah
opahs	10	54	1198	1	opahs
opal	6	69	2352	1	opal
pah	8	88	5359	1	_pah
aah	6	162	5296	2	_aah
ah	5	138	6879	2	__ah
amah	9	89	2749	2	amah
ayah	10	80	2299	2	ayah
bah	8	77	5535	2	_bah
blah	9	86	2506	2	blah
caph	11	66	2329	2	caph
copal	9	56	2178	2	copal
copay	12	65	1631	2	copay
coprah	13	37	1060	2	coprah
dah	7	81	4898	2	_dah
dopa	7	72	2090	2	dopa_
dopas	8	50	1906	2	dopas
epha	9	3	1005	2	epha
ephah	13	3	706	2	ephah
hah	9	106	5522	2	_hah
horah	11	79	2205	2	horah
kaph	13	58	1575	2	kaph
koph	13	58	1654	2	kop_h
lotah	8	53	1585	2	lotah
nah	6	98	4700	2	_nah
nopal	7	55	1710	2	nopal
oaf	6	59	5288	2	o_af
oak	7	62	3865	2	o_ak
oar	3	70	5795	2	o_ar
oat	3	98	8826	2	o_at
oath	7	61	3215	2	oath
oba	5	75	3155	2	oba_
obas	6	57	3093	2	obas
obeah	10	3	899	2	obeah
oca	5	67	3173	2	oca_
ocas	6	67	2963	2	ocas
oda	4	81	3304	2	oda_
odahs	9	56	1008	2	odahs
odas	5	72	3026	2	odas
ofay	10	64	1610	2	ofay
ogam	7	51	2003	2	ogam
oh	5	74	4700	2	o__h
oka	7	69	2680	2	oka_
okas	8	52	2539	2	okas
okay	11	59	1766	2	okay
okeh	11	46	1532	2	okeh
ooh	6	76	3709	2	o_oh
oompah	13	3	425	2	oompah
op	4	58	5016	2	op__
opals	7	57	1835	2	opals
ope	5	68	4524	2	op_e
oped	7	62	3015	2	oped
open	6	64	2700	2	open
opes	6	59	4261	2	opes
ops	5	66	4125	2	op_s
opt	5	75	4554	2	op_t
opts	6	81	2474	2	opts
opus	6	64	2059	2	opus
ora	3	72	5083	2	ora_
orach	10	52	1923	2	orach
orad	5	60	3169	2	orad
oral	4	76	3812	2	oral
osar	4	68	2095	2	osar
ouch	9	57	2463	2	ouch
ouph	9	56	1837	2	ouph
ova	6	68	2379	2	ova_
oval	7	71	1952	2	oval
pa	4	104	5648	2	_pa_
pac	7	90	5408	2	_pac
pad	6	80	5732	2	_pad
pal	5	67	6167	2	_pal
pam	7	78	5839	2	_pam
pan	5	84	6645	2	_pan
pap	7	67	5840	2	_pap
par	5	74	6702	2	_par
pas	5	87	7574	2	_pas
pash	9	56	3813	2	_pash
pat	5	80	8946	2	_pat
path	9	91	3491	2	_path
paw	8	76	5117	2	_paw
pax	12	73	4685	2	_pax
pay	8	84	6118	2	_pay
peh	8	67	4096	2	_peh
poach	12	49	1786	2	poach
poh	8	67	4053	2	_poh
pooh	9	60	2738	2	pooh
posh	9	54	2732	2	posh
qoph	18	59	1194	2	qop_h
rah	6	80	5240	2	_rah
shah	10	56	2778	2	shah
soph	9	70	2420	2	sop_h
spa	5	57	3081	2	spa_
spae	6	50	3432	2	spae
spahi	10	3	1114	2	spahi
spam	8	59	3004	2	spam
span	6	52	3466	2	span
spar	6	54	3330	2	spar
spas	6	70	3672	2	spas
spat	6	65	4852	2	spat
spay	9	66	3166	2	spay
spaz	15	56	2616	2	spaz
topaz	16	3	1532	2	topaz
toph	9	63	2687	2	top_h
torah	8	71	2527	2	torah
upas	6	83	2238	2	upas
yah	9	90	4635	2	_yah
yeah	10	67	2541	2	yeah

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.296	603685.8
2	DLD Change Limit	29872	108	0.936	31914.5
3	Display Results	108	108	0.016	6750.0
	(SQL Overall)	178691	108	1.248	143181.9