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 “macaco” 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.

183 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
macaco124785(None) 
macacos1338081macacos
cacao95420002caca_o
macaw12311762maca_w
macaws1337022macaws
macho126120152mac_ho
macro94718172mac_ro
maraca10314152maraca
marcato1139742marcato
abaca95118043_abaca
abaci94718843_abaci
aback134816173_aback
acacia10311353_acacia
acajou1595233_acajou
acari75020283_acari
achoo10315083_achoo
acock132110213_acock
alack114820063_alack
alamo7418143_alamo
apace94718383_apace
arco68331543_a_rco
bacalao1146613bacalao
bacca111012183bac_ca
baccae12119703baccae
banco94019393ba_nco
bayamo1335603bayamo
caca85528083__caca
cacaos104616183cacaos
cacas95627983caca_s
calico103414433calico
calo64936443__calo
camo85731753__camo
capo85829213__capo
carack142113173carack
caracol11310423caracol
catalo8314853catalo
coco87330603__coco
facade1238803facade
galago838903galago
gazabo1834833gazabo
guaco85012163_guaco
guanaco1064583guanaco
jacal14313703jaca_l
jacals1539873jacals
jacana1537933jacana
kakapo1143853kakapo
lavabo1135273lavabo
maar66025063ma_a_r
maars74621633ma_ars
mac78053933m__ac_
macaber1336163macaber
macabre1335223macabre
macadam1446853macadam
macaque2044053macaque
macaroni1246523macaroni
macaroon1246343macaroon
maccaboy1942513maccaboy
mace87345793m__ace
maced108528693mac_ed
macer912126943mac_er
macers105321273macers
maces97139963mac_es
mach116134483m__ach
mache125925303mac_he
maches134827233maches
machos135217493machos
machs125722563mac_hs
machzor2344263machzor
macing114221553macing
mack125733653m__ack
mackle143716433mackle
macks135127603mac_ks
macle96127003mac_le
macled116718113macled
macles107023223macles
macon94519953mac_on
macons104017243macons
macrame1338713macrame
macron103615673macron
macros104017013macros
macs86742513m__acs
macula103013673macula
macule104115273macule
madam10316223mada_m
madame1139853madame
madams11310943madams
madcap1336333madca_p
madcaps1435243madcaps
maduro936983maduro
mafic125615463mafic_
magalog1144913magalog
magic105818653magic_
magics115311613magics
makar115614973maka_r
makars124612633makars
mako105622363m__ako
malacca1344953malacca
malady1237863malady
malar76424443mala_r
malars85020683malars
malate84624553malate
malic94525663malic_
malice104818483malice
mama86231593mama__
mamas95930773mama_s
mambo115215743ma_mbo
mana65341963mana__
manacle11310283manacle
manage93818903manage
manana84816073manana
manas76240433mana_s
manat76039993mana_t
manats84623463manats
mango85724323ma_ngo
maniac103917973maniac_
maniacs114313063maniacs
manic94629443manic_
manics103919933manics
manioc103914823manioc
manito8518693manito
mano66536813m__ano
manpack1746063manpack
mara67444573mara__
marabou1147493marabou
maracas11313773maracas
maras75443293mara_s
marasca1136823marasca
maraud938943maraud
marc87034633ma_rc_
marcatos1249163marcatos
march125622893ma_rch
marcs95726623ma_rcs
marrano939423marrano
masa65034723masa__
masala8311813masala
masas75630413masa_s
mascara1138023mascara
mascon103612743ma_scon
mascot104016073ma_scot
matador1066253matador
match125621103ma_tch
matzo16312893ma_tzo
maya95824593maya__
mayan105616903maya_n
mayas105924383maya_s
mayo96524303m__ayo
mazard1838763mazard
mecca1139933mec_ca
meccas1239493meccas
medico113711163medico
menace103216943menace
mica86428253mica__
micas96823053mica_s
micro94715993mic_ro
mikado1344513mikado
misact10316693misact
muchacho2051973muchacho
mucho125013443muc_ho
mucro94513723muc_ro
nacho105414383nac_ho
narco76718243na_rco
paca85132243paca__
pacas96029403paca_s
pachuco1642903pachuco
palace104516913palace
papacy1547493papacy
paramo102614643paramo
pataca10311193pataca
picacho1644733picacho
picaro10311323picaro
rabato83413263rabato
rococo1036813rococo
sacaton938993sacaton
secco9312423sec_co
taco67031353__taco
tapalo839793tapalo
turaco839453turaco
vacancy1744443vacancy
vacant11415133vacant
vacate11314553vacate
wacko145514383wac_ko
zacaton1845633zacaton
zocalo1735803zocalo

Search took 7 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161835.67319868.9
3Display Results1831830.0463978.3
 (SQL Overall)1786911836.09229332.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.