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

171 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
packages1713873(None) 
package16128011package_
packaged18115751packaged
packager17136151packager
packagers18144681packagers
dockages1635982dockages
lockages1536722lockages
packwaxes2743412packwaxes
parkades1538272parkades
passages1139512passages
pawnages1435312pawnages
pickaxes2344912pickaxes
repackages1942612repackages
tankages13217112tankages
trackages1645342trackages
ackees124914583_ack_ees
acreages1138373_acreages
adages8412953_a_dages
alkanes113812933_alkanes
ambages1269623_ambages
anlages82414113_anlages
apanages1137013apanages
backaches22146813backaches
backdates1848153backdates
backhoes1938543backhoes
backstages1945013backstages
baggages1335443baggages
bandages12310633bandages
barrages11711083barrages
blockages1844063blockages
boskages1565423boskages
brockages1844783brockages
brokages1536253brokages
bulkages1535273bulkages
cabbages1537203cabbages
cackles153717203cack_les
cages85936013__c_ages
carnages11312213carnages
cartages11313313cartages
cockades1738433cockades
corkages1539103corkages
damages11511273da_mages
dockage1535723dockage_
encages103313783enc_ages
escuages1145163escuages
facades1339033fac_ades
garages9314113ga_rages
garbages1238183garbages
gavages1237683ga_vages
hackees165014103hack_ees
hackies163418243hack_ies
hackles162917063hack_les
haulages1236623haulages
haylages1536013haylages
incages103013883inc_ages
jacales16310323jac_ales
jackals2036893jacka_ls
jackass2034963jacka_ss
jackasses2243713jackasses
jackies202912623jack_ies
jacklegs2233963jacklegs
lactases1038513lactases
lactates10311223lactates
lavages1138603la_vages
leakages1334933leakages
linkages1385953linkages
lockage1436613lockage_
mackles154415753mack_les
macrames1438953macrames
manages103418963ma_nages
massages1159883massages
mispackages2251683mispackages
pacas96029403pac_a__s
paces96741113pac___es
pachas135017143pacha__s
pacifies15311223pacifies
packable1838633packable
packaging1945163packaging
packagings2042543packagings
packed154822603pack__ed
packer144223403pack__er
packers153818893pack_ers
packet144726503pack__et
packeted17148283packeted
packets155114773pack_ets
packings174310063packings
packmen1746313pack_men
packness1636933packness
packs135528933pack___s
packsacks1844253packsacks
padnags1135083padnag_s
pages85235073p___ages
palaces114216453pa_laces
palates93624933pa_lates
palpates122613063palpates
pancakes1637073pancakes
panchaxes2344453panchaxes
parades104121463pa_rades
parbakes1638343parbakes
parges94529543pa__rges
parkade1437583parkade_
parkas125018023parka__s
partakes1449923partakes
passades1139203passades
passage1039803passage_
passaged1236243passaged
pavanes123612653pa_vanes
pawnage1335873pawnage_
paxwaxes1942053paxwaxes
peages94321853p__eages
pectases122411193pectases
pectates122213953pectates
peerages1189893peerages
pelages10714613p_elages
peonages1138473peonages
phages125213513p__hages
pickaxe2244623pickaxe_
pickaxed2443513pickaxed
pickles153215443pick_les
picrates122013213picrates
pikakes1245823p_ikakes
pillages113012613pillages
pipages1289423p_ipages
pipeages1336423pipeages
placates12311753plac_ates
plages94520153p__lages
plumages1335653plumages
portages112613223portages
postages112815323postages
potages102416423p_otages
pottages112910453pottages
prepackages2252083prepackages
presages11312203presages
primages13159273primages
rampages1336673rampages
ravages1139403ra_vages
repackage1842713repackage_
repackaged2042303repackaged
repackager1951743repackager
repackagers2051263repackagers
saccades13137253saccades
salvages1238123salvages
sausages937003sausages
savages1139973sa_vages
scalages113010253scalages
sinkages1386853sinkages
soakages1336143soakages
socages101012053soc_ages
soccages1336383soccages
spackles16319953spack_les
stockages1644923stockages
tackles133816523tack_les
takahes1436173ta_kahes
tallages92312003tallages
tankage12257773tankage_
tannages9228963tannages
trackage1545653trackage_
truckages1643523truckages
uncages103213773unc_ages
vacates12312833vac_ates
vantages12119023vantages
wackes154717713wack__es
waftages15105393waftages
wakames1635283wa_kames
wantages12109023wantages
warpages1437053warpages
wastages12109753wastages
wattages12106783wattages
wickapes1943703wickapes
wreckages1942773wreckages
yardages1336203yardages

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.406440125.6
2DLD Change Limit1461621717.59319249.6
3Display Results1711710.0632714.3
 (SQL Overall)1786911718.06222164.6
 
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.