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

427 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
mamboes13501182(None) 
mamboed14417621mamboed
mambos125414491mambo_s
ambles105121862_ambles
ambones11312682_ambones
ambos95321252_ambo_s
bamboos1348752bamboos
bimboes13498732bimboes
cramboes1436542cramboes
gambes116318312gamb_es
gambles124016202gambles
gamboges1435652gamboges
gambols1238592gambols
hambones1539672hambones
jambes175914052jamb_es
lambies113015112lambies
mabes96331532ma_b_es
mahoes11313102ma_hoes
mambas125716242mamb_as
mambo115215742mambo__
mameyes14376982mameyes
mamies104626242mam_ies
mammees104411142mammees
mammies104314762mammies
mammons1048512mammons
mangoes104316132mangoes
marbles114516652marbles
maybes1339242mayb_es
mumbles133014432mumbles
rambles113118312rambles
sambos104315192sambo_s
wambles143714022wambles
abbes96723523_a_bbes
abbots1039283_abbots
ables75935543_a_bles
abodes94417513_a_bodes
abos67734413_a_bo_s
aboves114512843_a_boves
abyes105518533_a_byes
adobes94411523_adobes
aloes54933673_a_loes
amazes175613473_amazes
ambages1269623_ambages
ambeer104511603_ambeer
ambeers11428923_ambeers
amber94523213_amb_er
ambers104519573_ambers
ambits103713413_ambits
amble95924643_amble_
ambled115116363_ambled
ambler104916453_ambler
amblers115213563_amblers
ambo88225143_ambo__
ambries111614543_ambries
amices105018013_amices
amides95722663_amides
amies76837693_am_ies
amines84727983_amines
ammines11312673ammines
ammos94815823_ammo_s
amoks11413553_am_oks
amoles84122193_amoles
amuses85117943_amuses
arbores94016033_arbores
arbors84717873_arbors
babbles104416323babbles
babes95834113ba_b_es
babies106123653ba_bies
baboos103517013ba_boos
balboas113710073balboas
bamboo12310013bambo_o
banjoes16317313banjoes
barbes104526233barb_es
barbies114519593barbies
batboys1465833batboys
baubees11348713baubees
baubles113611863baubles
bawbees14337243bawbees
bilboes114410233bilboes
bimbos124610523bimbo_s
bombes124916823bomb_es
brambles14308973brambles
buboes104513993_buboes
bumbles134016843bumbles
cabbies133115163cabbies
cables104527553ca_bles
cabobs124311893ca_bobs
camases114216343camases
camber124418473camb_er
cambers134017433cambers
cameoed1238383cameoed
cameos105818003cameo_s
cames97047313cam__es
camions113916133camions
camises114218463camises
cammies134016473cammies
camos95927613cam_o_s
campos125217953campo_s
canoes84725883ca_noes
carbons115418943carbons
carbos105122263carbo_s
carboys144711783carboys
cargoes104415223cargoes
combes125321733comb_es
combos125316613combo_s
crambes1339953cramb_es
crambos1336783crambo_s
dabbles124514773dabbles
dadoes85616533da_does
dagoes85714603da_goes
damages11511273damages
dames85435853dam__es
damsons1038013damsons
darbies104216983darbies
daubes94913703daub_es
dumbos114111083dumbo_s
emboss1087383_emboss
embows1396823_embows
fables114921673fa_bles
fames105735923fam__es
famines123216263famines
famous11412393fam_ous
fatsoes10379423fatsoes
fimbles143510663fimbles
flambes14419503flamb_es
fumbles143514413fumbles
gabbles124415413gabbles
gabies93820733ga_bies
gables94222333ga_bles
gambades1435863gambades
gambadoes1542823gambadoes
gambas115817513gamb_as
gambe106219213gamb_e_
gambias125010733gambias
gambier124711973gambier
gambiers13337073gambiers
gambirs12359083gambirs
gambits12399723gambits
gamble115417183gamble_
gambled134112163gambled
gambler123612683gambler
gamblers13369733gamblers
gamboge1335583gamboge
gambol1138223gambo_l
gamboled1435873gamboled
gambrel1235453gambrel
gambrels1334213gambrels
gambs105721123gamb__s
games86238553gam__es
gametes10312253gametes
gamines103618463gamines
gammons1237973gammons
garbles104016923garbles
gazaboes2043863gazaboes
gazeboes2043393gazeboes
goboes95914443_goboes
gombos114311093gombo_s
gumbos114610873gumbo_s
halloes104021513halloes
haloes94623863ha_loes
hamates122917673hamates
hambone1439313hambone
hamboned1637003hamboned
hames106138703ham__es
harbors12412413harbors
hatboxes2055003hatboxes
hoboes114717443_hoboes
hombres14369873hombres
humbles143215803humbles
iambics13425643iambics
iambs95815063iamb__s
iambus10468903iamb_us
iambuses1235783iambuses
imagoes10126403ima_goes
imamates1237653imamates
imbues1037983_imbues
jabots1538883ja_bots
jambe165314753jamb_e_
jambed184811403jamb_ed
jamboree1944863jamboree
jamborees2043273jamborees
jambs166014623jamb__s
jammies183611293jammies
jawbones20134853jawbones
jumbles183013323jumbles
jumbos17379123jumbo_s
kabobs14439303ka_bobs
kames115024693kam__es
kayoes134710823ka_yoes
labors84016403la_bors
lambdas1246243lambdas
lambed115614783lamb_ed
lamber104418493lamb_er
lambers113817103lambers
lambie103213673lambie_
lambier113611643lambier
lambiest122410183lambiest
lambs95921413lamb__s
lames75445543lam__es
lassoes74613853lassoes
lavaboes1344433lavaboes
limbos104712143limbo_s
mabe85733353ma_b_e_
maces97139963ma__ces
maches134827233ma_ches
machos135217493macho_s
mackles154415753mackles
macles107023223ma_cles
macons104017243ma_cons
macrons113514893macrons
macros104017013macro_s
macules114015133macules
madames12310063madames
madres93718183ma_dres
madrones112912283madrones
madtoms1236923madtoms
maes66948393ma___es
mages85036023ma__ges
maggots1136553maggots
magots9312363ma_gots
magpies12310363magpies
mahoe10315573ma_hoe_
mahzors2135123mahzors
mailboxes2042703mailboxes
mailes84329113ma_iles
maizes175115733ma_izes
majors154511093ma_jors
makes115336853ma__kes
makos116518363ma_ko_s
malates93522603malates
males75049793ma__les
malices114316623malices
malines93625603malines
mallees93315973mallees
mallows123714323mallows
maltols939403maltols
maltose939783maltose
maltoses1039853maltoses
mamas95930773mam__as
mamba116317523mamb__a
mamboing1535973mamboing
mamey125418833mam__ey
mameys13449523mam_eys
mamie95826003mam_ie_
mamluks1543313mamluks
mammae94613213mammae_
mammals10389273mammals
mammas94616403mam_mas
mammee94417853mam_mee
mammer94218863mam_mer
mammers104615693mammers
mammet94319253mam_met
mammets103911113mammets
mammey124310893mam_mey
mammeys13376723mammeys
mammie94313783mammie_
mammock1664393mammock
mammocks1763893mammocks
mammon939643mammo_n
mammoth1344983mammoth
mammoths1442853mammoths
mamzer19459833mam_zer
mamzers20409163mamzers
manages103418963manages
manches143818623manches
maneges103612143maneges
manes76648953ma__nes
manges94628943ma_nges
mangles104021463mangles
mangos94319333mango_s
manholes13311183manholes
maniocs113611443maniocs
mannose939243mannose
mannoses1039083mannoses
manors84420883ma_nors
manos74933613ma_no_s
manropes1237913manropes
manses84225513ma_nses
mantes84430783ma_ntes
mantles94820703mantles
manures9313353manures
maples104819423ma_ples
marabous1249063marabous
marble104219103marble_
marbled123212113marbled
marbler113511673marbler
marblers12319233marblers
marches143921173marches
mares76457633ma__res
marges94525713ma_rges
marines93928013marines
marmites122212793marmites
marmots11311513marmots
maroons92615553maroons
marques182610863marques
marries93825283marries
marrons93216973marrons
marrows122911813marrows
marses84827113ma_rses
marshes123615373marshes
mascons113411583mascons
mascots113910343mascots
mashes115030003ma_shes
mashies12318253mashies
masons83916513ma_sons
masques18239363masques
masses85028713ma_sses
matches143219783matches
mates75251363ma__tes
matres84522233ma_tres
matrons93517633matrons
mattes85624533ma_ttes
matures9314303matures
matzohs2134373matzohs
matzos1749263matzo_s
mauves113811553ma_uves
mavies114923193ma_vies
mavises122812993mavises
maxes145629533ma__xes
maxixes1535253maxixes
maybe12311133mayb_e_
mayors115714193ma_yors
mayos105521933ma_yo_s
maypoles1545993maypoles
maypops16104453maypops
mazes165632173ma__zes
member12258853memb_er
members13258603members
memes94927703mem__es
memos95719113mem_o_s
mimbars1397383mimbars
mimeoed1235193mimeoed
mimeos104511543mimeo_s
mimes95732023mim__es
mimeses1139073mimeses
misdoes10312493misdoes
mojoes15399523m_ojoes
momes95134473mom__es
mommies103912273mommies
momuses1159263momuses
mongoes103415713mongoes
mottoes93412193mottoes
mumble123614343mumble_
mumbled143010763mumbled
mumbler133510913mumbler
mumblers14328763mumblers
mummies103812843mummies
mungoes103510463mungoes
nabes75427093na_b_es
nabobs10388213na_bobs
names74833363nam__es
nombles113212343nombles
numbles113814273numbles
oboes75717713__oboes
ombres103911143_ombres
rabbies113416053rabbies
rabbles113517973rabbles
rabies85226023ra_bies
ramblas112710263ramblas
ramble104519973ramble_
rambled123913513rambled
rambler113313263rambler
ramblers124010373ramblers
ramees84620893ram_ees
ramies84630463ram_ies
ramose8314403ram_ose
ramous8417103ram_ous
rampoles1238893rampoles
ramrods1036583ramrods
ramsons939563ramsons
rumbles114018393rumbles
sabes76437463sa_b_es
sables85026693sa_bles
sabots8314693sa_bots
sabres85520863sa_bres
salvoes102811313salvoes
sambaed1238303sambaed
sambals115213483sambals
sambars115113843sambars
sambas104219263samb_as
sambo95118013sambo__
sambukes1644193sambukes
samburs11369343samburs
samites93118713samites
samples112815453samples
sawbones13126643sawbones
shambles15159043shambles
shmoes114612093shm_oes
sjamboks2342233sjamboks
spambots1443313spambots
syboes1139343_syboes
symbols1435523symbols
tabbies112913503tabbies
tabes76033923ta_b_es
tables84524883ta_bles
taboos83815423ta_boos
tabors84517093ta_bors
tamales93216143tamales
tambacs13219363tambacs
tambaks15218153tambaks
tambour1136343tambour
tambours1255863tambours
tamburs11288603tamburs
tames75242013tam__es
tamises92715973tamises
tammies113814683tammies
tampons112711553tampons
timbres11249343timbres
tomboys1435703tomboys
tumbles113816023tumbles
umbles103817493_umbles
umbones1138013_umbones
umbos94613073_umbo_s
vamoose1235863vamoose
vamooses1345523vamooses
vamose1159283vam_ose
vamoses1239143vamoses
wabbles144013993wabbles
wamble134415753wamble_
wambled153610753wambled
wames106432803wam__es
wamuses1237023wamuses
warbles123215563warbles
wimbles143010853wimbles
yabbies14279643yabbies
yobboes1445583yobboes
zombies2037993zombies

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.1431249587.4
2DLD Change Limit1340274278.76315294.6
3Display Results4274270.1562737.2
 (SQL Overall)1786914279.06219718.7
 
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.