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

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

74 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
phoebus	14	4	382	(None)
phoebes	14	3	581	1	phoebes
ephebus	14	4	328	2	eph_ebus
phoebe	13	3	500	2	phoeb_e
phoebuses	16	4	321	2	phoebuses
rhombus	14	24	389	2	rhombus
amoebas	11	3	596	3	amoebas
choregus	14	8	421	3	choregus
chorus	11	50	1477	3	cho_rus
dhobis	12	3	611	3	dho_bis
ephebes	14	3	615	3	eph_ebes
ephebos	14	4	411	3	eph_ebos
foetus	9	5	852	3	_foetus
habus	10	63	1714	3	_h_abus
hebes	10	55	2167	3	_h_ebes
hobos	10	63	2135	3	_ho_bos
hobs	9	70	3898	3	_ho_b_s
hocus	10	47	1520	3	_ho_cus
hoers	8	57	2492	3	_hoe_rs
hoes	7	57	5573	3	_hoe__s
kombus	14	3	552	3	_kombus
pareus	8	54	2074	3	pare_us
phallus	12	3	606	3	phallus
phlegms	15	4	237	3	phlegms
phloems	14	3	352	3	phloe_ms
phobia	13	27	860	3	pho_bia
phobias	14	22	818	3	phobias
phobic	15	30	1007	3	pho_bic
phobics	16	28	670	3	phobics
phoenix	19	4	436	3	phoenix
phonemes	15	4	619	3	phonemes
phones	11	41	2121	3	pho_nes
phoneys	15	43	714	3	phoneys
phonics	14	31	1072	3	phonics
phonies	12	37	1751	3	phonies
phonons	12	33	1025	3	phonons
phonos	11	41	1479	3	pho_nos
phons	10	52	2114	3	pho__ns
photics	14	28	1048	3	photics
photogs	13	35	821	3	photogs
photons	12	38	1443	3	photons
photos	11	33	1664	3	pho_tos
phots	10	54	1850	3	pho__ts
phreaks	16	3	454	3	phreaks
piceous	11	3	1069	3	piceous
pileous	9	5	1052	3	pileous
pileus	8	45	1494	3	pile_us
pious	7	46	2127	3	pio__us
piteous	9	3	1068	3	piteous
plebes	10	43	1362	3	p_lebes
plebs	9	58	1458	3	p_leb_s
plexus	15	37	728	3	p_lexus
poems	9	57	1555	3	p_oe_ms
poets	7	60	2444	3	p_oe_ts
poilus	8	22	1057	3	p_oilus
porous	8	44	1948	3	p_orous
poyous	11	29	1162	3	p_oyous
prebuy	13	5	742	3	p_rebuy
prebuys	14	4	439	3	p_rebuys
probers	11	35	1458	3	probers
probes	10	41	1945	3	pro_bes
proems	10	47	1116	3	proe_ms
proteus	9	25	1159	3	proteus
rebus	7	57	2111	3	__rebus
rhesus	9	3	620	3	rh_esus
rhombs	13	33	649	3	rhomb_s
shoebox	19	4	362	3	shoebox
shoers	9	45	1833	3	shoe_rs
shoes	8	54	2966	3	shoe__s
shoyus	12	6	600	3	sho_yus
thebes	11	59	1449	3	th_ebes
thous	8	60	1726	3	tho__us
thrombus	15	4	364	3	thrombus
zebus	16	46	1005	3	__zebus

Search took 8 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	134027	0.423	422437.4
2	DLD Change Limit	134027	74	6.606	20288.7
3	Display Results	74	74	0.033	2242.4
	(SQL Overall)	178691	74	7.062	25303.2