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

210 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
pottages11291045(None) 
cottages113310491cottages
plottages1244241plottages
portages112613221portages
postages112815321postages
potages102416421po_tages
pottage103310601pottage_
cottage104210572cottage_
cottager11306812cottager
cottagers12305382cottagers
cottagey14305232cottagey
cuttages11297222cuttages
dotages92311792do_tages
footages1239052footages
frottages1384992frottages
hostages122311692hostages
montages111412182montages
outages82317322_outages
plottage1144432plottage_
portage103013642portage_
portaged12228462portaged
postage103214852postage_
potage92715902po_tage_
potatoes1039942potatoes
potties93723542pott_ies
pottles93816982pott_les
rootages939102rootages
voltages1237252voltages
wattages12106782wattages
apostates1149163apostates
bondages1237893bondages
borages103917163bo_rages
boscages1366643boscages
boskages1565423boskages
bottles94216273bott_les
cartages11313313cartages
coinages11310803coinages
collages113514243collages
cordages12310113cordages
corkages1539103corkages
corsages11310363corsages
corteges1198823corteges
cottae84615703cotta_e_
cottars94412243cotta_rs
cottas84615573cotta__s
courages11311393courages
cowages13310943co_wages
cowhages1736113cowhages
cuttage10318343cuttage_
dockages1635983dockages
dosages92310803do_sages
dotage82711613do_tage_
dottles83912283dott_les
ecotages1136973ecotages
floatages1344233floatages
flotages1237163flotages
foggages1434213foggages
foliages1247623foliages
footage1148843footage_
forages114217283fo_rages
frontages13116183frontages
frottage1245083frottage_
homages131011593ho_mages
hostage113111233hostage_
hotcakes1744703hotcakes
hotties103016963hott_ies
lockages1536723lockages
lottes65322753lott__es
lovages1138033lo_vages
meltages1148243meltages
metages102714973_metages
mintages111110513mintages
montage101211713montage_
montaged12107763montaged
montanes101114523montanes
moorages1139053moorages
mortgages1344023mortgages
mottes85523693mott__es
mottles93415803mott_les
mottoes93412193mott_oes
moulages1138053moulages
nonages8313843no_nages
nontaxes1537853nontaxes
notates72817483no_tates
octanes91111393_octanes
octaves12316963_octaves
ohmages13115093_ohmages
ottars64112223_otta_rs
ottavas1093483_ottavas
outage72017533_outage_
outrages92215933outrages
outtakes12310033outtakes
packages17138733packages
pages85235073p___ages
partakes1449923partakes
passages1139513passages
patties93425143patt_ies
pawnages1435313pawnages
peages94321853p__eages
pectases122411193pectases
pectates122213953pectates
peerages1189893peerages
pelages10714613p_elages
pentanes10316083pentanes
peonages1138473peonages
petrales10312983petrales
pettles93916483pett_les
phages125213513p__hages
phototaxes2246663phototaxes
phytanes1645763phytanes
pillages113012613pillages
pilotages1245503pilotages
pipages1289423p_ipages
pipeages1336423pipeages
pittances1345703pittances
pittas86014523pitta__s
plages94520153p__lages
platanes102711883platanes
plotties103111413plott_ies
plumages1335653plumages
poetises10313953poetises
poetizes19310253poetizes
poetries10315583poetries
poleaxes1767273poleaxes
pomaces132712123po_maces
pomades123711733po_mades
pontes83627853pont__es
portables1337873portables
portaled11239203portaled
portals94015563porta_ls
portances1349833portances
porterages1345973porterages
postals93716383posta_ls
postbags1345293postbag_s
postdates1248863postdates
postfaces1656273postfaces
posties93128813post_ies
postures10313783postures
potables12179703potables
potashes1337833potashes
potences12710693potences
potentates12106333potentates
potholes13312933potholes
potiches1539203potiches
potlaches16115263potlaches
potlines10714213potlines
potpies113116173po_tpies
potsies93019483po_tsies
potstones1149213potstones
potted94624013pott__ed
potteen9319673pott_een
potteens10256793potteens
potter83926983pott__er
pottered112311663pottered
potterer102310263potterer
potterers11218663potterers
potteries11313603potteries
potters94024343pott_ers
pottier93516493pott_ier
pottiest102815973pott_iest
pottiness1179703pottiness
pottle84416103pott_le_
pottos84615873pott__os
poundages1344153poundages
poutines102415103poutines
presages11312203presages
pretapes122811533pretapes
primages13159273primages
prophages1749763prophages
prostates11314423prostates
protases102115033protases
proteases112110833proteases
proteges1149923proteges
puttees93612913putt_ees
putties94420023putt_ies
reportages1344383reportages
restages92815773restages
rootage839053rootage_
rotates72819773ro_tates
rottes64524833rott__es
scutages1136503scutages
septages1168263septages
shortages1336513shortages
soakages1336143soakages
socages101012053so_cages
soccages1336383soccages
soilages9189673soilages
soutanes8312933soutanes
spoilages12184713spoilages
stages75629493__stages
storages9311103storages
stowages1236473stowages
tentages91011043tentages
tollages92410193tollages
tonnages9187873tonnages
towages1139233to_wages
unitages938273unitages
upstages11147373upstages
vantages12119023vantages
ventages12119773ventages
vintages12118273vintages
voltage1136863voltage_
vorlages1236033vorlages
voyages1435703vo_yages
waftages15105393waftages
wantages12109023wantages
wastages12109753wastages
wattage1186983wattage_
wattapes1395253wattapes
wordages1337053wordages

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622107.37619815.9
3Display Results2102100.0932258.1
 (SQL Overall)1786912107.87522690.9
 
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.