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

176 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
packeted1714828(None) 
jacketed22146531jacketed
picketed17167381picketed
pocketed17147141pocketed
racketed15169121racketed
bracketed1855862bracketed
bucketed1736762bucketed
cacheted16148232cacheted
casketed1534952casketed
dackered16116892dackered
docketed16156582docketed
faceted13509562fac_eted
lackered15108672lackered
lackeyed18104512lackeyed
marketed1537322marketed
packaged18115752packaged
packed154822602pack__ed
packet144726502packet__
packets155114772packet_s
palleted1139872palleted
pargeted1238682pargeted
picketer16187432picketer
pocketer16157372pocketer
puckered1736102puckered
racheted14149502racheted
rocketed15157792rocketed
sacheted14127832sacheted
socketed15177342socketed
ticketed15146642ticketed
acceded1336103_acceded
accented13107773_accented
accepted15105383_accepted
accreted1336333accreted
ackee115825373_acke_e_
ackees124914583_acke_es
acted88521733_ac__ted
baccated15148373baccated
backdated1946483backdated
backed155725723back__ed
backhoed2047013backhoed
basseted1136753basseted
bickered17108003bickered
blackened1845273blackened
blanketed1643913blanketed
cackled164613303cack_led
cankered153010223cankered
carpeted1338953carpeted
cockered17710213cockered
cockeyed2096123cockeyed
cricketed1854683cricketed
crocketed1845123crocketed
daikered1495223daikered
darkened1435943darkened
dickered16117533dickered
excreted1846153excreted
facete115014833fac_ete_
facetted1445743facetted
galleted1038213galleted
garreted1057523garreted
hacked164923513hack__ed
hackee154921833hacke_e_
hackees165014103hacke_es
hackled173312493hack_led
hackneyed2242243hackneyed
hankered16289443hankered
harkened1637483harkened
hawkeyed2242403hawkeyed
jacked204817523jack__ed
jacket194720673jacket__
jackets205011373jacket_s
jockeyed2563413jockeyed
junketed2033523junketed
knackered1543683knackered
lacked135324653lack__ed
lactated1138863lactated
lakebed1434783la_kebed
lanceted1137073lanceted
lappeted13255833lappeted
machete14310883machete_
machetes1539633machetes
mackerel1644863mackerel
mackled164111923mack_led
marketer1437383marketer
nickeled15115513nickeled
nickered15117023nickered
paced106931683pac___ed
pacified1638363pacified
package16128013package_
packager17136153packager
packages17138733packages
packer144223403pack__er
packers153818893packe_rs
packeting1836853packeting
packmen1746313pack_men
paiked135113433paik__ed
painted104214633pa_inted
palmated132511003palmated
palpated13249763palpated
paltered113012483paltered
pampered15229233pampered
pandered121812573pandered
paneled10612573pa_neled
panted95024823pa__nted
papered122513173pa_pered
parapeted1446483parapeted
parceled1338343parceled
parented11912213parented
pargetted1345663pargetted
parietes10714543parietes
parked134425143park__ed
parkette14138023parkette
parkettes15137593parkettes
parleyed1436243parleyed
parqueted2144223parqueted
parroted1158843parroted
parted94228683pa__rted
pasted94426903pa__sted
pated85237843pa___ted
patented1188893patented
patted94724683pa__tted
pattened11299393pattened
pattered112714203pattered
paupered13216943paupered
paveed12438893pa_ve_ed
pecked155019103peck__ed
pelleted1138203pelleted
pickaxed2443513pickaxed
picked154421313pick__ed
pickeer153710113picke_er
pickeered1843463pickeered
pickerel1645273pickerel
picket144924313picket__
picketers17196483picketers
pickets154314183picket_s
pickled164011883pick_led
picoted1239213pic_oted
picrated132110113picrated
pinkened1535753pinkened
placated1338453plac_ated
placket15412873placket__
plackets1646583placket_s
pocked154818983pock__ed
pocket144622623pocket__
pocketers17196493pocketers
pockets154612253pocket_s
puckerer1645793puckerer
rabbeted1334443rabbeted
racemed1237013rac_emed
racked134526083rack__ed
racket125229423racket__
racketeer15174633racketeer
racketier15165413racketier
rackets134916873racket_s
rackety16499113racket_y
ratcheted1554783ratcheted
rejacketed2442273rejacketed
rocketer14158333rocketer
sacked135525213sack__ed
secreted1138633secreted
sickened1546783sickened
slackened1644243slackened
spackled17297803spack_led
suckered1537833suckered
tableted1137533tableted
tacked134723943tack__ed
tacket124627493tacket__
tackets134914363tacket_s
tackled143913193tack_led
targeted1037483targeted
thicketed1943613thicketed
tuckered1535963tuckered
vacated1349353vac_ated
valeted1139013va_leted
wakened1546873wa_kened
yachted1634853yac_hted
yacked164516793yack__ed

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 Limit1461621767.44019645.4
3Display Results1761760.0602933.3
 (SQL Overall)1786911767.90622601.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.