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

146 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
referrer1113605(None) 
deferrer12135591deferrer
preferrer1443891preferrer
referred1297831referred
referrers12125371referrers
deferred13106362deferred
deferrers13115152deferrers
deterrer9137012deterrer
inferrer11217442inferrer
preferred1555002preferred
preferrers1542982preferrers
referee101615752refe_ree
refereed12149692refereed
referees111310412referees
referral1144402referral
reformer13217952reformer
reserver11119632reserver
reverer103815832reve_rer
reverser113010482reverser
reverter114812872reverter
beerier93613023be_erier
conferrer1447063conferrer
defeater122611663defeater
defender1337293defender
deferral1244353deferral
deforcer14246903deforcer
deformer14247943deformer
demerger12127373demerger
demurrer1144043demurrer
deserter91211603deserter
deserver12118383deserver
deterger10147593deterger
deterred10137803deterred
deterrers10116593deterrers
eerier64320023_e_erier
fearer94820183__fearer
ferrel92810203__ferrel
ferret93021173__ferret
inferred12248353inferred
inferrers12226583inferrers
jeerer13389933je_e_rer
leerier73111503le_erier
offerer1335543offe_rer
premerger1444903premerger
preserver14127013preserver
rearer64928913r__earer
receiver1337413receiver
recenter102715443recenter
recorder11249633recorder
recurred1137093recurred
redeemer1145323redeemer
reedier83815303re_edier
reefer93314363re_e_fer
reefier102912553re_efier
reeker103715593re_e_ker
reekier113111123re_ekier
reeler63822573re_e_ler
reenter73217793re_enter
refected142311663refected
refeed104717623refe__ed
refeel93913243refe__el
refelled122810173refelled
refence12312233refence_
refenced1438993refenced
refences13311843refences
refer84822143ref___er
referent112813423referent
referrals1243493referrals
referring1338033referring
refers93921083refe_r_s
refilter1137153refilter
refiner105316913ref_iner
refire95419473ref_ire_
refired115116993ref_ired
refires104820313ref_ires
reflower14126843reflower
reforge11259033reforge_
reforged13268703reforged
reforges12249333reforges
reformed14249603reformed
reformers14246403reformers
refresher15104653refresher
refried113513873ref_ried
refries104419733ref_ries
refunder1236503refunder
refuser104912783ref_user
refuter104312193ref_uter
regeared1039433regeared
rehearser12265023rehearser
reheater113413033reheater
rejecter17258943rejecter
releaser839503releaser
reletter81311023reletter
remarker14178493remarker
remember1434623remember
remerge10148923remerge_
remerged12149173remerged
remerges111110203remerges
renderer9239743renderer
reneger8299493rene_ger
renewer10248693rene_wer
reorder8239483re_order
repairer1036783repairer
repealer103210703repealer
repeater102615443repeater
repeller103010403repeller
repenter102813863repenter
reperked15177793reperked
reporter10411423reporter
requirer17156113requirer
reseller83412253reseller
reserve101011203reserve_
reserved121010583reserved
reservers12138103reservers
reserves111011983reserves
resetter81511833resetter
resorter8312183resorter
restorer84813723restorer
retarder9229433retarder
retemper1235183retemper
retirer74715013re_tirer
retorter8410733retorter
returner8397983returner
revealer113110073revealer
reveler104116343reve_ler
reveller112912193reveller
revenger1237303revenger
revenuer1136893revenuer
reverbed14269223reverbed
revere94621253reve_re_
revered112819333reve_red
reverers113113153reverers
reveres103621343reve_res
reverie103615163reverie_
reveries112518513reveries
reverse103913743reverse_
reversed122711613reversed
reversers12298483reversers
reverses112513513reverses
reverted122714713reverted
reverters122710433reverters
rewarder12208233rewarder
rezeroed1835993rezeroed
rezeroes1737143rezeroes
severer103511563seve_rer
veneerer1145033veneerer

Search took 10 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 Filter1786911461620.830215290.4
2DLD Change Limit1461621468.71616769.4
3Display Results1461460.0632317.5
 (SQL Overall)1786911469.60918596.2
 
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.