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

216 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
peerage108980(None) 
peerages1189891peerages
average1158852average
beverage1445142beverage
enrage72715072_enrage
keelage1236182keelage
leverage1285392leverage
meterage1147932meterage
overage11514052overage
peage84723572p_e_age
peerie83617892peer_ie
pelage9515362p_elage
peonage1048722peonage
petrale9312622petrale
prerace11414122prerace
presage10312292presage
seepage1037542seepage
sewerage1245512sewerage
steerage946832steerage
teenage8108052teenage
acerate92818913acerate
acreage1037843acreage
aerate64830553_aerate
ameerate1039633ameerate
amperage1347743amperage
averaged1356213averaged
averages1249183averages
barrage10710843barrage
bedrape1277693bedrape
berake124216083_berake
berate84729023_berate
bereave1258353bereave
beverages1595223beverages
borage93917013_borage
brewage1347183brewage
cerate84829463_cerate
courage10310993courage
coverage1438733coverage
creepage1344343creepage
deaerate9314173deaerate
defrag1136463defrag_
defrags1236193defrags
degage92711383_degage
degrade10229903degrade
demerge11168023demer_ge
deprave1337073deprave
derange939813_derange
derate74531233_derate
deterge9118463deter_ge
eerie55228533_eer_ie
emeerate10410103emeerate
emerge91510463emer_ge
encage93713503_encage
engage82812103_engage
enraged93511783_enraged
enrages83114853_enrages
epergne1046143epergne
erase54925493__erase
federate12310883federate
ferrate103014043ferrate
ferriage1245463ferriage
forage104617003_forage
garage8314513_garage
generate9312903generate
herbage1337003herbage
interage9314493interage
iterate71119113iterate
keelages1335743keelages
layerage1244963layerage
leafage1194573leafage
leakage1235003leakage
leveraged1463783leveraged
leverages1365663leverages
meltage1037953meltage
menage93216543_menage
merge84523693_mer_ge
message1037833message
metage93114453_metage
meterages1248183meterages
mirage92313653_mirage
moorage1038743moorage
operate9615733operate
outrage82616893outrage
overaged13511673overaged
overages12513833overages
overate10620963overate
overawe13511463overawe
package16128013package
page76036103p___age
parade94720643p_arade
parae76335703p_ara_e
parge85831853p_ar_ge
passage1039803passage
pawnage1335873pawnage
peace95026083p_e_ace
peag75431343p_e_ag_
peages94321853p_e_ages
peags86122843p_e_ags
pease75231113p_e_ase
pectase112410363pectase
pectate112214693pectate
pedate93117763p_edate
pederast1158593pederast
peeing94618083peeing_
peelable1238553peelable
peer66238353peer___
peered93819493peer_ed
peeress939503peeress
peeries93623023peeries
peering103520353peering
peers75130273peer__s
peery105719443peer__y
peeve104915253pee__ve
peewee11311963pee_wee
pelages10714613p_elages
pelerine10313013pelerine
peltate92013773peltate
penetrate1149233penetrate
pennae84314033penna_e
penname11328553penname
pennate93314033pennate
pentane9415743pentane
peonages1138473peonages
percale11314093percale
perdie94718513p_erdie
perdue93912633p_erdue
pere66450263p_er__e
perea75026443perea__
perigee101113393p_erigee
perorate10417923perorate
perse75429523p_er_se
peruke123210393p_eruke
peruse84016843p_eruse
pervade1337023pervade
pesade9311103p_esade
petrales10312983petrales
phage115113673p__hage
phenate12412203phenate
phorate12413363phorate
phrase11109903p_hrase
picrate112014143picrate
pierce104010393pier_ce
pierogi1054723pierogi
pilferage1542603pilferage
pillage103412603pillage
pipage1199143p_ipage
pipeage1236203pipeage
pirate82322883p_irate
plage84520403p__lage
please84315733ple_ase
pledge10469493ple_dge
pleurae945863pleura_e
plumage1245503plumage
portage103013643portage
porterage1245763porterage
postage103214853postage
potage92715903p_otage
pottage103310603pottage
prase76128753p__rase
prate75135983p__rate
preaged11612333pre_aged
prebade12310283prebade
prebake1539093prebake
predate10616893predate
preface14510923preface
prefade1339013prefade
pregame1239553pregame
prelate9519693prelate
premade12311443premade
prename11412643prename
prepare111913623prepare
prepave14228873prepave
presaged1238803presaged
presager1138443presager
presages11312203presages
presale9416353presale
pretape113511623pretape
primage12169143primage
prorate9418733prorate
puerile9310093puerile
purge85324603p_ur_ge
rage55742353___rage
recrate92621663recrate
reengage1045213reengage
reframe1239393reframe
regrade92612033regrade
regrate82618663regrate
reimage1037913reimage
remerge10148923remer_ge
restage83316193restage
retrace91417343retrace
seepages1137283seepages
selvage1136553selvage
septage1078403septage
serape84818413_serape
serfage1138403serfage
serge64727473_ser_ge
serrate73017543serrate
sewage10310733_sewage
sewerages1345363sewerages
steerages1046493steerages
storage8310473storage
teenaged10105133teenaged
teenager9115293teenager
tentage81010643tentage
terrace93311843terrace
terrae62915213terra_e
terrane72814233terrane
thenage11107843thenage
umbrage1236723umbrage
underage101012273underage
venerate11312903venerate
ventage11109623ventage
verge93419843_ver_ge
waterage1248663waterage
webpage1543133webpage

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272166.70319995.1
3Display Results2162160.0802700.0
 (SQL Overall)1786912167.18924856.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.