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

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

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.

56 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
phoney	14	36	1298	(None)
honey	11	56	2991	1	_honey
phone	10	56	2193	1	phone_
phoned	12	40	1455	1	phoned
phones	11	41	2121	1	phones
phoneys	15	43	714	1	phoneys
phony	13	67	1544	1	phon_y
phooey	14	37	923	1	phooey
boney	10	52	2731	2	_boney
chokey	18	48	1171	2	chokey
coney	10	59	3288	2	_coney
gooney	10	66	1231	2	gooney
hokey	15	54	2218	2	_hokey
holey	11	56	2690	2	_holey
homey	13	59	2484	2	_homey
hone	7	75	4932	2	_hone_
honed	9	53	3226	2	_honed
honer	8	53	3209	2	_honer
hones	8	81	4449	2	_hones
honeys	12	40	1608	2	_honeys
honkey	16	51	1382	2	_honkey
honky	15	62	1852	2	_honky
hooey	11	49	2660	2	_hooey
hosey	11	61	2702	2	_hosey
looney	9	47	1241	2	looney
money	10	48	2684	2	_money
peones	8	38	2104	2	peones
peony	10	57	1756	2	peon_y
phon	9	59	2538	2	phon__
phonal	11	3	1038	2	phonal
phoneme	14	4	620	2	phoneme
phoneyed	17	4	384	2	phoneyed
phonic	13	33	1521	2	phonic
phonied	13	37	1056	2	phonied
phonier	12	27	1063	2	phonier
phonies	12	37	1751	2	phonies
phonily	15	3	710	2	phonily
phono	10	49	1702	2	phon_o
phonon	11	40	1203	2	phonon
phonos	11	41	1479	2	phonos
phons	10	52	2114	2	phon_s
phoresy	15	3	465	2	phoresy
piney	10	57	2750	2	p_iney
pogey	11	60	1789	2	p_ogey
pokey	14	53	1897	2	p_okey
pone	6	57	4753	2	p_one_
pones	7	45	4704	2	p_ones
pony	9	64	3405	2	p_on_y
prone	7	53	3262	2	prone_
pronely	12	3	1025	2	pronely
ptooey	11	34	641	2	ptooey
shone	8	37	2598	2	shone_
spooney	12	41	824	2	spooney
stoney	9	62	1735	2	stoney
toney	8	60	2741	2	_toney
whiney	15	50	1264	2	whiney

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	56	2.483	33246.5
3	Display Results	56	56	0.016	3500.0
	(SQL Overall)	178691	56	2.842	62875.1