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

228 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
peonage104872(None) 
peonages1138471peonages
menage93216542me_nage
neonate7311332neonate
nonage7313682_nonage
pawnage1335872pawnage
peage84723562pe__age
peerage1089802peerage
pelage9515362pe_lage
pennae84314032penna_e
penname11328552penname
pennate93314032pennate
personage12226712personage
phonate12411812phonate
potage92715902p_otage
pronate9418872pronate
teenage8108052teenage
apanage1036803apanage
appanage1344083appanage
baronage1147073baronage
bename103316073be_name
bondage1138253_bondage
borage93917013_borage
brokage1436673brokage
buoyage1344293buoyage
carnage10311743carnage
coinage10310553coinage
conge85227593_con_ge
cowage12310663_cowage
degage92711383de_gage
derange939813derange
detonate9311193detonate
donate73619503_donate
dosage82810003_dosage
dotage82711613_dotage
dunnage9175213dunnage
ecotage1036883ecotage
empennage1441943empennage
enate54428143_e_nate
encage93713503_encage
engage82812103_engage
enrage72715073_enrage
espionage1242573espionage
fenagle11197153fe_nagle
flotage1136673flotage
flowage1435723flowage
footage1148833footage
forage104616993_forage
fromage1336753fromage
frontage1296243frontage
helotage1245713helotage
henge94819823he_n_ge
herbage1337003herbage
homage121210603_homage
innage73011573_innage
keelage1236183keelage
leafage1194573leafage
leakage1235003leakage
lemonade1144283lemonade
leone55018823leon__e
leonine7311233leonine
linage7713403_linage
longe66626463_lon_ge
lovage1037353_lovage
manage93818903_manage
melange1038363melange
meltage1037953meltage
menace103216943me_nace
menages103615393me_nages
message1037833message
metage93114453me_tage
montage101211713_montage
moorage1038733moorage
neonates8310063neonates
nonages8313843_nonages
nonwage1137163_nonwage
odonate848403odonate
onager739663__onager
ozonate1646863ozonate
package16128013package
padnag1036073padnag_
padnags1135083padnags
page76036103p___age
parsonage12225583parsonage
passage1039803passage
patronage1264823patronage
pawnages1435313pawnages
peace95026083pe__ace
peag75431343pe__ag_
peages94321843pe__ages
peags86122843pe__ags
pease75231113pe__ase
pectase112410363pectase
pectate112214693pectate
pedate93117763pe_date
peerages1189883peerages
pelages10714613pe_lages
peltate92013773peltate
penal75228373pe_na_l
penance11313443pe_nance
penang92511113pe_nang
penangs10268373pe_nangs
penates93321593pe_nates
pence94924453pe_n_ce
pengo84317593pe_n_go
penile82219603pe_nile
penna74520203penna__
pennames12287783pennames
pennant9312493pennant
pennated11299543pennated
penne75423853pe_n_ne
pennine93712953pennine
penoche1447033penoche
pensee8417313pe_nsee
pentane9415743pentane
peon65635243peon___
peones83821043peon_es
peonies93620153peonies
peonism11611103peonism
peons75327183peon__s
peony105717563peon__y
people10310183peo_ple
percale11314083percale
perorate10417913perorate
personae102410543persona_e
personages13276533personages
personate112111423personate
pervade1337023pervade
pesade9311103pe_sade
petnap1037423petna_p
petnaper1243913petnaper
petnaps1145033petnaps
petrale9312623petrale
pfennige1461823pfennige
phage115113673p__hage
phenate12412193phenate
phonal11310383phona_l
phonated1447893phonated
phonates13410643phonates
phone105621933phon__e
phoneme1446203phoneme
phorate12413363phorate
pillage103412593pillage
pilotage1145373pilotage
pinnace113510313pinnace
pinnae84414643pinna_e
pinnate93613743pinnate
pipage1199143p_ipage
pipeage1236203pipeage
plage84520403p__lage
planate9314573planate
pleonal937243pleona_l
pleonasm1243813pleonasm
plottage1144433plottage
plumage1245503plumage
plunge93811053plun_ge
pomace123111913p_omace
pomade113611333p_omade
ponce95222513p_on_ce
pone65747533p_on__e
pong76231143p_on_g_
ponged105619353p_on_ged
pongee94920193p_ongee
pongs85526343p_on_gs
portage103013643portage
postage103214853postage
potages102416423p_otages
pottage103310603pottage
poundage1244023poundage
prename11412643prename
presage10312293presage
primage12169143primage
probate11414483probate
profane122111863profane
prolate9419793prolate
pronated11414053pronated
pronates10418373pronates
prone75332623pron__e
prong85218113pron_g_
pronged113912393pron_ged
prongs94314483pron_gs
propane112716153propane
prophage1649433prophage
prorate9418733prorate
protege1059153protege
psoae74411623pso_a_e
recoinage1245643recoinage
reengage1045213reengage
reimage1037913reimage
rename82718813re_name
renege72713763re_nege
rennase738713rennase
resonate8513513resonate
restage83316183restage
rootage839043rootage
seepage1037543seepage
selvage1136553selvage
senate63725143se_nate
septage1078403septage
serfage1138403serfage
sewage10310733se_wage
signage937773signage
siphonage1542953siphonage
socage91012123_socage
spinage10289653spinage
sponge939663spon_ge
storage8310473storage
stowage1136703stowage
tannage8209583tannage
teenaged10105133teenaged
teenager9115293teenager
tenace82715693te_nace
tenge65720433te_n_ge
tentage81010643tentage
ternate7415483ternate
thanage11117933thanage
thenage11107833thenage
tonnage8168053tonnage
towage1039833_towage
tunnage8166373tunnage
venae85920983ve_na_e
venge95117983ve_n_ge
ventage11109623ventage
voyage1335473_voyage
wagonage1343293wagonage
webpage1543133webpage
zonae145116443_zona_e
zonate154114923_zonate

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.1401276364.3
2DLD Change Limit1340272287.39018136.3
3Display Results2282280.0802850.0
 (SQL Overall)1786912287.61023481.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.