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

117 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
dread7441902(None) 
bread85523111bread
dead65434241d_ead
dreads84115021dreads
dream85120391dream
drear65016901drear
dreed75222841dreed
dryad10477581dryad
oread64619601oread
read55942531_read
tread64821701tread
ahead96817052ahead
area45843392area_
areae55229742areae
areal55928732areal
areas55935772areas
bead75937922_bead
brad75234342br_ad
breads95419202breads
bready124511182bready
break115319402break
bream95121812bream
bred75130972bre_d
breed85526692breed
broad84817692broad
creak115418432creak
cream95721352cream
cred76530882cre_d
creed85727392creed
dad58456162d__ad
dared75935012dare_d
deads75726912d_eads
deaf85838402d_eaf
deal56347412d_eal
dean56039482d_ean
dear55343602d_ear
deed65340902d_eed
delead84112342delead
derat65044082derat
deray95024182deray
died66137852die_d
dorsad8408972dorsad
drab76226452dr_ab
drag64825052dr_ag
dram75832002dr_am
drat56247832dr_at
draw85623012dr_aw
dray85428092dr_ay
dreaded103612022dreaded
dreamed114310632dreamed
dreams94513982dreams
dreamt94615712dreamt
dreamy12509992dreamy
drears74614252drears
dreary104611672dreary
dreck124812802dreck
dree56638322dre_e
drees65628522drees
dreg66821652dre_g
dregs76114862dregs
dreidl835232dreidl
drek96321092dre_k
dreks105714752dreks
dress65319832dress
drest65530342drest
drew86221672dre_w
dried75321382dried
droid74218542droid
druid74111322druid
dryads11436622dryads
duad66521412d_uad
dured75025402dure_d
dyad96415452d_yad
dyed96720762dye_d
freak125115242freak
freed95223542freed
fremd115010322fremd
grad66829862gr_ad
great66034242great
greed75125692greed
head87137172_head
ired55131872ire_d
knead10429662knead
lead56038852_lead
mead75531602_mead
orad56031692or_ad
oreads73915772oreads
plead85818462plead
preed85128122preed
rad47662002_r_ad
readd74617132_readd
reads64835272_reads
ready94821502_ready
real45750292_real
ream65841612_ream
reap65934742_reap
rear45644552_rear
red46755802_re_d
redd66323172_redd
reed55549622_reed
rend56136572_rend
reread71715432reread
road56332112_road
spread9312532spread
stead65520272stead
thread105011092thread
trad55630912tr_ad
treads74817922treads
treat56240352treat
treed65626732treed
trend64817452trend
triad65217722triad
unread73412672unread
urea46528062urea_
ureal56722682ureal
ureas55826012ureas
wreak125513272wreak

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.310576422.6
2DLD Change Limit538001171.39038705.0
3Display Results1171170.0333545.5
 (SQL Overall)1786911171.733103110.8
 
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.