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 “rebred” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
rebred9581635(None) 
reared75930011reared
rebored105015881rebored
rebreed104611071rebreed
bred75130972__bred
cered85227442ce_red
eared65139502_eared
ebbed104111002_ebbed
erred65915672_erred
feared106320432feared
geared85317742geared
heired103813042heired
herbed123513452herbed
inbred93010402inbred
jeered143912792jeered
kerbed13339702kerbed
leered73816222leered
metred95315142metred
neared75119802neared
peered93819492peered
purebred1344252purebred
rared65738322r_ared
reamed94326122reamed
reaped94122452reaped
rearer64928912rearer
rearmed103912822rearmed
reaved104523922reaved
rebated103619702rebated
rebbe9313162rebbe_
rebbes10313532rebbes
rebec94416542reb_ec
rebel73421292reb_el
rebid85121362reb_id
rebind94416932rebind
reblend1036652reblend
rebore86625652rebore_
rebores95319162rebores
rebreeds11426002rebreeds
rebuked14438342rebuked
reburied1137912reburied
recked134821802recked
redded94019552redded
reded74829122re_ded
redrew10309512redrew
redried93714892redried
redyed114611242redyed
reed55549622re__ed
reeded84022562reeded
reefed103816582reefed
reeked113717642reeked
reeled74725532reeled
reeved104118712reeved
refed93921922re_fed
refeed104717622refeed
reffed134712512reffed
refired115116992refired
refried113513872refried
regret73723532regret
regrew10388562regrew
rehired115013152rehired
reined74425522reined
reived104518132reived
relied74926232relied
rended84524102rended
rented74426592rented
repled93319782repled
repped114616722repped
reread71715432re_read
reseed74823292reseed
rested74430782rested
retied75924982retied
retired84620142retired
retread849002retread
retried84419152retried
retted74826312retted
reused75419562reused
revered112819332revered
revved13469722revved
rewed95425452re_wed
rewired115413282rewired
ribbed114014372ribbed
roared75015392roared
robbed113415192robbed
robed85323732rob_ed
rubbed114515082rubbed
rubied94312412rubied
sabred95916532sabred
seared75232842seared
sered65737292se_red
teared75722152teared
trebled1038482trebled
truebred1142752truebred
unbred92613302unbred
veered103612742veered
webbed1436432webbed
webfed1535032webfed

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit82551962.56332208.7
3Display Results96960.0303200.0
 (SQL Overall)178691962.93660862.1
 
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.