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

254 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
grammas1249977(None) 
gammas115714691g_ammas
gramas94317201gra_mas
gramma11499801gramma_
grammar12406891grammar
grammars13345941grammars
grammes123611321grammes
grampas12399251grampas
brahmas1436732brahmas
dramas95814652dra_mas
gamas85431362g_a_mas
gambas115817512g_ambas
gamma106116102g_amma_
grahams1335332grahams
grama85620282gra_ma_
gramme114210332gramm_e
grampa115010172grampa_
gramps114114272gra_mps
grampus12356312grampus
grams85327312gra_m_s
grandmas1236922grandmas
grappas12357102grappas
gummas114810512g_ummas
mammas94616402_mammas
shammas14358722shammas
traumas938592traumas
agamas97413453aga_mas
agmas85919873__agmas
almas76629773__almas
amas67746293__a_mas
amias75831473__amias
ammos94815823__ammos
arames84622573ara_mes
aramids102810513aramids
armadas1038173armadas
aromas81018613ar_omas
asramas938303asra_mas
atmas75721013__atmas
brahma1336193brahma_
bravas114913323bra_vas
brazas175812433bra_zas
camas96333523_ca_mas
chacmas1638003chacmas
commas124814573_commas
crambes1339963crambes
crambos1336783crambos
crammed143710123crammed
crammer134010963crammer
crammers14369353crammers
cramps125615563cra_mps
crams96229153cra_m_s
dammar11438903_dammar
dammars12308193_dammars
dharmas1356513dharmas
digammas1443003digammas
drachmas1644863drachmas
drama85117413dra_ma_
drammed13378073drammed
drams86025833dra_m_s
drayman1335433drayman
engrammes1444513engrammes
fracas11311993fra_cas
framers125113823framers
frames115119863fra_mes
gagman103811243g_agman
galas65731643g_a_las
galeas74618513g_aleas
gama77035523g_a_ma_
gamay116419113g_a_may
gamays126310913g_amays
gamba106018513g_amba_
gambes116318313g_ambes
gambias125010733g_ambias
gambs105721123g_a_mbs
gamers94420833g_amers
games86238553g_a_mes
gamins94420053g_amins
gammed124216163g_ammed
gammer1112318333g_ammer
gammers123214563g_ammers
gammon1138903g_ammon
gammons1237973g_ammons
gammy135514893g_amm_y
gamps105323713g_a_mps
gams76648883g_a_m_s
gamuts958783g_amuts
ganjas14149113g_anjas
gasman92911743g_asman
gaums86217073g_aum_s
gemma106311773g_emma_
gemmae11507793g_emmae
gimmal11247513g_immal
gimmals12225823g_immals
gimmes113010903g_immes
glamors1068113glamors
glams85822933gla_m_s
gliomas1035333gliomas
goannas836223goannas
graal64316503gra__al
graals74112913gra_als
grabens10367003grabens
grabs85719693gra__bs
graces94523493gra_ces
graders94716013graders
grades84926313gra_des
gradins93416233gradins
grads75625753gra__ds
gradual936943gradual
graduals1046203graduals
gradus84411223gra_dus
grafts105013253gra_fts
graham1237853gra_ham
grails77518783gra_ils
grains74223093gra_ins
gram77034583gra_m__
gramary1355903gramary
gramp106218323gra_m_p
grana65722093gra_na_
grandad1038453grandad
grandads1136553grandads
grandam1139393grandam
grandams1237123grandams
grandma1136913grandma_
grandmamas1672193grandmamas
grandpas1236003grandpas
grands84218243gra_nds
granges93516523granges
granitas92610223granitas
granolas938053granolas
grans64832543gra__ns
grants73722473gra_nts
grapes95123123gra_pes
graphs124510153gra_phs
grappa11396443grappa_
grasps9489253gra_sps
grass66125203gra__ss
grasses84117343grasses
graters85419743graters
grates75429893gra_tes
gratins84119183gratins
gratis74819243gra_tis
gravels113611143gravels
gravers114515273gravers
graves104624003gra_ves
gravidas13285803gravidas
gravies11314093gravies
gravitas12316013gravitas
gravlaks1642423gravlaks
gravlax1842643gravlax
graylag1283113graylag
graylags1372983graylags
graymail1443273graymail
graymails1542803graymails
grays95621333gra__ys
grazers175112453grazers
grazes164519643gra_zes
gremial1039153gremial
gremials1136133gremials
gremmie1264383gremmie
gremmies1355993gremmies
gremmy1454473gremm_y
grimes94619033gr_imes
grimmer123510093grimmer
grimmest13286293grimmest
gringas938043gringas
gripman1234463gripman
grommet12268453grommet
grommets13234663grommets
grooms94512523groom_s
grumes94415553gr_umes
grummer12338783grummer
grummest13286363grummest
grummet12298873grummet
grummets13275033grummets
grumous1086613grumous
grumps114510573gr_umps
guavas1037163gua_vas
gumma105313103g_umma_
halmas117017893_halmas
hammal134512063_hammal
hammals14409223_hammals
hammam12419333_hammam
hammams13386443_hammams
hamzas20119013_hamzas
karmas123013733_karmas
lamas75532793_la_mas
lamias85020613_lamias
lampas106615953_lampas
lemmas10349163_lemmas
llamas888973lla_mas
magmas115512503_magmas
mamas95930773_ma_mas
mambas125716243_mambas
mamma86317913_mamma_
mammae94613213_mammae
mammal95112753_mammal
mammals10389273_mammals
miasmas1167743miasmas
mommas94110653_mommas
pampas124913993_pampas
plasmas113010753plasmas
praams10459643praam_s
prajnas1635453prajnas
prams96125513pra_m_s
primas104418103pr_imas
ragas65326063_ra_gas
ragman94013713_ragman
raias54631123_ra_ias
raitas64417673_raitas
rajas127317723_ra_jas
ramadas1039303_ramadas
ramal74622243_ra_mal
ramblas112710263_ramblas
ramees84620893_ramees
ramets83517393_ramets
ramies84630463_ramies
rammed113117303_rammed
rammer103519653_rammer
rammers113715043_rammers
rammish1437563_rammish
rammy124312493_ramm_y
ramonas9311093_ramonas
ramous8417113_ramous
ramps96224633_ra_mps
rams65950773_ra_m_s
ramus76418283_ra_mus
rayas85922053_ra_yas
rumbas102512013_rumbas
sambas104219263_sambas
shamas113717943sha_mas
shammash18293753shammash
shammes144312833shammes
shammos14307203shammos
sradhas1176153sradhas
stemmas11256973stemmas
summas104313163_summas
taramas9612703taramas
tramcar1135593tramcar
tramcars1245233tramcars
tramels93812493tramels
trammed123810713trammed
trammel11357663trammel
trammels12295413trammels
tramps105114453tra_mps
trams75327673tra_m_s
tramway1544863tramway
tramways1643723tramways
trauma838803trauma_
ulamas8910453ula_mas
uraemias1046043uraemias
uranias72113813uranias
uremias9249503uremias
wammus13426733_wammus
zamias174212923_zamias

Search took 7 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.406440125.6
2DLD Change Limit1340272546.08022043.9
3Display Results2542540.0763342.1
 (SQL Overall)1786912546.56227231.2
 
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.