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

262 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
mamboed1441762(None) 
mamboes135011821mamboes
ambled115116352_ambled
cameoed1238382cameoed
gambled134112162gambled
gamboled1435872gamboled
hamboned1637002hamboned
jambed184811402jamb_ed
lambed115614782lamb_ed
mambo115215732mambo__
mambos125414492mambo_s
marbled123212112marbled
mimeoed1235192mimeoed
mumbled143010762mumbled
rambled123913512rambled
sambaed1238302sambaed
wambled153610752wambled
abed79734133_a_b_ed
abled86926833_a_bled
abode85518813_a_bode
aboded104912513_a_boded
amazed18519303_amazed
ambeer104511593_ambeer
amber94523203_amb_er
amble95924633_amble_
ambler104916443_ambler
ambles105121853_ambles
ambo88225133_ambo__
ambones11312683_ambones
ambos95321243_ambo_s
ambroid1238863_ambroid
ameboid1277223ameboid
amped104820513_am_ped
amused94412513_amused
arbored103811603_arbored
autoed7712823_autoed
babbled113612863babbled
babied114913503ba_bied
bamboo12310013bambo_o
bamboos1348753bamboos
bammed133913243bam_med
barbed115121313barb_ed
bimboes13498723bimboes
bombed134113873bomb_ed
brambled15316723brambled
buboed113010003_buboed
bumbled144113043bumbled
cabbed135416263ca_bbed
cabled114819873ca_bled
camber124418473camb_er
cambered15128993cambered
camped134720233cam_ped
canoed94618953ca_noed
carboyed1637183carboyed
combed135516543comb_ed
cramboes1436543cramboes
dabbed124416143da_bbed
dabbled133712073dabbled
dadoed9449893da_doed
damaged1257453damaged
dammed124214793dam_med
damned104212913dam_ned
damped124315583dam_ped
daubed104611783daub_ed
daybed13438673dayb_ed
demoed103713443dem_oed
dumbed124012083dumb_ed
embed105014293_emb_ed
embowed15236903_embowed
fabled124216383fa_bled
famed115928343fam__ed
flambeed16324383flambeed
fumbled153710493fumbled
gabbed125216893ga_bbed
gabbled134112453gabbled
gabled105518453ga_bled
gambade1336383gambade
gambe106219213gamb_e_
gambes116318313gamb_es
gambier124711963gambier
gamble115417183gamble_
gambler123612683gambler
gambles124016203gambles
gamboge1335583gamboge
gamboges1435653gamboges
gambol1138223gambo_l
gambolled1543103gambolled
gambols1238593gambols
gambrel1235453gambrel
gamed95126393gam__ed
gammed124216163gam_med
gammoned1444993gammoned
garbed104815663garb_ed
garbled114512803garbled
halloed113314913halloed
haloed104717593ha_loed
hambone1439313hambone
hambones1539673hambones
hammed144116973ham_med
harbored1438633harbored
hoboed124511683_hoboed
humbled153711813humbled
imbed105013633_imb_ed
imbued1136153_imbued
jabbed184213483ja_bbed
jambe165314753jamb_e_
jambes175914053jamb_es
jamboree1944863jamboree
jammed183811503jam_med
jawboned21133553jawboned
jumbled19379963jumbled
kayoed14416903ka_yoed
labored102810243la_bored
lambdoid1443443lambdoid
lamber104418493lamb_er
lambie103213663lambie_
lambier113611633lambier
lambies113015103lambies
lamed85235293lam__ed
lammed113915623lam_med
lamped114017543lam_ped
lassoed8408743lassoed
limbed114513173limb_ed
mabe85733343ma_b_e_
mabes96331533ma_b_es
maced108528693ma__ced
mackled164111913mackled
macled116718113ma_cled
maculed123510053maculed
madded113513553ma_dded
mahoe10315573ma_hoe_
mahoes11313103ma_hoes
mailed95326753ma_iled
maimed114812663ma_imed
majored1735853majored
malfed12369753ma_lfed
malled94626103ma_lled
malposed1344563malposed
malted94819853ma_lted
mamba116317513mamb__a
mambas125716243mamb_as
mamboing1535973mamboing
mamey125418833mam__ey
mameyes14376983mameyes
mamie95826003mam_ie_
mamies104626243mam_ies
mammae94613213mammae_
mammee94417853mam_mee
mammees104411143mammees
mammer94218863mam_mer
mammered12237653mammered
mammet94319253mam_met
mammey124310893mam_mey
mammie94313783mammie_
mammies104314763mammies
mammock1664393mammock
mammocked1941963mammocked
mammon939643mammo_n
mammons1048513mammons
mammoth1344983mammoth
mamzer19459833mam_zer
managed113212603managed
maned86634093ma__ned
mangled113615253mangled
mangoes104316133mangoes
mangold1137203mangold
manhood1338993manhood
manned94418643ma_nned
mantled104113393mantled
manured1039473manured
mapped134015883ma_pped
marble104219103marble_
marbler113511673marbler
marbles114516653marbles
marched153813403marched
marked133921623ma_rked
marled95523163ma_rled
marooned1138563marooned
marred95421043ma_rred
married104715303married
marrowed1445973marrowed
marted94425213ma_rted
mashed125325043ma_shed
masked134316523ma_sked
masoned1039803masoned
massed94421323ma_ssed
masted94025803ma_sted
mastoid10711223mastoid
matched153513963matched
mated85537783ma__ted
matted94521413ma_tted
mattoid1079273mattoid
matured10310033matured
mauled94817823ma_uled
mawed115824743ma__wed
maxed155821193ma__xed
maybe12311123mayb_e_
maybes1339243mayb_es
maybird1543993maybird
mayed115522403ma__yed
mayweed1634163mayweed
mazed175523873ma__zed
member12258853memb_er
membered1535903membered
mimed105622733mim__ed
mobbed137112243m_obbed
mobled113213183m_obled
mooed85123983__mooed
mumble123614343mumble_
mumbler133510913mumbler
mumbles133014433mumbles
mummed104411553mum_med
mummied11327103mummied
mumped133813163mum_ped
nabbed115113613na_bbed
named85223063nam__ed
numbed114111443numb_ed
rabbled123514423rabbled
radioed939673radioed
ramble104519973ramble_
rambler113313263rambler
rambles113118313rambles
rammed113117303ram_med
ramped114617903ram_ped
ramrod936833ramro_d
rawboned14114253rawboned
rumbaed12287493rumbaed
rumbled124514593rumbled
sabbed114518083sa_bbed
sabed86526813sa_b_ed
sabred95916533sa_bred
salvoed11307063salvoed
sambo95118013sambo__
sambos104315193sambo_s
samoyed1335893samoyed
sampled123410783sampled
shambled16156153shambled
sjamboked2541723sjamboked
symboled1644493symboled
tabbed114215363ta_bbed
tabbied12297793tabbied
tabled94020043ta_bled
tabooed10267383tabooed
tabored102810563ta_bored
tabued94310403ta_bued
tambour1136343tambour
tamboured1443783tamboured
tamed85528513tam__ed
tamped114317043tam_ped
tamponed1336023tamponed
tangoed9318833tangoed
tombed113812133tomb_ed
tumbled123412243tumbled
vamoosed1443923vamoosed
vamosed1335923vamosed
vamped144211013vam_ped
wabbled153311443wabbled
wamble134415753wamble_
wambles143714023wambles
warbled133212163warbled
wimbled15298143wimbled
wombed14419233womb_ed

Search took 9 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.1531167915.0
2DLD Change Limit1340272627.92316916.2
3Display Results2622620.0932817.2
 (SQL Overall)1786912628.16921874.3
 
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.