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

263 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
mamas9593077(None) 
amas67746291_amas
camas96333521camas
gamas85431361gamas
lamas75532791lamas
magmas115512501magmas
mama86231591mama_
mambas125716241mambas
mammas94616401mammas
manas76240431manas
maras75443281maras
masas75630411masas
mayas105924381mayas
aas310975392_a_as
abas68642082_abas
agamas97413452agamas
agas55938842_agas
agmas85919872agmas
alas46358122_alas
almas76629772almas
ama510853302_ama_
amah98927492_amah
amahs107819062_amahs
amass77119682_amass
amias75831472amias
amis66445322_amis
ammos94815822ammos
amps86230342_amps
amus65529612_amus
anas46649862_anas
atmas75721012atmas
baas66844672ba_as
babas96325732babas
balas76937212balas
bams87044452bam_s
bemas96424282bemas
bimas95521742bimas
cacas95627982cacas
camass104114182camass
cames97047312cames
camos95927612camos
camps116330262camps
cams87047282cam_s
casas75327842casas
comas95833002comas
cymas126417882cymas
dadas75819862dadas
daman84821162daman
damans94715982damans
damar84117732damar
damars93814992damars
damask1335842damask
dames85435852dames
damns84916922damns
damps105220412damps
dams77444372dam_s
dramas95814652dramas
dumas85420432dumas
fames105735922fames
favas115618592favas
galas65731642galas
gama77035522gama_
gamay116419112gamay
gamays126310912gamays
gambas115817512gambas
gambs105721122gambs
games86238552games
gammas115714692gammas
gamps105323712gamps
gams76648882gam_s
gramas94317202gramas
hahas117118442hahas
halmas117017892halmas
hamal104623112hamal
hamals114816822hamals
hames106138702hames
hams96446132ham_s
hamzas20119012hamzas
iambs95815062iambs
imams91511112imam_s
jambs166014622jambs
jams135231072jam_s
javas155915422javas
kaas86531842ka_as
kakas85117342kakas
kames115024692kames
kanas95326912kanas
kapas116021732kapas
karmas123013732karmas
katas95922092katas
kavas125919952kavas
lama66635292lama_
lambs95921412lambs
lames75445542lames
lamias85020612lamias
lampas106615952lampas
lamps95624832lamps
lams66552262lam_s
lavas85422222lavas
limas75627632limas
llamas888972llamas
lumas75622912lumas
maar66025062ma_ar
maars74621632maars
mabes96331532mabes
macaw12311762macaw
macaws1337022macaws
maces97139962maces
machs125722562machs
macks135127602macks
macs86742512ma_cs
madam10316222madam
madams11310942madams
madman113712382madman
madras94316432madras
mads76845372ma_ds
maes66948402ma_es
mafias113913572mafias
mages85036022mages
magma104513572magma_
mags75444532ma_gs
magus85318752magus
maids86327142maids
mails76037782mails
maims96321792maims
mains75635112mains
mairs76228302mairs
makar115614972makar
makars124612632makars
makes115336852makes
makos116518362makos
malar76424442malar
malars85020682malars
males75049792males
malls76233432malls
malms95021552malms
malts76331752malts
mamba116317522mamba
mambo115215742mambo
mambos125414492mambos
mamey125418832mamey
mameys13449522mameys
mamie95826002mamie
mamies104626242mamies
mamma86317912mamma
mammae94613212mammae
mammal95112752mammal
mammals10389272mammals
mammy115215162mammy
mana65341962mana_
manat76039992manat
manats84623462manats
manes76648962manes
mangas94122922mangas
manias84029032manias
mannas85019802mannas
manos74933622manos
mans66354552ma_ns
mantas85725362mantas
manus75924932manus
maps86141052ma_ps
mara67444572mara_
marcs95726622marcs
mares76457632mares
markas124717002markas
marks115933482marks
marls75535162marls
mars66261872ma_rs
marts77442232marts
mas58175822__mas
masa65034722masa_
masks115320532masks
mass66044942ma_ss
massa75518922massa
massas85116462massas
masts77035762masts
mates75251362mates
maths105624022maths
mats65460292ma_ts
matts76829182matts
matzas1749702matzas
mauds85519272mauds
mauls76524952mauls
mauts75927192mauts
mavis105622722mavis
maws96437142ma_ws
maxes145629532maxes
maxis145721562maxis
maya95824592maya_
mayan105616902mayan
mayos105521932mayos
mays96940032ma_ys
mazes165632172mazes
mazumas2034622mazumas
memes94927702memes
memos95719112memos
mems85931502mem_s
mesas76823202mesas
miasmas1167742miasmas
micas96823052micas
mimes95732022mimes
minas75434112minas
moas65545342m_oas
molas75132092molas
momes95134472momes
mommas94110652mommas
moms86539482mom_s
momus96116112momus
monas74732152monas
moras76438772moras
moxas145014392moxas
mumms85513152mumms
mumps115619102mumps
mums85732772mum_s
mumus95517282mumus
muras75329562muras
mynas105815232mynas
myomas1338302myomas
nadas66320812nadas
nalas55528362nalas
names74833362names
nanas55928632nanas
napas75924352napas
nemas75321572nemas
nomas74726412nomas
pacas96029402pacas
pampas124913992pampas
pams85641762pam_s
papas94927492papas
paras76143042paras
pimas94725102pimas
pumas95121562pumas
ragas65326062ragas
raias54631122raias
rajas127317722rajas
ramal74622242ramal
ramps96224632ramps
rams65950772ram_s
ramus76418282ramus
rayas85922052rayas
sagas66025882sagas
sambas104219262sambas
samps96124672samps
shamas113717942shamas
simas75727552simas
somas76030372somas
takas95520682takas
talas55935892talas
tamal73522622tamal
tamals84116632tamals
tames75242012tames
tamis76728732tamis
tamps95524082tamps
tams67247932tam_s
tapas74627712tapas
ulamas8910452ulamas
umamis1038272umamis
vamps125415482vamps
varas86028192varas
wames106432802wames
wamus105514682wamus
yams95330732yam_s
zamias174212922zamias

Search took 2 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.0931921408.6
2DLD Change Limit538002631.67332157.8
3Display Results2632630.0634174.6
 (SQL Overall)1786912631.82997698.7
 
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.