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

269 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
bemoans113825(None) 
bemeans1148741bemeans
bemoan10310251bemoan_
beans75734692be__ans
bedpans1237172bedpans
begroans1145502begroans
belons84119412belo_ns
bemas96424282bem_a_s
bemean10410682bemean_
bemoaned1335552bemoaned
bemocks1735372bemocks
betons84919552beto_ns
bezoars1836792bezoars
demeans1039722demeans
demons94917722demo_ns
lemans85316392lem_ans
lemons84415052lemo_ns
moans74624372__moans
reloans7313132reloans
remans84823002rem_ans
aeons57624653ae_o_ns
atmans84413963atm_ans
baboons113211083baboons
bacons104917583baco_ns
banians9312033banians
bans66555143b___ans
banyans1237913banyans
barons85025383baro_ns
batons85519423bato_ns
beacons11410733beacons
beads85429503be__ads
beaks115326623be__aks
beams95328173be__ams
bean66443863be__an_
beano75421553be__ano
beanos85516513be__anos
bears75739043be__ars
beats76042243be__ats
beaus75127113be__aus
bebops1237623bebo_ps
becaps123811403be_caps
beckons15279143beckons
becloaks1644933becloaks
beclowns1544683beclowns
becomes132911963becomes
bedamns1235733bedamns
bedgowns1543113bedgowns
bedlams1237053bedlams
bedouins1145513bedouins
bedpan1137583bedpan_
beduins1039123beduins
beflags1355493beflags
befogs1246453befo_gs
befools1236433befools
befouls1236053befouls
began86319573be_gan_
beggars11378223beggars
begins94415303be_gins
beglads11127263beglads
begone9512133bego_ne
begroan1036103begroan_
beheads1338523beheads
beholds1336423beholds
behoves15177353behoves
behowls1534443behowls
belays114313853be_lays
beldams1237053beldams
beleaps1138053beleaps
belgas9311713belga_s
belon73924113belo_n_
belong93411043belo_ng
belongs10408223belongs
belows114614183belo_ws
bema85825253bem_a__
bemadams1543383bemadams
bemata10411693bem_ata
bemeaned1335783bemeaned
bemires113212833bemires
bemists113410703bemists
bemixes18338653bemixes
bemoaning1435953bemoaning
bemock1636173bemo_ck
bemuses1139293bemuses
bendays13327513bendays
bens65945703be___ns
benzins1838693benzins
benzoins1945573benzoins
berlins93216013berlins
besmears1234543besmears
besmokes16406363besmokes
besoms105712733beso_ms
besots86415453beso_ts
betas75528763be_ta_s
bethank1666273bethank
bethanks1765313bethanks
bethorns1337323bethorns
betokens14324573betokens
beton76022063beto_n_
betony114211583beto_ny
betrays12127823betrays
bettas84913923betta_s
bevors111610343bevo_rs
beworms1437933beworms
bewraps14135403bewraps
bewrays15145113bewrays
beyond1237073beyo_nd
beyonds1335063beyonds
bezant17814543be_zant
bezants1877343be_zants
bezoar1736913bezoa_r
bezzant1746893bezzant
bezzants1843643bezzants
bicorns11338763bicorns
bimahs13508303bim_ahs
bimas95521743bim_a_s
biomass1155993biomass
bisons83914373biso_ns
bloats85215763b_loats
boars75229603b__oars
boas66150833b__oa_s
boats75635153b__oats
bogans95714813b_ogans
bohemians1643443bohemians
boons75031913b__oons
borons85520543boro_ns
bosons85016653boso_ns
brans75437433b__rans
brechans1547413brechans
broads94515153b_roads
brogans1049663brogans
bromals1139743bromals
bromins112513783bromins
browns116415633b_rowns
bumboats1445183bumboats
bumkins15318013bumkins
burans85019303b_urans
byroads1335293byroads
daemons10269233daemo_ns
damans94715983dam_ans
deans66131393de__ans
dedans85915073de_dans
deewans11306903deewans
defoams1336193defoams
dehorns11428363dehorns
demand104314253dem_and
demands114311413dem_ands
demean9510563demean_
demobs11429483demo_bs
demoing11311753demoing
demon86520313demo_n_
demos86022993demo__s
demoses103815833demoses
demotes104717673demotes
demount1049743demount
demounts1135473demounts
desmans1039003desmans
devons104512253devo_ns
dewans105215143de_wans
ebons74316093_ebo_ns
elans55527753_e_lans
eloins65419383_eloins
embank14346553_embank
embanks15295703_embanks
embars103812883_embars
embays131408333_embays
emodins1039433_emodins
emotes84620283_emotes
eons46638713_e_o_ns
exons125813343_exo_ns
felons93615763felo_ns
gemotes103712143gemotes
gemots93712153gemo_ts
genoas74013623genoa_s
germans1079473germans
groans74815063_groans
hemins113417573hem_ins
heroins103518013heroins
herons94820543hero_ns
hetmans12187593hetmans
hexosans1844123hexosans
humans112312433hum_ans
jeans126022113je__ans
jetons134512613jeto_ns
koans95818623__koans
leans55536253le__ans
leman75622603lem_an_
lemmas10349163lemma_s
lemon75618183lemo_n_
lemony11419553lemo_ny
limans84816303lim_ans
loans56026463__loans
mans66354553__m_ans
means75831233__means
medians103214213medians
melons84117713melo_ns
memoirs1136803memoirs
memos95719113memo__s
mesons83215843meso_ns
messans92710463messans
moan65832023__moan_
moas65545343__moa_s
moats75827643__moats
monas74732153__monas
mons68152263__mo_ns
moons75331003__moons
morns75527443__morns
nemas75321573nem_a_s
neons55818683ne_o_ns
peans75437643pe__ans
pecans101515833pe_cans
pechans14810503pechans
pekans121710553pe_kans
pemicans1447043pemicans
peons75327183pe_o_ns
ramonas9311093ramonas
reboant9315093reboant
recoals94214633recoals
recoats92616643recoats
recoins94019243recoins
recons84922993reco_ns
redans75421023re_dans
redons75222183redo_ns
rejoins143111383rejoins
reloads8911313reloads
reloan6415693reloan_
remains94117913remains
reman75730153rem_an_
remand95618963rem_and
remands104914883rem_ands
remaps105012873rem_aps
remnant9312643remnant
remnants1036843remnants
remolds10299703remolds
remoras9314073remoras
remotes94521613remotes
remount9512283remount
remounts1036373remounts
removals1345653removals
removes124514713removes
renowns10277833renowns
replans92814943replans
resoaks1148973resoaks
roans54926443__roans
romans84620243rom_ans
sampans112411003sampans
seawans10379943seawans
sedans74816093se_dans
seitans73312303seitans
semens84616973sem_ens
sermons9311783sermo_ns
setons64620173seto_ns
sewans95215903se_wans
sextans14349273sextans
simians959203simians
simoons937943simoons
somans84619303som_ans
tampans113310983tampans
tenons62916603teno_ns
teopans939203teopans
tomans85419133tom_ans
tympans14236813tympans
unmans82211993unm_ans
vegans103910853ve_gans
weans85326743we__ans
womans114613653wom_ans
xenons132710483xeno_ns
yeans86624883ye__ans
yeoman1138823yeoman_
zymosans2243233zymosans

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.420425454.8
2DLD Change Limit1340272698.81315207.9
3Display Results2692690.1561724.4
 (SQL Overall)1786912699.38919032.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.