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

157 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
macacos133808(None) 
macaco1247851macaco_
cacaos104616182caca_os
macaws1337022maca_ws
machos135217492mac_hos
macros104017012mac_ros
maracas11313772maracas
marcatos1249162marcatos
abacas104414723_abacas
abacus10349763_abacus
acacia10311353_acacia
acacias11510403_acacias
acajou1595233_acajou
acajous1666483_acajous
acarus8312193_acarus
accost101112263_ac_cost
alamos8415003_alamos
bacalaos1245863bacalaos
bancos104713893ba_ncos
bayamos1434663bayamos
cacao95420003caca_o_
cacas95627983__cacas
calicos113913493calicos
calos74431903__calos
camos95927613__camos
capos94826073__capos
caracks152211563caracks
caracol11310423caracol
caracols12310413caracols
catalos9414163catalos
cocos95624693__cocos
facades1339033facades
galagos938143galagos
gazabos1944453gazabos
guacos94410313_guacos
guanacos1163813guanacos
jacales16310323jacales
jacals1539873jaca_ls
jacanas1638263jacanas
kakapos1243673kakapos
lavabos1235453lavabos
maars74621633ma_a_rs
macaber1336163macaber
macabre1335223macabre
macadam1446853macadam
macadams1545093macadams
macaque2044053macaque
macaques2143953macaques
macaroni1246523macaroni
macaronis1346563macaronis
macaroon1246343macaroon
macaroons1345563macaroons
macaw12311763maca__w
maccaboy1942513maccaboy
maccaboys2051773maccaboys
macers105321273mac_ers
maces97139963m__aces
maches134827233mac_hes
macho126120153mac_ho_
machs125722563m__achs
machzor2344263machzor
machzors2444113machzors
mackles154415753mackles
macks135127603m__acks
macles107023223mac_les
macon94519953m__acon
macons104017243mac_ons
macrames1438953macrames
macro94718173mac_ro_
macrocosm1743783macrocosm
macron103615673mac_ron
macrons113514893macrons
macs86742513m__ac_s
maculas113114023maculas
macules114015133macules
madames12310063madames
madams11310943mada_ms
madcaps1435243madca_ps
maduros1036303maduros
magalog1144913magalog
magalogs1245253magalogs
magics115311613magic_s
makars124612633maka_rs
makos116518363m__akos
malacca1344953malacca
malaccas1445163malaccas
malars85020683mala_rs
malates93522603malates
malices114316623malices
mamas95930773mama__s
mambos125414493ma_mbos
manacle11310283manacle
manacles1239523manacles
manages103418963manages
mananas93414733mananas
manas76240433mana__s
manats84623463mana_ts
mangos94319333ma_ngos
maniacs114313063maniac_s
manics103919933manic_s
maniocs113611443maniocs
manitos9314053manitos
manos74933623m__anos
marabou1147493marabou
marabous1249063marabous
maraca10314153marac_a
maras75443293mara__s
marascas1247383marascas
marauds1037553marauds
marcato1139743marcato_
marcs95726623ma_rc_s
marranos1038423marranos
masalas9312053masalas
masas75630413masa__s
mascaras1237693mascaras
mascon103612743ma_scon
mascons113411583ma_scons
mascot104016073ma_scot
mascots113910343ma_scots
matador1066253matador
matadors1156983matadors
matzos1749263ma_tzos
mayas105924383maya__s
mayos105521933m__ayos
mazards1937703mazards
meccas1239493mec_cas
medicos12339833medicos
menaces112715523menaces
micaceous1544223micaceous
micas96823053mica__s
micros104115363mic_ros
mikados1444683mikados
misacts1139353misacts
muchachos2161833muchachos
nachos115014183nac_hos
narcos86714203na_rcos
pacas96029403paca__s
pachucos1742793pachucos
palaces114216453palaces
parados103816053parados
paramos113213513paramos
patacas11311003patacas
picachos1744523picachos
picaros11310893picaros
rabatos93010903rabatos
rococos1145903rococos
sacaton938993sacaton
sacatons1038973sacatons
seccos1039923sec_cos
tacos77023553__tacos
tapalos938813tapalos
turacos938643turacos
vacates12312833vacates
wackos155210993wac_kos
zacaton1845633zacaton
zacatons1945703zacatons
zocalos1835393zocalos

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271576.45320769.7
3Display Results1571570.0463413.0
 (SQL Overall)1786911576.88925938.6
 
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.