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

169 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
bleed8501980(None) 
bled75729311bl_ed
bleeds95211591bleeds
bleep95013451bleep
blend85317451blend
blued84520321blued
breed85526691breed
gleed75320571gleed
abled86926832abl_ed
alee46652322alee_
baaed85218162baaed
baked126130772baked
balded105417512balded
baled85436442baled
baleen8613052baleen
balked135219412balked
balled94926892balled
baned85436352baned
bared85144482bared
based85331582based
bated85935532bated
bayed115423022bayed
bead75937922b_ead
bed67950622b__ed
bee56262402b_ee_
beedi8711662b_eedi
beef96233682b_eef
beefed123510872beefed
been65335782b_een
beep85931212b_eep
beeped115313452beeped
beer65635992b_eer
bees65453382b_ees
beet66457542b_eet
belied95022162belied
belled94626182belled
belted94020632belted
bend76435262b_end
bided95424962bided
bield84614652bield
biked125320032biked
bilged105513182bilged
bilked134012942bilked
billed94224902billed
biped104718832biped
blade85923332blade
bladed104717762bladed
blae66134642blae_
blamed116017952blamed
bland85320452bland
blared95018242blared
blawed124713892blawed
blazed184314712blazed
bleak115915382bleak
blear75918682blear
bleared104211252bleared
bleat75737002bleat
bleated104015972bleated
bleb85425222bl_eb
blebs96416152blebs
bleeder10359642bleeder
bleeped12287272bleeped
bleeps10499102bleeps
blende95413442blende
blended114710712blended
blends96012882blends
blent76230952blent
bless75917812bless
blessed10319492blessed
blest76431722blest
blet66247672bl_et
blets75324942blets
blew94722432bl_ew
blind86319322blind
blond85618372blond
blood85319522blood
blowed125016692blowed
blue65328462blue_
bluer74918492bluer
blues75127042blues
bluet75631192bluet
bluey104817052bluey
blumed114313642blumed
boded95124962boded
bolled94722652bolled
bolted94617802bolted
boned85133242boned
booed85127272booed
bored85034302bored
bowed114533422bowed
boxed154318612boxed
bread85523112bread
bred75130972b_red
brede85520502brede
bree67241262bree_
breeds94914882breeds
brees75632552brees
brewed125411872brewed
bulbed114312772bulbed
bulged105117122bulged
bulked134216742bulked
bulled94626492bulled
bused85624492bused
cleek115514912cleek
cleped115114112cleped
clewed1225113202clewed
clued84917682clued
creed85727392creed
deed65340902_deed
deled75326542deled
dreed75222842dreed
feed84538902_feed
fled85429772fl_ed
flee76238792flee_
fleer86020772fleer
flees85828752flees
fleet85932332fleet
flexed17419092flexed
fleyed13408812fleyed
flied96519432flied
flued95021252flued
freed95223542freed
geed65435502_geed
gled65631142gl_ed
glede75517832glede
glee55239062glee_
gleeds84711622gleeds
gleek105315102gleek
glees65027592glees
gleet65532342gleet
gleyed11478152gleyed
glued75118362glued
greed75125692greed
heed86437602_heed
jeed125428502_jeed
kneed104612052kneed
lead56038852_lead
led46254552_l_ed
lee36068142_lee_
leek85331732_leek
leer46239352_leer
lees45455882_lees
leet45957902_leet
lend56233672_lend
leud57223422_leud
lewd85716592_lewd
lied55838092_lied
meed74934702_meed
need54934152_need
peed76239182_peed
plead85818462plead
pled75231432pl_ed
plied85118592plied
preed85128122preed
reed55549622_reed
seed55549482_seed
skeed105018982skeed
sled55334372sl_ed
sleek94619042sleek
sleep74920182sleep
sleet55639132sleet
slewed104815522slewed
slued64220512slued
speed85526622speed
steed66024942steed
teed55439262_teed
treed65626732treed
tweed94915092tweed
weed85637512_weed

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 Limit538001691.59333772.8
3Display Results1691690.0463673.9
 (SQL Overall)1786911691.95291542.5
 
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.