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

179 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
dreed7522284(None) 
breed85526691breed
creed85727391creed
deed65340901d_eed
dread74419021dread
dree56638321dree_
drees65628521drees
dried75321381dried
freed95223541freed
greed75125691greed
preed85128121preed
reed55549621_reed
treed65626731treed
agreed84712502agreed
arced88224162arced
armed86324442armed
bleed85019802bleed
bread85523112bread
bred75130972br_ed
brede85520502brede
bree67241262bree_
breeds94914882breeds
brees75632552brees
brewed125411872brewed
cered85227442cered
cred76530882cr_ed
creeds94714772creeds
creek114917392creek
creel75121482creel
creep95218102creep
creped114115722creped
crewed125316562crewed
cried84624292cried
dared75935012dared
darked123919632darked
darned85018482darned
darted84620922darted
dated75530992dated
dawed106222812dawed
dazed165919362dazed
dead65434242d_ead
decreed112710262decreed
dee47665822d_ee_
deeded94615542deeded
deeds75423762d_eeds
deedy104315892d_eedy
deem75432892d_eem
deemed104713062deemed
deep76031882d_eep
deer56739022d_eer
dees56356632d_ees
deet57356582d_eet
degreed10258882degreed
deked115718532deked
deled75326542deled
dere56845902dere_
dewed105020302dewed
diced95824682diced
died66137862d_ied
dieted83115492dieted
diked115024682diked
dined76431992dined
dirked124912272dirked
dirled84514902dirled
dived106321372dived
doled75430912doled
domed95423262domed
doped95326712doped
dosed76626912dosed
doted75227072doted
dowed104632612dowed
dozed165619352dozed
draped105314362draped
drayed115911392drayed
dreaded103612022dreaded
dreads84115022dreads
dream85120392dream
dreamed114310632dreamed
drear65016902drear
dreck124812802dreck
dredged11346892dredged
dreg66821652dr_eg
dregs76114862dregs
dreidl835232dreidl
drek96321092dr_ek
dreks105714752dreks
dress65319832dress
dressed93511872dressed
drest65530342drest
drew86221672dr_ew
drier64423962drier
dries64733672dries
droid74218542droid
droned84616862droned
droved114611642droved
druid74111322druid
dryad10477582dryad
dryer95111462dryer
duded84417132duded
dueled84813662dueled
dueted84113592dueted
duked115218462duked
duped95118322duped
dured75025402dured
durned84113172durned
dweeb1137742dweeb
dyed96720762d_yed
dyked145310952dyked
erred65915672erred
feed84538902_feed
free75940182free_
freer86021242freer
frees86131392frees
fremd115010322fremd
fried95322912fried
geed65435502_geed
gleed75320572gleed
gree56641562gree_
greeds84314282greeds
greedy11518852greedy
greek105915942greek
green65522142green
grees65132472grees
greet65835322greet
greyed114610602greyed
heed86437602_heed
ired55131872ir_ed
irked104510922irked
jeed125428502_jeed
jereed144012072jereed
kneed104612052kneed
kreep114610412kreep
meed74934702_meed
need54934152_need
orbed85516192orbed
oread64619602oread
peed76239182_peed
pree67044732pree_
preen75925052preen
prees75937172prees
premed114617762premed
preyed125313202preyed
pried84426862pried
pureed95017812pureed
read55942532_read
red46755812_r_ed
redd66323182_redd
rede55037682_rede
reded74829122_reded
ree37974072_ree_
reeds65430902_reeds
reedy910020292_reedy
reef74938212_reef
reek85232522_reek
reel45240532_reel
rees45364192_rees
refed93921922_refed
rend56136572_rend
rewed95425452_rewed
rued55729792_rued
screed95718932screed
seed55549482_seed
sered65737292sered
skeed105018982skeed
speed85526622speed
steed66024942steed
teed55439262_teed
tread64821702tread
tree47745812tree_
treen55622752treen
trees55835762trees
trend64817452trend
tried65026912tried
trued65117692trued
tweed94915092tweed
urged75316032urged
urped84615282urped
weed85637512_weed
wried95518562wried

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 Limit538001791.61033416.1
3Display Results1791790.0632841.3
 (SQL Overall)1786911791.98689975.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.