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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

198 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
compiled	15	3	781	(None)
compile	13	3	1244	1	compile_
compiler	14	3	837	1	compiler
compiles	14	3	1198	1	compiles
complied	15	3	967	1	complied
camailed	13	3	655	2	camailed
coiled	9	51	2394	2	co__iled
combined	15	26	918	2	combined
commixed	22	6	474	2	commixed
compared	15	38	1182	2	compared
comped	13	59	1987	2	comp__ed
compelled	16	4	613	2	compelled
compered	15	34	1492	2	compered
competed	15	41	1359	2	competed
compilers	15	3	705	2	compilers
complex	20	3	724	2	comp_lex
complier	14	3	1025	2	complier
complies	14	3	1452	2	complies
composed	15	46	1206	2	composed
comprised	16	4	805	2	comprised
comprized	25	6	722	2	comprized
compted	14	38	1352	2	comp_ted
computed	15	41	1095	2	computed
copied	11	46	1856	2	co_pi_ed
coppiced	17	3	482	2	coppiced
coupled	12	43	1267	2	coup_led
recompiled	17	4	417	2	recompiled
boiled	9	50	2095	3	bo__iled
camped	13	47	2023	3	camp__ed
campier	13	33	1327	3	campi_er
campily	16	3	827	3	campil_y
campused	15	3	525	3	campused
caviled	13	4	872	3	c_aviled
ceiled	9	41	1495	3	c__eiled
chomped	17	32	977	3	chomp__ed
clomped	14	39	897	3	clomp__ed
coaled	9	50	2271	3	co__aled
coapted	12	39	1150	3	coap_ted
cobbled	14	34	1163	3	co_bbled
cockled	16	37	1082	3	co_ckled
coddled	12	34	1057	3	co_ddled
coedited	12	3	783	3	coedited
coempted	15	3	533	3	coemp_ted
coffined	17	3	599	3	coffined
coffled	16	29	736	3	co_ffled
cognised	12	5	631	3	cognised
cognized	21	3	629	3	cognized
coifed	12	41	1306	3	co__ifed
coiler	8	44	2159	3	co__iler
coined	9	45	2360	3	co__ined
cojoined	18	5	629	3	cojoined
coled	8	55	4076	3	co___led
collided	12	30	980	3	collided
collied	10	33	1667	3	colli_ed
combated	15	3	982	3	combated
combed	13	55	1654	3	com__bed
combine	13	30	1472	3	combine_
combineds	16	25	528	3	combineds
combiner	14	25	972	3	combiner
combines	14	28	1462	3	combines
comelier	12	3	1065	3	comelier
comfier	14	3	916	3	comfi_er
comingled	15	4	320	3	comingled
commie	12	42	1552	3	commi_e_
commies	13	37	1845	3	commi_es
commingled	18	4	297	3	commingled
committed	16	4	572	3	committed
commixes	21	7	735	3	commixes
commoved	18	4	476	3	commoved
communed	15	33	821	3	communed
commuted	15	28	898	3	commuted
compacted	18	29	736	3	compacted
companied	16	4	802	3	companied
compare	13	58	1499	3	compare_
comparer	14	36	1136	3	comparer
compares	14	38	1643	3	compares
comparted	16	33	842	3	comparted
compassed	16	4	554	3	compassed
compeer	13	38	1155	3	comp_eer
compeered	16	4	630	3	compeered
compel	12	44	1289	3	comp__el
compeller	15	4	629	3	compeller
compels	13	32	1088	3	compel_s
compend	14	40	1030	3	comp_end
compere	13	46	1662	3	compere_
comperes	14	32	1797	3	comperes
compete	13	47	1655	3	compete_
competes	14	41	1724	3	competes
compiling	16	3	776	3	compiling
comping	14	35	1859	3	compi_ng
complained	17	17	579	3	complained
compleat	14	7	1015	3	comp_leat
complect	16	5	901	3	comp_lect
complete	14	34	1205	3	comp_lete
completed	16	28	1027	3	completed
complexed	23	29	598	3	complexed
complice	16	3	933	3	complice
complices	17	3	925	3	complices
compliers	15	3	829	3	compliers
complin	13	3	1207	3	comp_lin
compline	14	3	1355	3	compline
complines	15	3	1283	3	complines
complins	14	3	1311	3	complins
complot	13	3	1068	3	comp_lot
comply	15	28	1038	3	comp_l_y
compone	13	65	1719	3	compone_
comported	16	31	953	3	comported
compose	13	57	1666	3	compose_
composer	14	50	1295	3	composer
composes	14	50	1711	3	composes
composited	17	5	600	3	composited
composted	16	37	881	3	composted
compote	13	56	1646	3	compote_
compotes	14	47	1651	3	compotes
compound	15	5	599	3	compound
comprise	14	3	1081	3	comprise_
comprises	15	5	1094	3	comprises
comprize	23	6	873	3	comprize_
comprizes	24	6	894	3	comprizes
compute	13	45	1366	3	compute_
computer	14	45	1151	3	computer
computes	14	39	1455	3	computes
condoled	12	31	1072	3	condoled
confided	15	3	745	3	confided
confined	14	3	1040	3	confined
connived	14	3	643	3	connived
consoled	11	29	1145	3	consoled
conspired	14	4	566	3	conspired
cooled	9	52	2459	3	co__oled
cooped	11	48	2160	3	coop__ed
coopered	13	33	1093	3	coopered
coopted	12	37	1076	3	coop_ted
coped	10	50	3684	3	co_p__ed
copier	10	37	2289	3	co_pi_er
copies	10	41	3030	3	co_pi_es
copilot	11	8	1126	3	co_pilot
copped	13	52	2125	3	co_p_ped
coppered	15	34	1054	3	coppered
coppice	15	3	748	3	coppice_
coppices	16	3	824	3	coppices
corbeled	13	3	837	3	corbeled
corniced	13	6	859	3	corniced
cosied	9	48	1988	3	co_si_ed
couped	11	50	1931	3	coup__ed
couple	10	44	1596	3	coup_le_
coupler	11	47	1301	3	coup_ler
couples	11	53	1705	3	coup_les
couplet	11	47	1794	3	coup_let
cowhided	18	4	375	3	cowhided
cowled	12	52	1839	3	co__wled
cowpie	13	35	1151	3	cowpi_e_
cowpies	14	33	1428	3	cowpi_es
cozied	18	41	1215	3	co_zi_ed
crimpled	15	36	693	3	crimp_led
crippled	15	33	679	3	crippled
crumpled	15	29	687	3	crump_led
cupeled	12	5	779	3	c_upeled
dimpled	13	28	1030	3	dimp_led
doiled	8	48	1729	3	do__iled
domiciled	15	4	360	3	domiciled
emailed	10	35	921	3	_emailed
empaled	12	28	895	3	_empaled
foiled	10	46	1840	3	fo__iled
hoppled	15	33	808	3	ho_ppled
impaled	12	28	851	3	_impaled
impled	11	38	1251	3	_imp_led
implied	12	3	862	3	_implied
mailed	9	53	2675	3	__mailed
moiled	9	43	1886	3	__moiled
oiled	6	44	2947	3	_o__iled
oompahed	16	4	290	3	oompahed
opined	9	51	1385	3	_o_pined
piled	8	52	3299	3	___piled
pimpled	14	28	919	3	pimp_led
pommeled	15	4	310	3	pommeled
poppied	11	38	898	3	poppi_ed
poppled	11	33	924	3	po_ppled
recompile	15	4	522	3	recompile_
recompiles	16	4	506	3	recompiles
remailed	11	24	1140	3	remailed
rimpled	12	33	1142	3	rimp_led
roiled	7	43	2005	3	ro__iled
romped	11	45	1365	3	romp__ed
rumpled	12	38	1001	3	rump_led
sampled	12	34	1079	3	samp_led
smiled	9	37	1643	3	_sm_iled
soiled	7	38	2247	3	so__iled
sopited	10	42	1106	3	so_pited
spiled	9	46	2199	3	__spiled
templed	12	27	856	3	temp_led
toiled	7	44	2032	3	to__iled
toppled	12	34	884	3	to_ppled
umpired	12	3	578	3	_umpired
unmailed	11	22	976	3	unmailed
unpiled	10	23	1274	3	_unpiled
uppiled	12	21	659	3	_uppiled
vomited	13	3	725	3	vom_ited
wimpled	15	33	882	3	wimp_led

Search took 9 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	146162	0.406	440125.6
2	DLD Change Limit	146162	198	7.530	19410.6
3	Display Results	198	198	0.080	2475.0
	(SQL Overall)	178691	198	8.016	22291.8