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

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

76 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
tombola	11	4	610	(None)
tombolas	12	4	602	1	tombolas
tombolo	11	4	610	1	tombolo
tambala	11	3	802	2	tambala
tombal	10	23	1102	2	tombal_
tombolos	12	4	511	2	tombolos
tomboy	13	5	821	2	tombo_y
tomboys	14	3	571	2	tomboys
boffola	15	4	346	3	boffola
bola	6	60	3556	3	___bola
bombload	15	4	314	3	bombload
cocobola	14	4	356	3	cocobola
combo	11	45	1943	3	combo__
combos	12	53	1661	3	combo_s
dobla	8	49	1364	3	do_b_la
dongola	9	4	547	3	dongola
emboli	10	3	748	3	_emboli
emboly	13	3	672	3	_emboly
foveola	13	11	501	3	foveola
gambol	11	3	822	3	gambol_
gambols	12	3	859	3	gambols
gombo	10	58	1404	3	gombo__
gombos	11	43	1109	3	gombo_s
gondola	9	4	666	3	gondola
hemiola	12	10	700	3	hemiola
kobold	13	6	596	3	ko_bold
mola	6	60	3563	3	__m_ola
moola	7	51	1703	3	__moola
moviola	12	4	482	3	moviola
noncola	9	4	830	3	noncola
obol	6	52	2061	3	_o_bol_
obole	7	59	1714	3	_o_bole
oboli	7	37	1287	3	_o_boli
obols	7	37	1586	3	_o_bols
rambla	10	35	1093	3	ramb_la
roseola	7	7	705	3	roseola
symbol	13	3	608	3	symbol_
symbols	14	3	552	3	symbols
tabla	7	33	1836	3	t_ab_la
tambalas	12	3	703	3	tambalas
tambour	11	3	635	3	tambour
tamboura	12	5	389	3	tamboura
tambura	11	32	646	3	tambura
tampala	11	3	661	3	tampala
temblor	11	4	409	3	temblor
timbal	10	25	1075	3	timbal_
timbale	11	24	880	3	timbale
timbals	11	23	953	3	timbals
timbral	11	23	719	3	timbral
toehold	11	4	657	3	toehold
tola	4	52	3633	3	t___ola
toluol	6	3	690	3	toluol_
toluole	7	3	611	3	toluole
toluols	7	3	582	3	toluols
tomb	8	90	2965	3	tomb___
tombac	12	25	888	3	tomb_ac
tomback	17	22	774	3	tomback
tombacs	13	24	844	3	tombacs
tombak	14	23	775	3	tomb_ak
tombaks	15	24	686	3	tombaks
tombed	11	38	1213	3	tomb_ed
tombing	12	33	1053	3	tombing
tombs	9	78	1873	3	tomb__s
tomcod	11	3	578	3	tomco_d
tomcods	12	3	487	3	tomcods
tomenta	9	31	983	3	tomenta
tomfool	12	5	424	3	tomfool
tomfools	13	4	354	3	tomfools
tool	4	67	3568	3	to__ol_
tools	5	53	2524	3	to__ols
torula	6	6	1039	3	to_rula
towboat	12	5	830	3	towboat
trombone	12	4	537	3	trombone
tumble	10	32	1564	3	tumb_le
tymbal	13	23	682	3	tymbal_
tymbals	14	26	572	3	tymbals

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.500	357382.0
2	DLD Change Limit	134027	76	7.250	18486.5
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	7.780	22968.0