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

206 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
peerages118989(None) 
peerage1089801peerage_
averages1249182averages
beverages1595222beverages
enrages83114852_enrages
keelages1335752keelages
leverages1365662leverages
meterages1248182meterages
overages12513832overages
peages94321852p_e_ages
peeries93623022peer_ies
pelages10714612p_elages
peonages1138472peonages
petrales10312982petrales
presages11312202presages
seepages1137282seepages
sewerages1345362sewerages
steerages1046492steerages
acreages1138383acreages
aerates74627503_aerates
ameerates1149073ameerates
amperages1447683amperages
average1158853average_
averaged1356223averaged
barrages11711093barrages
bedrapes1386963bedrapes
berakes134815773_berakes
berates94126883_berates
bereaves1338283bereaves
beverage1445143beverage_
borages103917163_borages
brewages1436393brewages
cerates95428253_cerates
courages11311393courages
coverages1538833coverages
creepages1444303creepages
deaerates10313643deaerates
defrags1236193defrag_s
degrades11269923degrades
demerges12129503demer_ges
depraves1436873depraves
deranges1039973_deranges
derates84028893_derates
deterges101510093deter_ges
emeerates1149373emeerates
emerges101310883emer_ges
encages103313783_encages
engages92912493_engages
enrage72715073_enrage_
enraged93511783_enraged
epergnes1156713epergnes
erases64425403__erases
federates13310153federates
ferrates113013423ferrates
ferriages1345663ferriages
forages114217283_forages
garages9314113_garages
generates10312723generates
gheraoes1244823gheraoes
herbages1437103herbages
iterates81317823iterates
keelage1236193keelage_
layerages1345303layerages
leafages1244623leafages
leakages1334933leakages
leverage1285393leverage_
leveraged1463783leveraged
meltages1148243meltages
menages103615393_menages
merges94122493_mer_ges
messages1138233messages
metages102714973_metages
meterage1147933meterage_
mirages102213533_mirages
moorages1139053moorages
operates10515413operates
outrages92215933outrages
overage11514053overage_
overaged13511673overaged
overawes14511183overawes
packages17138733packages
pages85235073p___ages
parades104121473p_arades
parges94529543p_ar_ges
passages1139513passages
pawnages1435313pawnages
peaces106324083p_e_aces
peage84723573p_e_age_
peags86122843p_e_ag_s
peases85229473p_e_ases
pectases122411193pectases
pectates122213953pectates
pederasts1255203pederasts
peered93819493peer__ed
peeress939503peer_ess
peeresses1138473peeresses
peerie83617893peer_ie_
peerless1037513peerless
peers75130273peer___s
peeves113814873pee__ves
peewees1236803pee_wees
pelage9515363p_elage_
pelerines11311843pelerines
penates93321603p_enates
penetrates1248723penetrates
pennames12287793pennames
pentanes10316083pentanes
peonage1048723peonage_
percales12313803percales
perches143717953p_erches
perdues103511333p_erdues
peres76246643p_er__es
perigee101113393p_erigee
perigees1189503p_erigees
perorates11417023perorates
perries93226603p_erries
perses85428063p_er_ses
perukes133210113p_erukes
peruses94018163p_eruses
pervades1437353pervades
pesades10310903p_esades
petrale9312623petrale_
phages125213513p__hages
phenates13611583phenates
phereses1348093phereses
phorates13413043phorates
phrases12711463p_hrases
picrates122013213picrates
pierces113411193pier_ces
pierogies1245873pierogies
pilferages1642623pilferages
pillages113012613pillages
pipages1289423p_ipages
pipeages1336423pipeages
pirates93020333p_irates
plages94520153p__lages
pleases94515483ple_ases
pledges113811583ple_dges
pleiades1145753pleiades
plumages1335653plumages
portages112613223portages
porterages1345983porterages
postages112815323postages
potages102416423p_otages
pottages112910453pottages
prases84429023p__rases
prates84633163p__rates
praxes156215183p__raxes
preaged11612333pre_aged
prebakes1639013prebakes
predates11615823predates
prefaces15311063prefaces
prefades1439533prefades
pregames1339003pregames
prelates10418583prelates
prenames12311643prenames
prepares122014163prepares
prepaves15189193prepaves
prerace11414123prerace_
presage10312293presage_
presaged1238813presaged
presager1138443presager
presagers1236943presagers
presales10315263presales
pretapes122811533pretapes
primages13159273primages
prorates10418073prorates
purges94421763p_ur_ges
rages64539443___rages
recrates102420383recrates
reengages1145343reengages
reframes1338993reframes
regrades103212173regrades
regrates92618413regrates
reimages1138373reimages
remerges111110203remer_ges
restages92815773restages
retraces101417273retraces
seepage1037543seepage_
selvages1236513selvages
septages1168263septages
serapes95218103_serapes
serfages1238233serfages
serges74225973_ser_ges
serrates82617023serrates
sewages1139753_sewages
sewerage1245513sewerage_
steerage946833steerage_
storages9311103storages
teenage8108053teenage_
teenaged10105133teenaged
teenager9115293teenager
teenagers10114493teenagers
tentages91011043tentages
terraces102712253terraces
terranes82514433terranes
terrases82111483terrases
thenages12107483thenages
umbrages1336623umbrages
underages11811083underages
veeries102916893veer_ies
venerates12312263venerates
ventages12119773ventages
verges104320183_ver_ges
waterages1349393waterages
webpages1643053webpages

Search took 9 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.420425454.8
2DLD Change Limit1461622067.81318707.5
3Display Results2062060.0932215.1
 (SQL Overall)1786912068.32621461.8
 
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.