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

Here are the results of your fuzzy-string dictionary search for “oompah” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

128 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
oompah	13	3	425	(None)
oompahs	14	3	426	1	oompahs
oomph	12	3	697	1	oomp_h
compas	12	58	1706	2	compas
goombah	15	4	311	2	goombah
oomiac	10	3	706	2	oomiac
oomiak	12	3	535	2	oomiak
oompahed	16	4	290	2	oompahed
oomphs	13	4	472	2	oomphs
opah	9	62	1840	2	_o_pah
almah	10	69	1725	3	alm_ah
amah	9	89	2749	3	_am_ah
bimah	12	70	1327	3	bim_ah
bombax	19	3	575	3	bombax
bumph	14	49	1198	3	bump_h
coma	8	71	3485	3	com_a_
comae	9	71	2842	3	com_ae
comal	9	51	2513	3	com_al
comas	9	58	3300	3	com_as
combat	12	3	1675	3	combat
cometh	13	48	1168	3	cometh
comma	11	45	1479	3	comma_
commas	12	48	1457	3	commas
comp	10	67	3125	3	comp__
compact	15	37	1221	3	compact
company	16	197	1114	3	company
compare	13	58	1499	3	compare
compart	13	40	1600	3	compart
compass	13	37	956	3	compass
comped	13	59	1987	3	comped
compel	12	44	1289	3	compel
comply	15	28	1038	3	comply
compo	11	53	1857	3	comp_o
compos	12	48	1880	3	compos
comps	11	55	2605	3	comp_s
compt	11	63	2822	3	comp_t
compts	12	52	1665	3	compts
copal	9	56	2178	3	co_pal
copay	12	65	1631	3	co_pay
coprah	13	37	1060	3	coprah
cowpat	13	3	1203	3	cowpat
domal	8	56	1920	3	dom_al
dopa	7	72	2090	3	do_pa_
dopas	8	50	1906	3	do_pas
dourah	10	47	981	3	dourah
footpad	13	4	390	3	footpad
footpath	16	6	384	3	footpath
goombahs	16	4	252	3	goombahs
goombay	15	4	355	3	goombay
hamzah	23	13	556	3	hamzah
hookah	16	48	824	3	hookah
hoorah	12	44	1111	3	hoorah
horah	11	79	2205	3	ho_rah
houdah	13	3	517	3	houdah
howdah	16	3	472	3	howdah
humph	15	57	1221	3	hump_h
huppah	16	4	418	3	huppah
koph	13	58	1654	3	ko_p_h
koppa	13	39	729	3	koppa_
koppas	14	40	760	3	koppas
lampad	11	45	1003	3	lampad
lampas	10	66	1595	3	lampas
limpa	9	70	1446	3	limpa_
limpas	10	55	1308	3	limpas
loofah	12	37	581	3	loofah
lotah	8	53	1585	3	lo_tah
lymph	15	4	704	3	lymp_h
mollah	11	31	945	3	mollah
momma	8	51	1105	3	momma_
mommas	9	41	1065	3	mommas
moolah	11	40	919	3	moolah
morph	12	17	1251	3	morp_h
noma	6	75	2946	3	nom_a_
nomad	8	60	1618	3	nom_ad
nomas	7	47	2641	3	nom_as
nonpar	8	16	899	3	nonpar
nopal	7	55	1710	3	no_pal
nymph	15	5	521	3	nymp_h
nympha	16	4	357	3	nympha
obeah	10	3	899	3	_obeah
odah	8	70	1893	3	_o_dah
ooh	6	76	3709	3	oo___h
oolith	9	38	1324	3	oolith
oomiack	15	4	422	3	oomiack
oomiacs	11	3	568	3	oomiacs
oomiaks	13	4	412	3	oomiaks
oompahing	17	7	317	3	oompah~~ing~~
oops	6	52	3267	3	oo_p_s
opahs	10	54	1198	3	_o_pahs
opal	6	69	2352	3	_o_pal
ouph	9	56	1837	3	_oup_h
pah	8	88	5359	3	___pah
pampa	11	49	1342	3	pampa_
pampas	12	49	1399	3	pampas
pomp	10	62	2546	3	pomp__
pompano	13	4	520	3	pompano
pompom	14	3	649	3	pompom
pompon	12	3	894	3	pompon
pomps	11	53	1619	3	pomp_s
pooftah	15	4	314	3	pooftah
poppa	8	40	989	3	poppa_
poppas	9	37	1071	3	poppas
qoph	18	59	1194	3	qo_p_h
roman	7	54	2482	3	rom_an
romp	8	59	2657	3	romp__
romped	11	45	1365	3	romped
romper	10	42	1368	3	romper
rompish	14	3	669	3	rompish
romps	9	46	1754	3	romp_s
sampan	10	25	1189	3	sampan
soma	6	56	3529	3	som_a_
soman	7	50	2490	3	som_an
somas	7	60	3037	3	som_as
soph	9	70	2420	3	so_p_h
tampan	10	25	1232	3	tampan
tempeh	13	35	746	3	tempeh
toman	7	57	2405	3	tom_an
tombac	12	25	888	3	tombac
tombak	14	23	775	3	tombak
tombal	10	23	1102	3	tombal
tomcat	10	10	1345	3	tomcat
topaz	16	3	1532	3	to_paz
toph	9	63	2687	3	to_p_h
torah	8	71	2527	3	to_rah
towpath	15	4	404	3	towpath
tympan	13	25	701	3	tympan
woman	10	58	1800	3	wom_an
wombat	13	3	986	3	wombat

Search took 6 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	112716	0.373	479064.3
2	DLD Change Limit	112716	128	5.470	20606.2
3	Display Results	128	128	0.033	3878.8
	(SQL Overall)	178691	128	5.876	30410.3