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

325 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
bled7572931(None) 
abled86926831abled
baled85436441baled
bed67950621b_ed
bleb85425221bleb
bleed85019801bleed
blend85317451blend
blet66247671blet
blew94722431blew
blued84520321blued
bred75130971bred
fled85429771fled
gled65631141gled
led46254551_led
pled75231431pled
sled55334371sled
abed79734132abed
able66340532able_
abler75624312abler
ables75935542ables
aced79540882aced
aged67334252aged
ahed89536252ahed
ailed66240282ailed
ale36572342ale_
alec66430062alec
alee46652322alee
alef76340692alef
ales47067102ales
ambled115116372ambled
aped78538152aped
awed88436032awed
axed128829612axed
axled135315812axled
baaed85218162baaed
bad67763152b_ad
bade75140882bade
bailed94726652bailed
baked126130772baked
bald76432902bald
balded105417512balded
bale66353842bale_
baler75635272baler
bales76250082bales
balked135219412balked
balled94926892balled
band76740912band
baned85436352baned
bard75648862bard
bared85144482bared
based85331582based
bated85935532bated
baud74928422baud
bawd105520842bawd
bawled124415692bawled
bayed115423022bayed
be47948942b_e_
bead75937922bead
beds75937782b_eds
bedu75923692b_edu
bee56262402b_ee
beedi8711662beedi
beef96233682beef
been65335782been
beep85931212beep
beer65635992beer
bees65453382bees
beet66457542beet
beg65944132b_eg
bel57148462b_el
belied95022162belied
bell66237182bell
belled94626182belled
bels66142492bels
belt65754032belt
belted94020632belted
ben56554922b_en
bend76435262bend
bes56557432b_es
bet58376672b_et
bey86645422b_ey
bid67751792b_id
bide76041482bide
bided95424962bided
bield84614652bield
bier65531832bier
biked125320032biked
bile66147182bile_
biles75542142biles
bilged105513182bilged
bilked134012942bilked
billed94224902billed
bind76234512bind
biped104718832biped
bird76128322bird
birled94416992birled
blab86629132blab
blade85923332blade
bladed104717762bladed
blae66134642blae
blah98625062blah
blam86131702blam
blamed116017952blamed
bland85320452bland
blared95018242blared
blat66550952blat
blaw97026722blaw
blawed124713892blawed
blazed184314712blazed
bleak115915382bleak
blear75918682blear
bleat75737002bleat
blebs96416152blebs
bleeds95211592bleeds
bleep95013452bleep
blende95413442blende
blends96012882blends
blent76230952blent
bless75917812bless
blest76431722blest
blets75324942blets
blin67228172blin
blind86319322blind
blip88322772blip
blob86027092blob
bloc85023272bloc
blog75723822blog
blond85618372blond
blood85319522blood
blot65842322blot
blow95827192blow
blowed125016692blowed
blub85324872blub
blue65328462blue
bluer74918492bluer
blues75127042blues
bluet75631192bluet
bluey104817052bluey
blumed114313642blumed
blur66020532blur
bod67055542b_od
bode75838752bode
boded95124962boded
boiled95020952boiled
bold75432812bold
bole66448692bole_
boles75448602boles
bolled94722652bolled
bolted94617802bolted
bond75334362bond
boned85133242boned
booed85127272booed
bored85034302bored
bowed114533422bowed
bowled125018132bowled
boxed154318612boxed
brad75234342brad
bread85523112bread
brede85520502brede
bree67241262bree
breed85526692breed
bren65629562bren
brew95023562brew
bud67041272b_ud
bugled104918132bugled
bulbed114312772bulbed
bulged105117122bulged
bulked134216742bulked
bulled94626492bulled
bund75530662bund
burd75534262burd
burled94825382burled
bused85624492bused
butled94818602butled
bye86134592bye_
byes95230532byes
byrled12437172byrled
cabled114819872cabled
clad76225822clad
clef97028182clef
clew95520572clew
clod76124612clod
clued84917682clued
coed77140542coed
coled85540752coled
cred76530882cred
cued76329562cued
deed65340902deed
deled75326542deled
died66137852died
doled75430912doled
dyed96720762dyed
ebbed104111002ebbed
ed38645182__ed
eked96718022eked
eld46733792el_d
exed125420592exed
eyed86623232eyed
fabled124216382fabled
fed76548352_fed
feed84538902feed
filed95331902filed
flea75628492flea
flee76238792flee
flew105824252flew
flex146123472flex
fley106626852fley
flied96519432flied
flued95021252flued
gabled105518452gabled
gaed66031512gaed
ged57044532_ged
geed65435502geed
geld65828432geld
gied64631982gied
glad65624012glad
glede75517832glede
gleds75417892gleds
glee55239062glee
gleed75320572gleed
gleg66219802gleg
glen56027202glen
gley85724652gley
glued75118362glued
haed86338582haed
haled95335822haled
heed86437602heed
held85330402held
hied85434042hied
hoed87837982hoed
holed95634132holed
hued86925852hued
iced78721892iced
idled74915212idled
ilea45931462ilea
ilex115822032ilex
ired55131872ired
isled64615992isled
jeed125428502jeed
lad48165702_lad
lea37660182_lea
lead56038852_lead
lee36068142_lee
leg46446112_leg
lei36846382_lei
lek75640302_lek
lend56233672_lend
les35663072_les
let36481472_let
leu36047402_leu
leud57223422_leud
lev66139422_lev
lewd85716592_lewd
lex107943822_lex
ley66246812_ley
lez125541312_lez
lid47453512_lid
lied55838092lied
med66146742_med
meed74934702meed
meld75830472meld
mobled113213182mobled
muled85824432muled
naled65525052naled
need54934152need
ogled75915962ogled
ohed87825182ohed
oiled64429472oiled
old47033462ol_d
ole37155212ole_
olea46532722olea
oleo46630482oleo
oles46453472oles
oped76230152oped
owed86833872owed
paled85538722paled
ped66751522_ped
peed76239182peed
pied75035362pied
piled85232992piled
plea66830602plea
plead85818462plead
pleb86123812pleb
plew97222812plew
plex137321372plex
plied85118592plied
plod76723272plod
poled84934842poled
puled84926522puled
red46755802_red
reed55549622reed
riled65833252riled
rued55729792rued
ruled65822522ruled
seed55549482seed
shed86536152shed
sleds64418852sleds
slew76228232slew
slid55828982slid
slued64220512slued
sned56026052sned
soled65835172soled
sped76031492sped
sued56537932sued
tabled94020042tabled
ted46446562_ted
teed55439262teed
tied55535212tied
tiled64832942tiled
toed56137042toed
toled65934922toled
unled64021072unled
used55722822used
veld85323202veld
vied86328632vied
voled95323722voled
waled94330992waled
wed75843622_wed
weed85637512weed
weld84727732weld
wiled95231552wiled
wyled124611842wyled
yeld811423872yeld
ylem9217892ylem
zed135431172_zed

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 Filter178691298720.0602978183.3
2DLD Change Limit298723250.89333451.3
3Display Results3253250.0764276.3
 (SQL Overall)1786913251.029173655.0
 
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.