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

159 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
bemas9642428(None) 
beams95328171beams
bema85825251bema_
betas75528761betas
bimas95521741bimas
nemas75321571nemas
abomas101113582abomas
agmas85919882agmas
almas76629782almas
amas67746302_amas
atmas75721022atmas
baas66844672b_aas
babas96325732babas
balas76937212balas
bams87044452bam_s
bas58681752b__as
bead75937922be_ad
beads85429502beads
beak106534382be_ak
beaks115326622beaks
beam86939232be_am
beamy126218572beamy
bean66443862be_an
beans75734692beans
bear66844642be_ar
bears75739042bears
beast76338642be_ast
beat66168302be_at
beats76042252beats
beau66137272be_au
beaus75127112beaus
becap114315052becap
becaps123811402becaps
becks135522012becks
beds75937792be_ds
beefs105618562beefs
beeps95320972beeps
beers75628392beers
bees65453382be_es
beets76131442beets
began86319572began
begat86629722begat
begs75733832be_gs
belay105021522belay
belays114313852belays
belgas9311712belgas
bells76432162bells
bels66142492be_ls
belts75931162belts
bemata10411692bemata
bemean10410682bemean
bemeans1148742bemeans
bemist105216962bemist
bemix165011452bemix
bemoan10310252bemoan
bemoans1138252bemoans
bemuse1038942bemuse
bends85628972bends
benes75536232benes
bens65945702be_ns
bents76033692bents
bergs84718042bergs
berks115423122berks
bermes106023002bermes
berms95323662berms
bes56557432be__s
beses75830722beses
bests75932612bests
beta66234132beta_
beths105519222beths
bets67051442be_ts
bettas84913922bettas
beys913829552be_ys
bias64738172b_ias
bima86723842bima_
bimah127013272bimah
bimahs13508302bimahs
blams95023852blams
boas66150832b_oas
bolas74733762bolas
bombs115818822bombs
boras75938302boras
botas75328782botas
bras65746452b_ras
breams104815052breams
bumfs125414052bumfs
bumps115921142bumps
bums85934592bum_s
bunas75126572bunas
buras74736302buras
camas96333532camas
comas95833002comas
cymas126417882cymas
degas75119162degas
demast9517062demast
demes86032692demes
demos86022992demos
dermas94116822dermas
devas96218882devas
dumas85420432dumas
edemas9310502edemas
emes65434662_emes
ems56435492_em_s
emus66821682_emus
enemas8812002enemas
eras45441502_eras
etas46432272_etas
eyas76427432_eyas
femes105626222femes
fems96428702fem_s
fetas85624402fetas
gamas85431372gamas
gems75329112gem_s
getas65421482getas
hemal104419802hemal
hemes105031082hemes
hemps126917332hemps
hems95534942hem_s
keas86337102ke_as
kemps135012522kemps
lamas75532802lamas
leas45954182le_as
leman75622602leman
lemans85316392lemans
lemmas10349162lemmas
limas75627632limas
lumas75622912lumas
mamas95930782mamas
mas58175822__mas
memes94927702memes
memos95719112memos
mems85931502mem_s
mesas76823202mesas
nema65522522nema_
nomas74726412nomas
peas65755062pe_as
pimas94725102pimas
pumas95121562pumas
reams75729622reams
reman75730152reman
remans84823002remans
remap95418102remap
remaps105012872remaps
rems66237722rem_s
seams75731662seams
seas45755272se_as
semes75731582semes
semis74623532semis
simas75727552simas
somas76030372somas
teams75726512teams
teas45851492te_as
temps95417132temps
tepas76521682tepas
texas126514932texas
ulemas888962ulemas
wekas123911792wekas
yeas78638422ye_as
zetas145018162zetas

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.313570897.8
2DLD Change Limit538001591.53035163.4
3Display Results1591590.0334818.2
 (SQL Overall)1786911591.87695251.1
 
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.