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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

78 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
uphroe	11	3	608	1	uphroe
euphroe	12	4	539	2	euphroe
prof	9	61	3466	2	_p_rof
upgrow	12	3	427	2	upgrow
uphroes	12	3	630	2	uphroes
upprop	9	4	409	2	upprop
upthrow	15	4	319	2	upthrow
apron	7	3	1883	3	ap_ron
behoof	14	5	868	3	behoof
ephod	11	3	912	3	eph_od
ephor	10	3	1001	3	eph_or
ephori	11	3	960	3	ephori
ephors	11	3	1140	3	ephors
euphroes	13	4	599	3	euphroes
hoof	10	60	3658	3	__hoof
nephron	12	4	665	3	nephron
operon	8	8	1177	3	operon
parol	7	48	2627	3	_parol
pharos	11	3	1206	3	_pharos
phlox	17	3	733	3	_phlox
phon	9	59	2538	3	_ph_on
phot	9	55	3436	3	_ph_ot
pirog	8	39	1367	3	_pirog
poof	9	55	4166	3	_p_oof
pro	5	58	3726	3	_p_ro_
proa	6	62	2996	3	_p_roa
prod	7	61	2950	3	_p_rod
profs	10	51	2089	3	_p_rofs
prog	7	57	2900	3	_p_rog
prom	8	76	3170	3	_p_rom
proof	10	52	2153	3	_proof
prop	8	59	3281	3	_p_rop
pros	6	57	4278	3	_p_ros
prow	9	70	3038	3	_p_row
pushrod	13	4	370	3	pushrod
pyro	9	60	1939	3	_pyro_
pyros	10	57	1829	3	_pyros
schrod	12	4	788	3	schrod
shroff	15	3	850	3	_shroff
spoof	10	50	1901	3	sp_oof
thro	7	77	2642	3	_thro_
throb	10	98	1685	3	_throb
throe	8	93	2142	3	_throe
throw	11	87	1973	3	_throw
unhood	10	3	923	3	unhood
unhook	13	4	752	3	unhook
unroof	9	4	1019	3	unroof
untrod	7	6	985	3	untrod
upbore	10	24	788	3	upbore
upbow	12	4	561	3	up_bow
updo	7	67	1288	3	up_do_
updos	8	38	951	3	up_dos
updraft	13	4	603	3	updraft
updry	11	3	548	3	updr_y
upflow	14	3	352	3	upflow
upfront	12	4	697	3	upfront
upgrew	12	3	365	3	upgrew
upgrown	13	4	385	3	upgrown
upgrows	13	3	432	3	upgrows
upheap	13	10	521	3	upheap
upheld	12	11	556	3	upheld
uphill	11	10	617	3	uphill
uphold	12	12	690	3	uphold
uphove	14	3	613	3	uphove
upo	5	89	2586	3	up__o_
upon	6	58	1758	3	up__on
upprops	10	4	422	3	upprops
uproar	8	10	693	3	up_roar
uproot	8	3	1412	3	uproot
uprose	8	23	1148	3	up_rose
upshoot	12	5	669	3	upshoot
upshot	11	3	845	3	upshot
upthrew	15	4	266	3	upthrew
upthrown	16	4	259	3	upthrown
upthrows	16	4	330	3	upthrows
uptore	8	27	945	3	uptore
uptorn	8	26	809	3	uptorn
whoof	14	46	1269	3	_whoof

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.376	475242.0
2	DLD Change Limit	112716	78	5.530	20382.6
3	Display Results	78	78	0.033	2363.6
	(SQL Overall)	178691	78	5.939	30087.7