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

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

53 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
gamblers	13	36	973	(None)
amblers	11	52	1356	1	_amblers
gabblers	13	41	1008	1	gabblers
gambiers	13	33	707	1	gambiers
gambler	12	36	1268	1	gambler_
gambles	12	40	1620	1	gamble_s
garblers	11	38	1028	1	garblers
ramblers	12	40	1037	1	ramblers
ambeers	11	42	892	2	_ambeers
ambers	10	45	1958	2	_amb_ers
ambler	10	49	1645	2	_ambler_
ambles	10	51	2186	2	_amble_s
babblers	11	35	1035	2	babblers
bumblers	14	37	1073	2	bumblers
cablers	11	44	1671	2	ca_blers
cambers	13	40	1744	2	camb_ers
dabblers	13	37	936	2	dabblers
fablers	12	48	1261	2	fa_blers
fumblers	15	31	871	2	fumblers
gabbers	12	46	1283	2	ga_bbers
gabbler	12	40	1330	2	gabbler_
gabbles	12	44	1541	2	gabble_s
gables	9	42	2233	2	ga_ble_s
gambes	11	63	1831	2	gamb_e_s
gambier	12	47	1197	2	gambier_
gambirs	12	35	908	2	gamb_irs
gamble	11	54	1718	2	gamble__
gambled	13	41	1216	2	gamble_d
gambrels	13	3	421	2	gambrels
gamers	9	44	2083	2	gam__ers
gammers	12	32	1456	2	gam_mers
gaolers	8	35	1156	2	ga_olers
garbler	10	40	1256	2	garbler_
garbles	10	40	1692	2	garble_s
garbless	11	38	825	2	garbless
garglers	10	41	826	2	garglers
gobblers	13	30	834	2	gobblers
grabblers	14	34	551	2	grabblers
grumblers	14	24	502	2	grumblers
humblers	15	37	980	2	humblers
jumblers	19	35	832	2	jumblers
lambers	11	38	1711	2	lamb_ers
marblers	12	31	923	2	marblers
mumblers	14	32	876	2	mumblers
rabblers	12	38	1085	2	rabblers
rambler	11	33	1326	2	rambler_
rambles	11	31	1831	2	ramble_s
rumblers	12	36	1074	2	rumblers
samplers	12	29	940	2	samplers
tumblers	12	31	1062	2	tumblers
wabblers	15	39	899	2	wabblers
wambles	14	37	1402	2	wamble_s
warblers	13	31	910	2	warblers

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	121059	0.796	224486.2
2	DLD Change Limit	121059	53	4.936	24525.7
3	Display Results	53	53	0.016	3312.5
	(SQL Overall)	178691	53	5.748	31087.5