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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
referrers1212537(None) 
deferrers13115151deferrers
preferrers1542981preferrers
referrer11136051referrer_
deferrer12135592deferrer_
deterrers10116592deterrers
inferrers12226582inferrers
preferrer1443892preferrer_
referees111310412refe_rees
referrals1243492referrals
referred1297832referre_d
reformers14246402reformers
reservers12138102reservers
reverers113113152reve_rers
reversers12298482reversers
reverters122710432reverters
conferrers1546453conferrers
defeaters13289103defeaters
defenders1436363defenders
deferrals1343683deferrals
deferred13106363deferre_d
deforcers15265503deforcers
deformers15266533deformers
demergers13146403demergers
demurrers1243713demurrers
deserters10129983deserters
deservers13107293deservers
detergers11147183detergers
deterrer9137013deterrer_
fearers104815273__fearers
ferrels10248623__ferrels
ferrets103111393__ferrets
inferrer11217443inferrer_
jeerers14328923je_e_rers
offerers1434933offe_rers
preferred1555003preferre_d
preservers15115693preservers
rearers74323563r__earers
receivers1436363receivers
recorders12187953recorders
redeemers1244813redeemers
reefers103312593re_e_fers
reekers113613143re_e_kers
reelers73520273re_e_lers
reenters82915303re_enters
refeeds11368973refe__eds
refeels10379693refe__els
refences13311843refence_s
referee101615753refe_re_e
refereed12149693refe_reed
referent112813423refe_rent
referents12259643referents
referral1144403referr_al
referring1338033referring
refers93921083ref___ers
refilters1236103refilters
refiners114713313ref_iners
refires104820313ref_ire_s
reflowers15125983reflowers
reforges12249333reforge_s
reformer13217953reformer_
refreshers16103673refreshers
refries104419733ref_rie_s
refunders1334973refunders
refusers11499273ref_users
refuters11449613ref_uters
rehearsers13273863rehearsers
reheaters122010273reheaters
rejecters18257543rejecters
releasers937323releasers
reletters9138783reletters
remarkers15197283remarkers
remembers1544493remembers
remerges111110203remerge_s
renderers10208093renderers
renegers9248793rene_gers
renewers11238183rene_wers
reorders9198833re_orders
repairers1135283repairers
repealers11278843repealers
repeaters112811993repeaters
repellers11278883repellers
repenters112511553repenters
reporters1139173reporters
requirers18165003requirers
resellers9299933resellers
reserver11119633reserver_
reserves111011983reserve_s
resetters9129463resetters
resorters939693resorters
restorers95110113restorers
retarders10227573retarders
retempers1345023retempers
retirers84311533re_tirers
retorters938773retorters
returners9376553returners
revealers12318243revealers
revelers113414133reve_lers
revellers12319513revellers
revengers1336413revengers
revenuers1235983revenuers
reverer103815833reve_rer_
reveres103621343reve_re_s
reveries112518513reverie_s
reverser113010483reverser_
reverses112513513reverse_s
reverter114812873reverter_
rewarders13226453rewarders
rezeroes1737143rezeroe_s
veneerers1244523veneerers

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411107.09320956.0
3Display Results1101100.0601833.3
 (SQL Overall)1786911107.57623586.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.