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

322 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
masalas931205(None) 
marsalas1038251marsalas
masala8311811masala_
asanas6514112_asanas
basalts9358962basalts
cabalas113516002cabalas
casabas1139982casabas
casavas1237812casavas
halalas104214082halalas
hawalas13348352hawalas
kabalas133911062kabalas
kamalas13339122kamalas
maculas113114012maculas
mananas93414732mananas
mandalas1139432mandalas
manilas93915872manilas
maracas11313772maracas
marsala939582marsala_
masas75630412mas__as
mascaras1237692mascaras
massas85116462mas_sas
mastabas1246802mastabas
nasals63312462nasal_s
qabalas18289502qabalas
aals49941143_a_al_s
abacas104414723_abacas
abakas123911743_abakas
abayas114011703_abayas
agamas97413443_agamas
akelas10311193_akelas
alas46358123___alas
anabas8314083_anabas
anlas55626933_a_nlas
argalas84011083argalas
asana5315483_asana_
ashlar9338193_ashlar
ashlars10297063_ashlars
asramas938303_asramas
asyla839333_asyla_
atlas55821583_a_tlas
azaleas1636993_azaleas
baals76122703ba_al_s
bacalao1146613bacalao
bacalaos1245863bacalaos
balas76937213__balas
balatas9311833balatas
bananas93312223bananas
basal75722283basal__
basally1237963basally
basalt83519583basal_t
basaltes10367683basaltes
basilar937303basilar
basils85717473basil_s
cabala103516913cabala_
cabals104020153cabal_s
cabanas112413033cabanas
cabbalas1467373cabbalas
callas84526753ca_llas
canals84421663canal_s
canolas9313993canolas
cantalas104013523cantalas
canulas9312853canulas
casaba1079263casaba_
casas75327843cas__as
casava1157873casava_
cascaras1237693cascaras
casitas93312043casitas
cassabas1245733cassabas
cassatas1036673cassatas
cassavas1344803cassavas
cassias93514343cassias
castles94917733castles
casuals91410523casual_s
catalase1039213catalase
catalos9414163catalos
catalpas1246733catalpas
causals91411183causal_s
cavallas1366843cavallas
cicalas1139293cicalas
coalas87418963_coalas
desalts839573desalts
easels65914553easel_s
falbalas1345473falbalas
fascias1258413fascias
favelas1337023favelas
galas65731643__galas
gayals1039513gayal_s
halala94715093halala_
halalah13429383halalah
halalahs14367443halalahs
halals95018313halal_s
hamadas1339663hamadas
hamals114816813hamal_s
hassles103411693hassles
hawala12368913hawala_
impalas11236953impalas
jacales16310323jacales
jacals1539873jacal_s
jacanas1638263jacanas
kabakas12367403kabakas
kabala124011553kabala_
kabayas16316803kabayas
kabbalas1674353kabbalas
kamala12339963kamala_
kanakas10327213kanakas
kashas133311903kas_has
koalas104011663_koalas
lasagnas943673lasagnas
maars74621633ma_a_rs
macacos1338083macacos
macadam1446853macadam
macadams1545093macadams
macaws1337023maca_ws
mackles154415753mackles
macles107023223ma_cles
macula103013673macula_
maculae113412863maculae
macular113011943macular
macules114015133macules
madames12310063madames
madams11310943mada_ms
madras94316423ma_dras
madrasas11317763madrasas
maffias15327283maffias
mafias113913573ma_fias
magalog1144903magalog
magalogs1245243magalogs
magilps1234083magilps
magmas115512503ma_gmas
mahatmas1543863mahatmas
mailes84329113ma_iles
maills84215283ma_ills
mails76037773ma_il_s
majaguas1842843majaguas
makars124612633maka_rs
malaccas1445163malaccas
malangas1136863malangas
malar76424443m__alar
malarias10313753malarias
malars85020683mala_rs
malates93522603malates
males75049793m__ales
malls76233433m__alls
malms95021553m__alms
malthas1237913malthas
malts76331753m__alts
mamaligas1443383mamaligas
mamas95930773m__amas
mambas125716243ma_mbas
mammals10389273mammal_s
mammas94616403ma_mmas
manacles1239523manacles
manages103418963manages
manana84816073manana_
manas76240423m__anas
manats84623463mana_ts
mandala10310203mandala_
mandolas1139133mandolas
mangas94122923ma_ngas
mangles104021463mangles
manias84029033ma_nias
manila84518303manila_
manillas102611163manillas
mannas85019803ma_nnas
mansards1148013mansards
mantas85725363ma_ntas
mantles94820703mantles
mantras93815863mantras
mantuas93410993mantuas
manuals9311213manual_s
maples104819423ma_ples
maquilas1944033maquilas
maraca10314153maraca_
marantas10310023marantas
maras75443283m__aras
marascas1247383marascas
marauds1037553marauds
marbles114516653marbles
marinas93519373marinas
markas124717003ma_rkas
markkas12356083markkas
marls75535163ma_rl_s
marshalls1444833marshalls
marshals1337783marshal_s
masa65034713mas__a_
mascara1138023mascara_
mascons113411583mascons
mascots113910343mascots
masers84623453mas_ers
mashers124621053mashers
mashes115030003mas_hes
mashies12318253mashies
masjids17175403masjids
maskegs14375413maskegs
maskers133913833maskers
masks115320533mas__ks
masons83916513mas_ons
masques18239363masques
mass66044933mas___s
massa75518923mas_sa_
massages1159883massages
masses85028713mas_ses
massifs1237743massifs
massless10277113massless
mastaba1146223mastaba_
mastabah1554023mastabah
mastabahs1642973mastabahs
masters94628923masters
mastics112614783mastics
mastless102610023mastless
masts77035763mas__ts
matildas1145023matildas
matsahs1236563matsa_hs
matzas1749703ma_tzas
mauls76524953ma_ul_s
maxillas17227703maxillas
mayas105924383m__ayas
mazards1937703mazards
mazumas2034623mazumas
meals75933373m_eal_s
measles92412753meas_les
medakas1435763medakas
medals94218043medal_s
mesally12119793mesally
mesas76823203mes__as
mescals112911553mescal_s
metals84520883metal_s
miasmas1167743mias_mas
misacts1139353misacts
misadds1136303misadds
misaims11310113misaims
misally121111063misally
misbias1139073misbias
miscalls1239003miscalls
misclass1246833misclass
miskals13369763miskal_s
mislay113510683mis_lay
mislays12349243mislays
misplan1147773misplan
misplans1238863misplans
misplay1436383misplay
misplays1555543misplays
missals93914423missal_s
modals93914443modal_s
molas75132093m__olas
moolas83615593m_oolas
morales93619403morales
morals85324633moral_s
morulas959703morulas
mosaics1138073mosaics
mousakas1442733mousakas
mullas84215933m_ullas
murals84016753mural_s
muscles11310563muscles
naganas847983naganas
nalas55528363__nalas
napalms1144033napalms
nasal56217593nasal__
nasalise848863nasalise
nasalism1048203nasalism
nasally1057443nasally
nyalas936903_nyalas
paellas9411413paellas
paisanas10288873paisanas
pajamas18278153pajamas
palapas11311493palapas
panadas103312213panadas
panamas113112753panamas
papayas1437273papayas
pascals11610013pascal_s
pashas115117063pas_has
pastas85422873pas_tas
patacas11311003patacas
payolas12148973payolas
piasabas1243883piasabas
piasavas1343333piasavas
posadas1037193posadas
psalms1045673_psalms
qabala17399193qabala_
qabalah21285033qabalah
qabalahs22253293qabalahs
radulas839583radulas
ramadas1039303ramadas
ramblas112710263ramblas
ranulas7311773ranulas
rascals959663rascal_s
rassles73513923rassles
ratals64219583ratal_s
resales74724903resales
sabals84618863sabal_s
sagas66025883__sagas
salad65321833__salad
salads75316963__salads
salal55425703__salal
salals65120083__salals
sales56055593__sales
salpas85116923__salpas
salps74423243__salps
sals46851673__sal_s
salsa56718923__salsa
salsas65316133__salsas
salts55431883__salts
samaras9312913samaras
samsaras1045873samsaras
sataras7315053sataras
sisals63013573sisal_s
tablas83716163ta_blas
talas55935893__talas
tamales93216143tamales
tamals84116623tamal_s
tambalas1237033tambalas
tampalas1245473tampalas
tapalos938813tapalos
taramas9612693taramas
tarsals72512603tarsal_s
teslas64212173tes_las
vasal85516293vasal__
vassals1057953vassal_s
wallas95719393wa_llas
wasabis1255363wasabis
yamalkas1743103yamalkas
zananas16319563zananas

Search took 10 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.1731032896.0
2DLD Change Limit1340273228.70315400.1
3Display Results3223220.1102927.3
 (SQL Overall)1786913228.98619885.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.