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 “marrano” 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
marrano93942(None) 
marranos1038421marranos
arrant6623252_arrant
barranco1244942barranco
farrago1144922farrago
madrono10288742madrono
marcato1139742marcato
marram10313882marra_m
marrams11310122marrams
marring103319552marring
marron83717542marron_
marrons93216972marrons
serrano768462serrano
warrant10614242warrant
amorino9310253amorino
arcana8912583_arcana
arcane81216743_arcane
arrack121110253_arrack
arrange838683_arrange
arras55626133_arra_s
array86317143_arra_y
arrays95311683_arrays
arroyo936963_arroyo
arseno6318913_arseno
arsino64113513_arsino
barman103519703barman_
barrack1538253barrack
barrage10710853barrage
barranca1245583barranca
barrancos1344203barrancos
barrator1048403barrator
barren85317623barren_
barrens94414323barrens
barring104021593barring
barrio8312573barr_io
carman103920743carman_
carrack1548753carrack
carrion9312673carrion
carryon1237033carryon
curran8312023curran_
currans9310613currans
currant9314173currant
earring83519013earring
errand758793_errand
errant6618733_errant
garbanzo2042583garbanzo
gardant9314463gardant
garland948703garland
garring93116713garring
garron73113493garron_
garrons82713463garrons
hariana10310243hariana
jarrah1636683jarra_h
jarrahs1735453jarrahs
jarring153613193jarring
karroo10410013karr_oo
largando1043803largando
macaco1247853ma_caco
macrame1338713macrame
macro94718173macr__o
macron103615673macron_
macrons113514893macrons
macruran1244013macruran_
macrurans1343533macrurans
madman113712383madman_
madras94316433madra_s
madrasa10387883madrasa
madrona10288703madrona
madrone102812663madrone
madronos11337543madronos
magian9312833magian_
magians10310753magians
maharani1344623maharani
mahuang1372883mahuang
manana84816073ma_nana
mannan85413623mannan_
mannans93611523mannans
mano66536813m___ano
mara67444573ma_ra__
marabou1147493ma_rabou
maraca10314153ma_raca
maranta9311693ma_ranta
maras75443293ma_ra_s
maraud938943ma_raud
marcatos1249163marcatos
marengo1035263marengo
margay12310593marga_y
margays1337493margays
margent10316693margent
margin94016853margin_
margins103815193margins
margrave1444793margrave
maria75032883maria__
marina84623413ma_rina
marinas93519393marinas
marine84230403ma_rine
marka114620793marka__
markas124717003marka_s
marking144020133marking
marlin84220903marlin_
marline93320953marline
marling103322763marling
marlins93420473marlins
maroon83118203maroon_
maroons92615553maroons
marred95421043marr_ed
marrer83716673marr_er
marrers93414313marrers
marriage1147253marriage
married104715303married
marrier93817523marrier
marries93825283marries
marrow112812613marr_ow
marrows122911833marrows
marrowy15236093marrowy
marry104821693marr__y
marrying14157233marrying
marsala939583marsala
martagon1145273martagon
marten84518263marten_
martens93714953martens
martian93514683martian_
martians103111613martians
martin84122523martin_
marting103325013marting
martini93613873martini
martins93322063martins
maryjane2043043maryjane
matrass939403matrass
matron83918313matron_
matrons93517633matrons
mayan105616903ma_yan_
merino8315093m_erino
merman10513863merman_
migrant10314313migrant
mordant10312403mordant
morgan9311373morgan_
morgans10310123morgans
morrion959003morrion
morro73216953morr__o
murra74519083murra__
murrain937763murrain
murrains1036853murrains
murras84916013murra_s
murrine9411483murrine
narrate7313493narrate
narrator847563narrator
paesano9338793paesano
paisano9429513paisano
paramo102614643pa_ramo
parang93715513pa_rang
parian83223963parian_
parians93519733parians
parlando1145413parlando
parral85517533parra_l
parrals94414573parrals
parring103222063parring
partan83820563partan_
partans94418283partans
saran53730303sa_ran_
sarans64224433sa_rans
sardana838643sardana
serranos857873serranos
soprano937003soprano
tarpan82814293tarpan_
tarpans92513533tarpans
tarragon944673tarragon
tarring83318303tarring
tartan64217513tartan_
tartana73010193tartana
tartans72615823tartans
tarzan152910753tarzan_
tarzans16329923tarzans
terrane72814233terrane
vagrant11410663vagrant
variant10316803variant
warrantor1243213warrantor
warrants1168503warrants
warranty1465043warranty
warren95012863warren_
warrens103810893warrens
warring113717973warring
zebrano1843853zebrano

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.423422437.4
2DLD Change Limit1340271837.08018930.4
3Display Results1831830.0603050.0
 (SQL Overall)1786911837.56323627.0
 
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.