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 “molas” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

266 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
molas7513209(None) 
bolas74733761bolas
colas75436771colas
kolas94822231kolas
moas65545341mo_as
mola66035631mola_
molal75120341molal
molar75223091molar
molars85517321molars
molds85324831molds
moles74747921moles
molls75129781molls
mols65948571mol_s
molts76032091molts
monas74732151monas
moolas83615591moolas
moras76438781moras
moxas145014391moxas
tolas54532771tolas
alas46358122_alas
amoles84122192amoles
anlas55626932anlas
atlas55821582atlas
balas76937212balas
boas66150832bo_as
bola66035562bola_
bolar75123472bolar
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
boras75938302boras
botas75328782botas
boylas113011722boylas
cholas114818002cholas
coalas87418962coalas
coals76129602coals
cocas95926572cocas
codas84724242codas
cola66541392cola_
colds85726972colds
coles76055062coles
cols66553082col_s
colts76633292colts
colzas174010512colzas
comas95833002comas
doblas93812292doblas
doles67843752doles
dolls66126922dolls
dolmas95213042dolmas
dols56943052dol_s
dolts65626312dolts
donas65926472donas
dopas85019062dopas
doulas75114992doulas
foals85721692foals
folds95221692folds
folks126017122folks
galas65731642galas
goals65521292goals
goas55239942go_as
golds75421312golds
golfs95616102golfs
holds94623242holds
holes84748652holes
holks124720562holks
hollas94616902hollas
holms105117802holms
hols76946292hol_s
holts85627912holts
horas86333102horas
hoyas115016162hoyas
hulas84920882hulas
hylas114815902hylas
iotas54821112iotas
joles125230832joles
jolts125018882jolts
jotas125717442jotas
koalas104011662koalas
koas85635092ko_as
kola85124962kola_
kolos94921212kolos
koras95927112koras
las37281472__las
lolls512121732lolls
lotas55926302lotas
malar76424442malar
malars85020682malars
males75049792males
malls76233432malls
malms95021552malms
malts76331752malts
mamas95930772mamas
manas76240432manas
maras75443292maras
mas58175822m__as
masas75630412masas
mayas105924382mayas
meals75933372meals
melds84822382melds
mells75031332mells
mels65941532mel_s
melts74930102melts
mesas76823202mesas
micas96823052micas
milds86422052milds
miles74645072miles
milks115020582milks
mills75435052mills
milos75428012milos
milpas101710272milpas
mils66045332mil_s
milts75430712milts
minas75434112minas
moa57249182mo_a_
moan65832022mo_an
moans74624372moans
moat66352032mo_at
moats75827642moats
mobs85737372mo_bs
mochas13310662mochas
mocks135023822mocks
mocs85834902mo_cs
modal85919242modal
modals93914452modals
modes85537412modes
mods77945052mo_ds
modus85417202modus
mogs75439332mo_gs
moils76125752moils
mojos145314462mojos
mokes114631032mokes
mol56654592mol__
mold76034332mol_d
moldy115014652moldy
mole66251832mol_e
molest85022742molest
molies84429512molies
moll66735702mol_l
mollah11319452mollah
mollahs12328282mollahs
molly105222492molly
molt66356162mol_t
molto75619602molto
moly96031912mol_y
momes95134472momes
mommas94110652mommas
moms86539482mo_ms
momus96116112momus
monad85519472monad
monads94515302monads
monks116123392monks
monos75930862monos
mons68152262mo_ns
moods85224622moods
moola75117032moola_
moolah11409192moolah
moolahs12347382moolahs
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302mo_os
moots75831662moots
mopes95134982mopes
mops85940132mo_ps
mora66641272mora_
morae75831192morae
moral75533432moral
morals85324632morals
morass84614502morass
moray105423792moray
morays114613882morays
mores76249642mores
morns75527442morns
mors65950062mo_rs
morts75533562morts
morulas959712morulas
mos57067122mo__s
mosks116117002mosks
moss67641032mo_ss
mosts76028542mosts
motes75944002motes
moths106021552moths
mots66853162mo_ts
motts76527002motts
moues75732842moues
moulds94910992moulds
moults84713702moults
moves106128422moves
mows96340832mo_ws
moxa136917742moxa_
mozos165516332mozos
mules75034292mules
mullas84215932mullas
mulls75124152mulls
muras75329582muras
mylar105311532mylar
mylars114310442mylars
mynas105815232mynas
myomas1338302myomas
nalas55528362nalas
nolos54423352nolos
nomas74726412nomas
nonas55126652nonas
novas85215362novas
obas65730932_obas
ocas66729632_ocas
odas57230262_odas
okas85225392_okas
olds55926572_olds
oles46453472_oles
ollas54218282ollas
polar75623452polar
polars84419352polars
poles75351002poles
polis74731162polis
polkas1239102polkas
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
rotas54827722rotas
smolts84411882smolts
sobas74424252sobas
socas74026182socas
sodas64123542sodas
sofas85320712sofas
sojas124716392sojas
sola45541862sola_
solan55328152solan
solans64122492solans
solar55927342solar
soles55547922soles
solos54830792solos
sols45448162sol_s
solus54726982solus
somas76030372somas
soras55041012soras
soyas84520912soyas
talas55935892talas
toeas55726422toeas
togas67823002togas
tola45236332tola_
tolan55124012tolan
tolans64319272tolans
tolar55524112tolar
tolars64817942tolars
toles55147132toles
tolls54728432tolls
tolus55024482tolus
toras55540372toras
violas93713522violas
volar86917412volar
voles86234042voles
volts85421292volts
volvas12447992volvas
wolds95420182wolds
wolfs116214162wolfs
yogas96615602yogas
yolks125412772yolks
zoeas145815612zoeas

Search took 3 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 Filter178691538000.326548131.9
2DLD Change Limit538002661.72031279.1
3Display Results2662660.0604433.3
 (SQL Overall)1786912662.10684848.5
 
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.