Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

219 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
manacles123952(None) 
manacle11310281manacle_
manacled1336451manacled
barnacles1355332barnacles
cenacles1238022cenacles
ganaches1437432ganaches
macles107023222m__acles
manages103418962mana_ges
manatees10310422manatees
manches143818622man_ches
mangles104021462man_gles
manholes13311182manholes
manilles102312602manilles
maniples12269422maniples
mantles94820702man_tles
menaces112715522menac_es
miracles1238332miracles
monocles12310672monocles
panaches15310292panaches
panicles121010122panicles
sanicles10149942sanicles
anableps1243123_anableps
anaclises1147863_anaclises
anankes1138763_anankes
aneles64626293_an_eles
angles74426703_an_gles
ankles104818383_an_kles
anlaces92313733_anlac_es
anoles64827433_an_oles
apaches143411843_apaches
arables91814983_arables
bangles103617413ban_gles
barnacle1245943barnacle_
barnacled1444003barnacled
binnacles13244583binnacles
binocles1236413binocles
calicles123811433calicles
calycles15295693calycles
canailles1148283canailles
canaled103615563cana_led
canalled1139583canalled
canaller1038953canaller
canallers1137213canallers
canals84421673cana_l_s
canapes111213083cana_pes
canaries10318943canaries
cancels114113313can_cels
candles104422343can_dles
canticles1339183canticles
cantles94721413can_tles
caracoles13310093caracoles
cenacle1139123cenacle_
coracles121811163coracles
dances95120653dan_c_es
dandles94218533dan_dles
dangles93618423dan_gles
debacles1335723debacles
earaches13411313earaches
eatables10169793eatables
emanates10311333emana_tes
enables92813123_enables
fancies124018783fan_cies
fenagles12186083fenagles
finagles12237553finagles
finales104016013fina_les
funicles13246833funicles
ganache1346223ganache_
hances115621283han_c_es
handles114020653han_dles
hantles104117513han_tles
jacales16310323jaca_les
jangles154015683jan_gles
kanteles1238123kanteles
lances84824103lan_c_es
lunacies1038013lunacies
macacos1338083macac_os
macaques2143953macaques
maces97139963m__ac_es
maches134827233m__aches
mackles154415753ma_ckles
macle96127003m__acle_
macled116718113m__acled
macules114015133ma_cules
madames12310063mada_mes
maenades1137473maena_des
magnates11511613magna_tes
mailes84329113m__ailes
makable15510203makable_
malaccas1445163malaccas
maladies11311933maladies
malaises10312333malaises
malates93522613mala_tes
males75049793m__a_les
malices114316623malic_es
manacling1446283manacling
manage93818903mana_ge_
managed113212603mana_ged
manager103413583mana_ger
managers112911003managers
manakins14209763manakins
mananas93414733mana_nas
manas76240433mana___s
manatee9317663mana_tee
manats84623463mana__ts
manche133515103man_che_
manchet143317783man_chet
manchets15269573man_chets
manciples1564793manciples
mandalas1139443mandalas
mandates11314093mandates
mandibles1445543mandibles
mandolas1139133mandolas
mandrels1137313mandrels
maneges103612143man_eges
maneless102812343man_eless
manes76648963man___es
mangabies1446373mangabies
mangels103614493mangel_s
manges94628953man__ges
mangle93921333man_gle_
mangled113615263man_gled
mangler103215643man_gler
manglers113311903man_glers
mangoes104316133man_goes
mangolds1235193mangolds
manhandles1643393manhandles
manhole12311343manhole_
maniacs114313063maniac__s
manics103919933manic__s
manicures1346263manicures
manilas93915873man_ilas
manillas102611163manillas
manille92613273manille_
maniple11249653maniple_
manless93012933man__less
mannites10312613mannites
mannoses1039083mannoses
manropes1237913manropes
manses84225513man__ses
mantelet10613823mantelet
mantelets1176813mantelets
mantels94515043mantel_s
mantes84430783man__tes
mantises10317923mantises
mantle84420923man_tle_
mantled104113393man_tled
mantlet93620993man_tlet
mantlets104611203man_tlets
manuals9311223manual_s
manures9313353man_ures
manyplies1643893manyplies
maples104819423m__aples
maracas11313773marac_as
marbles114516653ma_rbles
marcels113212373ma_rcels
marches143921173ma_rches
masalas9312073masa_las
massacres1344693massacres
matches143219783ma_tches
mayapples1841693mayapples
maypoles1545993maypoles
measles92412753m_easles
menace103216943menac_e_
menaced122710093menac_ed
menacer112610883menac_er
menacers12279313menacers
menages103615393mena_ges
menarches1646683menarches
mensches1536303mensches
minable112315073minable_
minces104420803min_c_es
mingles103719003min_gles
miracle1138843miracle_
monacids13137513monacids
monades103713823mona_des
monocle1139663monocle_
monocled1337113monocled
morales93619403mora_les
movables15175573movables
munches144215793mun_ches
muscles11310563m_uscles
naches114622413__naches
nacres85614453__nacres
nances83618643nan_c_es
nancies93516843nan_cies
nuncles939843nun_cles
oracles93212423_oracles
palaces114216463palac_es
panacea1137793panac_ea
panaceas1236773panaceas
panache1458433panache_
pancakes1637073pancakes
panicle11129983panicle_
panicled13106783panicled
panoches1548123panoches
pantiles103617163pantiles
papacies1439483papacies
parables121613573parables
payables15166493payables
pentacles1338773pentacles
pinnacles13276043pinnacles
pinocles1248693pinocles
radicles11249703radicles
rances84625443ran_c_es
ranches123620113ran_ches
rankles113114553ran_kles
ratables10159723ratables
sanicle91210263sanicle_
tamales93216153tama_les
tangles83920053tan_gles
taxables1734383taxables
tenaces92814513tenac_es
tentacles1146713tentacles
treacles1039703treacles
tunicles10217133tunicles
uncles8317163_un_cles
vernacles1445073vernacles
wangles113416933wan_gles
wavicles1633783wavicles

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.423422437.4
2DLD Change Limit1461622197.36019859.0
3Display Results2192190.0762881.6
 (SQL Overall)1786912197.85922737.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.