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

102 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
marasca113682(None) 
maraca10314151mara_ca
marascas1247381marascas
madrasa10387882madras_a
madrassa11274632madrassa
malacca1344962malacca
maracas11313772mara_cas
maranta9311692maranta
maras75443292maras__
marsala939582marsala
abaca95118043_aba_ca
abasia8712953_abasia
acrasia9310033acrasia
alaska1036713_alaska
arabica1147283_arabica
areca75618633_ar_eca
arista6415293_arista
arnica8310443_arnica
barbasco1443143barbasco
barca91319433bar__ca
barista9310813barista
barranca1245583barranca
berascal1244853berascal
canasta938363canasta
caracal11312513cara_cal
carack142113173cara_ck
caramba1336893caramba
carioca1139683carioca
harass9313943haras_s
harissa1035503harissa
labrusca1241913labrusca
maars74621633maars__
macaco1247853maca_co
madras94316433madras__
madrasah14324783madrasah
madrasas11317763madrasas
madrases112610003madrases
madrassah15293083madrassah
madrassas12304703madrassas
mahatma1443783mahatma
majagua1742863majagua
malaccas1445163malaccas
malanga1036663malanga
malaria9313703malaria
malvasia13164963malvasia
mamas95930773mamas__
manana84816073mana_na
manas76240433manas__
manioca11358943manioca
mara67444573mar___a
marabou1147493marabou
marantas10310023marantas
marasmic1446163marasmic
marasmus1244473marasmus
maraud938943mara_ud
marauds1037553marauds
marc87034633mar__c_
march125622893mar__ch
marcs95726623mar__cs
maremma1044463maremma
mares76457633mares__
maria75032883mar__ia
marimba1354983marimba
marina84623413mar_ina
marish114319053maris_h
marka114620793mar__ka
markas124717003markas__
markka11416593mar_kka
markkaa12373923markkaa
marks115933483marks__
marksman1645263marksman
marls75535163marls__
mars66261873mar_s__
marsalas1038253marsalas
marse76231153mar_s_e
marses84827113mar_ses
marsh105320853mar_s_h
marshal1238973mar_shal
marshy14558333mar_shy
marts77442233marts__
masa65034723m__as_a
masala8311813masa_la
masas75630413masas__
massa75518923m__assa
matrass939403matras_s
mayas105924383mayas__
miasma1097563m_iasma
moras76438783moras__
morass84614503moras_s
morassy12495043morassy
muras75329583muras__
musca9311763m__usca
myrica1336833myr_ica
paras76143043paras__
parashah1646453parashah
parasol939553parasol
pataca10311193pata_ca
rascal8511123__rascal
tamasha12125433tamasha
tarama8412733tara_ma
tarsia65514273tar_sia
varas86028193varas__

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 Limit1340271026.65620136.3
3Display Results1021020.0333090.9
 (SQL Overall)1786911027.09225196.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.