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

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

52 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
guild	7	53	1275	(None)
build	8	44	1335	1	build
gild	6	55	2652	1	g_ild
guid	6	60	2283	1	gui_d
guilds	8	38	835	1	guilds
guile	6	45	2113	1	guile
guiled	8	43	1538	1	guiled
guilt	6	51	2557	1	guilt
auld	5	41	2536	2	au_ld
builds	9	37	849	2	builds
built	7	43	2592	2	built
child	11	45	1622	2	child
gaily	9	50	2097	2	gaily
geld	6	58	2843	2	g_eld
gelid	7	49	1698	2	gelid
gid	5	70	4728	2	g_i_d
gied	6	46	3199	2	g_ied
gilds	7	54	1753	2	g_ilds
gill	5	63	3619	2	g_ill
gilt	5	63	4855	2	g_ilt
gird	6	54	2500	2	g_ird
gluily	10	30	829	2	gluily
gold	6	54	3016	2	g_old
grid	6	58	2962	2	gri_d
grill	6	46	1789	2	grill
grind	7	59	1756	2	grind
guard	7	44	1554	2	guard
guide	7	50	1989	2	guide
guided	9	40	1411	2	guided
guids	7	55	1616	2	guids
guilder	9	4	591	2	guilder
guiles	7	39	1928	2	guiles
guilts	7	41	1123	2	guilts
guilty	10	41	823	2	guilty
guiro	6	37	1209	2	guiro
guise	6	47	1771	2	guise
guised	8	46	1217	2	guised
gul	4	58	3279	2	gu_l_
gulf	8	49	2942	2	gu_lf
gull	5	48	2845	2	gu_ll
gulled	8	45	2137	2	gulled
gulls	6	52	2298	2	gulls
gully	9	40	2068	2	gully
gulp	7	55	2136	2	gu_lp
guls	5	59	3085	2	gu_ls
guyed	10	4	989	2	guyed
mild	7	53	3086	2	_mild
quid	14	49	2236	2	qui_d
quill	14	84	1377	2	quill
quilt	14	41	2510	2	quilt
sild	5	50	3059	2	_sild
wild	8	51	2652	2	_wild

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	53800	0.330	541487.9
2	DLD Change Limit	53800	52	1.950	27589.7
3	Display Results	52	52	0.016	3250.0
	(SQL Overall)	178691	52	2.296	77827.1