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 “bedlam” 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
bedlam114927(None) 
bedlamp1464511bedlamp
bedlams1237051bedlams
beldam11410111beldam
beam86939232be__am
becalm1239202becalm
bedamn1137812bed_amn
bedim10313832bed_im
bedlamps1543662bedlamps
bedpan1137582bedpan
beflag1265882beflag
beglad10138462beglad
belay105021522be_lay
beldame1237232beldame
beldams1237052beldams
blam86131702b__lam
medlar93010462medlar
pedlar93311272pedlar
abeam9316533abe__am
baalim1038473baalim
badland1147653badland
badly114918763badl_y
badman113813843badman
balas76937213b_alas
ballad94315323ballad
balm85534203b_al_m
balsam105612233balsam
bam78560143b___am
bantam10314063bantam
bead75937923be__ad
beadle93314683beadl_e
beadles103414733beadles
beadman12249153beadman
beak106534383be__ak
beams95328173be__ams
beamy126218573be__amy
bean66443863be__an
bear66844643be__ar
beat66168303be__at
beau66137273be__au
becalms1335743becalms
became123213163be_came
becap114315053be_cap
becharm1636843becharm
beclamor1484303beclamor
beclasp1335263beclasp
becloak1545043becloak
beclog1136863beclog
bed67950623bed___
bedamns1235733bed_amns
bedaub1146033bedaub
bedbug12193973bedbug
bedded115114073bedded
bedder104215793bedder
bedeck1536213bedeck
bedel84219403bed_el
bedell93610043bedell
bedells10379363bedells
bedels94015273bedels
bedeman12168843bedeman
bedew114513043bed_ew
bedews12398943bedews
bedfast1346413bedfast
bedframe1643023bedframe
bedims1149593bedims
bedlamite1443193bedlamite
bedless1039703bedless
bedlike14369533bedlike
bedmate1239433bedmate
bedpans1237173bedpans
bedplate1346223bedplate
bedrail1037253bedrail
bedrape1277693bedrape
bedrid1039943bedrid
bedroom1247083bedroom
bedrug10164953bedrug
beds75937783bed__s
bedsit9312843bedsit
bedtime1236973bedtime
bedu75923693bed__u
beduin939713beduin
bedumb1335063bedumb
bedward1497473bedward
bedwarf16106463bedwarf
befall114410643befall
beflags1355493beflags
beflea1147123beflea
befleas1236973befleas
begall92610723begall
began86319573be_gan
begat86629723be_gat
beggar10328223beggar
beglads11127263beglads
beglamor1383193beglamor
begloom1255243begloom
begrim11118333begrim
begum105213923be_gum
behalf14310953behalf
behead1239923behead
bel57148463be_l__
belady12489933be_lady
belaud939133be_laud
belays114313853be_lays
belch124415503be_lch
beldames1336803beldames
beleap10410283beleap
belga8313233be_lga
belgas9311713belgas
belie75630383be_lie
bell66237183be_l_l
belle75827833be_lle
belled94626193belled
belles85325993belles
bellman1137183bellman
bellow114213353bellow
bells76432163be_lls
belly104625493be_lly
belon73924113be_lon
below104617193be_low
bels66142493be_l_s
belt65754033be_l_t
belts75931163be_lts
bema85825253be_ma_
bemadam1445773bemadam
bemas96424283be_mas
bemean10410683bemean
bemoan10310253bemoan
bename103316073be_name
benday123810813benday
benzal1739643benzal
berlin83116373berlin
berm86732753be__rm
beseem1069083beseem
beshame1447483beshame
beslime1146833beslime
besom95716973be_som
beswarm1445783beswarm
beta66234133be_ta_
betas75528763be_tas
betray111511443betray
betta74916843betta_
bettas84913923bettas
beworm1339993beworm
bewrap13157053bewrap
bewray14147733bewray
beylic1337823beylic
beylik1545883beylik
bezoar1736913bezoar
blab86629133b__lab
blae66134643b__lae
blah98625063b__lah
blame95625493b__lame
blams95023853b__lams
blat66550953b__lat
blaw97026723b__law
blellum1143663blellum
bola66035563b_ola_
bolar75123473b_olar
bolas74733763b_olas
boyla102912363boyla_
boylas113011723boylas
bream95121813b_ream
brecham1646833brecham
bulla74620563bulla_
bullae83416163bullae
burlap1098353burlap
byelaw1444253byelaw
bylaw13408603b_ylaw
byplay1634193byplay
cedar84014323ced_ar
cedula977643cedula_
cedulas1058503cedulas
cella75420313cella_
cellae84915933cellae
cellar84514983cellar
celom9515693ce_lom
clam86332293__clam
dam67457043__d_am
declaim1247363declaim
declaw1266703declaw
dedal75719023ded_al
defoam1238563defoam
delay94820633de_lay
dewlap1264843dewlap
dram75832003__dram
eclat7523603_eclat
edema8610553_edema
elan46734243_e_lan
elm57531743_e_l_m
exam132514623_e_xam
fella84918653fella_
fellah124910773fellah
fellas95116963fellas
ferbam1339003ferbam
flam96333293__flam
fullam1138363fullam
glam76529343__glam
goddam1145163goddam
headlamp1642853headlamp
helm95530023he_l_m
jetlag1434523jetlag
jetsam15116323jetsam
kalam11315113_kalam
keblah1545313keblah
keddah1534273keddah
kelim11912553ke_lim
lam57666713___lam
madam10316223mad_am
medal86221333med_al
medals94218063medals
media84721713media_
mediad104313713mediad
mediae94217413mediae
medial93819863medial
median94117543median
medias93620783medias
medium113711623medium
medlars10259443medlars
medley1298343medley
oedema936573oedema
pedal86022503ped_al
pedalo93811153pedalo
pedals94316033pedals
pedlars103210213pedlars
pedlary13277543pedlary
pedler93614623pedler
pepla9312863pepla_
peplum12156823peplum
realm75621623real_m
ream65841613re__am
reclad9311873reclad
reclaim1137753reclaim
reclame11411063reclame
redan66125013red_an
redbay1238333redbay
redcap1158493redcap
redear73515173redear
redeem9311533redeem
redia65524483redia_
rediae74221993rediae
redial74923113redial
redias74523603redias
redleg839273redleg
redly94217203redl_y
redraw10269853redraw
redream10107913redream
reflag1098083reflag
relax124817803re_lax
relay84424673re_lay
replan83215823replan
replay113412923replay
reteam83214533reteam
seam66645973se__am
sedan65620423sed_an
sedum84115573sed_um
selah8319613se_lah
seldom939413seldom
slam67737973__slam
team66238653te__am
tedium9269873tedium
tela45532973te_la_
telae54323293te_lae
tesla55612603tesla_
teslas64212173teslas
vela75725543ve_la_
velar85817633ve_lar
vellum1136773vellum
velum10713383ve_lum
webcam1545543webcam

Search took 7 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 Limit1127162695.59620142.2
3Display Results2692690.0932892.5
 (SQL Overall)1786912696.06229477.2
 
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.