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

234 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
pottage10331060(None) 
cottage104210571cottage
plottage1144431plottage
portage103013641portage
postage103214851postage
potage92715901po_tage
pottages112910451pottages
cottae84615702cotta_e
cottager11306812cottager
cottages113310492cottages
cottagey14305232cottagey
cuttage10318342cuttage
dotage82711612do_tage
footage1148842footage
frottage1245082frottage
hostage113111232hostage
montage101211712montage
outage72017532_outage
plottages1244242plottages
portaged12228462portaged
portages112613222portages
postages112815322postages
potages102416422po_tages
pottle84416102pott_le
rootage839052rootage
voltage1136862voltage
wattage1186982wattage
aortae65115473aorta_e
apostate1049853apostate
bondage1138253bondage
borage93917013bo_rage
boscage1276533boscage
boskage1465413boskage
bottle84916073bott_le
cartage10312593cartage
coinage10310553coinage
collage102813763collage
cordage11310063cordage
corkage1438373corkage
corsage1039803corsage
cortege1098953cortege
costae85319683costa_e
costate94019273costate
cotta75818573cotta__
cottagers12305383cottagers
cottar84613813cotta_r
cottars94412243cottars
cottas84615573cotta_s
courage10310993courage
cowage12310673co_wage
cowhage1636303cowhage
cuttages11297223cuttages
dockage1535723dockage
dosage82810003do_sage
dotages92311793do_tages
dottle74212503dott_le
ecotage1036883ecotage
floatage1244403floatage
flotage1136683flotage
foggage1334113foggage
foliage1147533foliage
footages1239053footages
forage104617003fo_rage
frontage1296243frontage
frottages1384993frottages
guttae73210583gutta_e
guttate8328903guttate
homage121210603ho_mage
hostages122311693hostages
hotcake1644543hotcake
hottie92514383hott_ie
lockage1436613lockage
lotte54923853lott__e
lovage1037353lo_vage
lyttae994713lytta_e
meltage1037953meltage
metage93114453_metage
mintage101110123mintage
montaged12107763montaged
montages111412183montages
montane91313623montane
moorage1038743moorage
mortgage1244213mortgage
motte75526973mott__e
mottle84116053mott_le
moulage1037903moulage
nonage7313683no_nage
nonwage1137163nonwage
notate63217863no_tate
octane81411633_octane
octave11157343_octave
ohmage1295063_ohmage
onstage838363onstage
ottar54313993_otta_r
ottars64112223_ottars
ottava963683_ottava
outages82317323_outages
outate62923403_outate
outrage82616893outrage
outtake11310793outtake
package16128013package
page76036103p___age
partake1339643partake
passage1039803passage
pattee84323383patt_ee
pattie84020963patt_ie
pawnage1335873pawnage
peage84723573p__eage
pectase112410363pectase
pectate112214693pectate
peerage1089803peerage
pelage9515363p_elage
peltate92013773peltate
pentane9415743pentane
peonage1048723peonage
petrale9312623petrale
pettable121710713pettable
pettle84116053pett_le
phage115113673p__hage
phytane1545443phytane
pillage103412603pillage
pilotage1145373pilotage
pipage1199143p_ipage
pipeage1236203pipeage
pitta75018693pitta__
pittance1246113pittance
pittas86014523pitta_s
plage84520403p__lage
platane93112303platane
plumage1245503plumage
poetise9314043poetise
poetize18310773poetize
poleaxe1656303poleaxe
pomace123111913po_mace
pomade113611333po_made
pontine92419053pontine
portable12313203portable
portal84218463porta_l
portaled11239203portaled
portals94015563portals
portance12310113portance
porterage1245763porterage
postal84317533posta_l
postals93716373postals
postbag1245223postbag_
postbags1345293postbags
postbase1246443postbase
postdate1139653postdate
postface1566123postface
postgame1345523postgame
postie84123963post_ie
postrace12310533postrace
posttax1645533postta_x
posture9313253posture
potable112115363potable
potash1138273po_tash
potato8513433po_tato
potatoes1039943potatoes
potence11711363potence
potentate1197253potentate
pothole12312173pothole
potiche1438043potiche
potlach14106363potlach
potlache15114283potlache
potlike13910123potlike
potline91015233potline
potman102813573potma_n
potpie103412433po_tpie
potsie83916033po_tsie
potstone1039423potstone
potted94624013pott_ed
potteen9319673potteen
potter83926983pott_er
pottered112311663pottered
potterer102310263potterer
potters94024343potters
pottery123011073pottery
pottier93516493pottier
potties93723543potties
potting103720893potting
pottles93816983pottles
potto75320943pott__o
pottos84615873pott_os
potty105621003pott__y
poundage1244023poundage
poutine93316823poutine
presage10312293presage
pretape113511623pretape
primage12169143primage
prophage1649433prophage
prostate10314533prostate
protease10209893protease
protege1059153protege
protrade1148213protrade
puttee85919723putt_ee
puttie84116303putt_ie
reportage1245023reportage
restage83316193restage
rootages939103rootages
rotate63320343ro_tate
rotte54625933rott__e
scutage1036333scutage
septage1078403septage
shortage1236313shortage
soakage1236103soakage
socage91012123so_cage
soccage1236283soccage
soilage8169353soilage
soutane7312063soutane
spoilage11195373spoilage
spottable1345343spottable
stage65330193__stage
storage8310473storage
stowage1136703stowage
tentage81010643tentage
tollage82610163tollage
tonnage8168053tonnage
towage1039833to_wage
unitage838993unitage
upstage10167443upstage
vantage11109893vantage
ventage11109623ventage
vintage11128143vintage
vittae93911003vitta_e
vittate10409733vittate
voltages1237253voltages
vorlage1136403vorlage
voyage1335473vo_yage
waftage14115323waftage
wantage11119623wantage
wastage11109253wastage
wattages12106783wattages
wattape12135383wattape
wordage1236503wordage

Search took 7 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.393454684.5
2DLD Change Limit1340272346.42020876.5
3Display Results2342340.0932516.1
 (SQL Overall)1786912346.90625874.7
 
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.