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

203 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
beflag126588(None) 
beflags1355491beflags
reflag1098081reflag
beclog1136862beclog
bedlam1149272bedlam
befall114410642befall
beflea1147122beflea
befleas1236972befleas
befog1159012bef_og
beglad10138462beglad
belay105021522be_lay
belga8313232be_lga
defrag1136462defrag
flag87427082__flag
jetlag1434522jetlag
reflags1156952reflags
bag67059223b___ag
balas76937213b_alas
ballad94315323ballad
bead75937923be__ad
beak106534383be__ak
beam86939233be__am
bean66443863be__an
beanbag1243943beanbag
bear66844643be__ar
beat66168303be__at
beau66137273be__au
becalm1239203becalm
becap114315053be_cap
beclasp1335263beclasp
becloak1545043becloak
beclogs1237073beclogs
bedbug12193973bedbug
bedlamp1464513bedlamp
bedlams1237053bedlams
bedpan1137583bedpan
bedrug10164953bedrug
beefalo1244083beefalo
beefing133911473beefing
befalls12349123befalls
befell11428713befell
befit105222663bef_it
befits114711503befits
beflagged1742423beflagged
befleaed1454663befleaed
befleaing1544023befleaing
befleck1843943befleck
befogs1246453befogs
befool1137713befool
before11410153before
befoul1137253befoul
befret11315963befret
beg65944133be___g
begall92610723begall
began86319573be_gan
begat86629723be_gat
beggar10328223beggar
beglads11127263beglads
behalf14310953behalf
behead1239923behead
being84920503be_ing
bel57148463be_l__
belady12489933be_lady
belaud939133be_laud
belays114313853be_lays
belch124415503be_lch
beldam11410113beldam
beleap10410283beleap
belfry1435073belfry
belgas9311713belgas
belie75630383be_lie
bell66237183be_l_l
belle75827833be_lle
belled94626183belled
belles85325993belles
belling103825073belling
bellman1137183bellman
bellow114213353bellow
bells76432163be_lls
belly104625493be_lly
belon73924113be_lon
belong93411043belong
below104617193be_low
bels66142493be_l_s
belt65754033be_l_t
belts75931163be_lts
beluga936233be_luga
bema85825253be_ma_
bemas96424283be_mas
bemean10410683bemean
bemoan10310253bemoan
benday123810813benday
benzal1739643benzal
berg75425543be__rg
berlin83116373berlin
beta66234133be_ta_
betas75528763be_tas
betray111511443betray
betta74916843betta_
bettas84913923bettas
bewig1138903be_wig
bewrap13157053bewrap
bewray14147733bewray
beylic1337823beylic
beylik1545883beylik
bezoar1736913bezoar
bifilar1244043bifilar
biflex1834953biflex
blab86629133b__lab
blae66134643b__lae
blah98625063b__lah
blam86131703b__lam
blat66550953b__lat
blaw97026723b__law
blog75723823b__log
bola66035563b_ola_
bolar75123473b_olar
bolas74733763b_olas
bowleg12369183bowleg
boyla102912363boyla_
boylas113011723boylas
brag75229723b__rag
bulla74620563bulla_
bullae83416163bullae
burlap1098353burlap
byelaw1444253byelaw
bylaw13408603b_ylaw
byplay1634193byplay
cella75420313cella_
cellae84915933cellae
cellar84514983cellar
clag75924573__clag
debag94212303de_bag
declaw1266703declaw
defang1137753defang
defat95426693def_at
defeat103817163defeat
deflate113613943deflate
deflea1037443deflea
defleas1147223defleas
defoam1238563defoam
defog1048523def_og
defrags1236193defrags
defray1337643defray
delay94820633de_lay
dewlap1264843dewlap
eclat7523603_eclat
elan46734243_e_lan
fag76852363__f_ag
fella84918653fella_
fellah124910773fellah
fellas95116963fellas
flab96628353__flab
flags95321283__flags
flak116026173__flak
flam96333293__flam
flan76134183__flan
flap96128703__flap
flat77147823__flat
flaw106326643__flaw
flax147325633__flax
flay106332803__flay
flog85523893__flog
frag85126273__frag
greylag1262553greylag
gulag7310823_gulag
jetlags1533863jetlags
keblah1545313keblah
keelage1236183keelage
lag47862123___lag
medlar93010463medlar
peag75431343pe__ag
pedlar93311273pedlar
pelage9515363pe_lage
pepla9312863pepla_
reclad9311873reclad
redleg839273redleg
refall94314393refall
reflate103516263reflate
reflet94024233reflet
reflew12389453reflew
reflex16359513reflex
refloat10310833refloat
reflow12379653reflow
reflux16315413reflux
refly113914563refl_y
relax124817803re_lax
relay84424673re_lay
replan83215823replan
replay113412923replay
retag63618413re_tag
seabag938473seabag
selah8319613se_lah
slag55934353__slag
stalag7310023stalag
teflon937453teflon
tela45532973te_la_
telae54323293te_lae
tesla55612603tesla_
teslas64212173teslas
vela75725543ve_la_
velar85817633ve_lar
weblog1234223weblog

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162035.19021717.9
3Display Results2032030.0633222.2
 (SQL Overall)1786912035.62631761.6
 
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.