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

124 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
marcato113974(None) 
marcatos1249161marcatos
macaco1247852ma_caco
marrano939422marrano
mercapto1443312mercapto
amaretto10104643amaretto
arcade91013643_arcade
arcana8912583_arcana
arcane81216743_arcane
arco68331543_arc__o
arcuate9311963_arcuate
arhat8327093_arhat_
arhats9312973_arhats
aristo6414033_aristo
arnatto7145073_arnatto
baccate131011263baccate
barbate11314543barbate
barca91319433barca__
barcas101016603barca_s
barrator1048403barrator
bearcat11611913bearcat_
bearcats1267023bearcats
cacao95420003ca_ca_o
carat75048793car_at_
carate84734003car_ate
carats85929023car_ats
carcajou19123583carcajou
carcase11312743carcase
carcass11310513carcass
demarcate1446613demarcate
falcate12311613falcate
farrago1144923farrago
furcate12310453furcate
karat96837593kar_at_
karate105320923kar_ate
karats106420493kar_ats
lariat6629043lariat_
lariats7615053lariats
macacos1338083ma_cacos
macaw12311763ma_ca_w
macaws1337023ma_caws
maccaboy1942513maccaboy
macho126120153ma_c_ho
macrame1338713macrame
macro94718173ma_c_ro
madcap1336333madca_p
madcaps1435243madcaps
magmata1237463magmata
magnate10512703magnate
magneto1046743magneto
malate84624553ma_late
maleate94117543maleate
mammate104411273mammate
mammati10398373mammati
manat76039993ma_nat_
manats84623463ma_nats
mandate10315573mandate
mandator1148183mandator
manito8518693ma_nito
mara67444573mar_a__
marabou1147493mar_abou
maraca10314153mar_aca
maracas11313773maracas
maranta9311693maranta
maras75443293mar_a_s
marathon1346813mar_athon
maraud938943mar_aud
marc87034633marc___
marcasite1346663marcasite
marcel103714853marc_el
marcels113212373marcels
march125622893marc__h
marched153813403marched
marchen143312073marchen
marcher143912973marcher
marches143921173marches
marcs95726623marc__s
marengo1035263marengo
margay12310593marga_y
margays1337493margays
maria75032883maria__
marinate103017783marinate
marital92314183marital
marka114620793marka__
markas124717003marka_s
market123226043market_
markets133314033markets
marlite92917073marlite
marmite112413993marmite
marmot10318743marmot_
marmots11311513marmots
marocain1247063marocain
marplot1149673marplot
marram10313883marra_m
marrams11310123marrams
marranos1038423marranos
marsala939583marsala
mart66865983mar__t_
martagon1145273martagon
marts77442233mar__ts
mascara1138023mascara
mascot104016073mascot_
mascots113910343mascots
mudcat11311203mudcat_
mudcats1236223mudcats
muriate9313363muriate
muricate12311113muricate
muscat10314663muscat_
muscats1138933muscats
narco76718243narc__o
narrate7313493narrate
narrator847563narrator
paramo102614643par_amo
rabato83413263ra_bato
rato45436973__r_ato
sacaton938993sa_caton
saccate111311763saccate
sarcasm1136693sarcasm
staccato1244063staccato
vacate11314553va_cate
varactor1345683varactor
variate101316433variate
warpath1545203warpath
zacaton1845633za_caton

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271247.31318327.2
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.76223021.3
 
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.