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 “prepackaged” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

62 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
prepackaged235186(None) 
prepackage2152151prepackage_
prepackages2252081prepackages
repackaged2042301_repackaged
prepacked20155652prepack__ed
repackage1842712_repackage_
repackager1951742_repackager
repackages1942612_repackages
mispackaged2351583mispackaged
overpackaged2552033overpackaged
packaged18115753___packaged
prepackaging2451503prepackaging
repackagers2051263_repackagers
repacked17188743_repack__ed
breakage1544184bre_a_kage_
breakages1644284bre_a_kages
mispackage2151814mispackage_
mispackages2251684mispackages
overpackage2352254overpackage_
overpackages2452094overpackages
package16128014___package_
packager17136154___packager
packages17138734___packages
preaccused1743254pre_accused
preached163412064pre_ac__hed
preacted132710944pre_ac__ted
preaged11612334pre____aged
prearranged1552704pre_arranged
prebaked1737174preba_k__ed
precharged1944554pre__charged
predeceased1752984predeceased
predicated1649144predic_ated
prefaced1638424prefac___ed
prelocated1597184preloc_ated
premarketed2052534premarketed
prepack1757644prepack____
prepacking2145774prepack_ing
prepacks1836584prepack___s
prepared132210874prep___ared
prepasted14137674prepa__sted
prepaved16177234prep___aved
preplaced1676484prep__laced
preprepared1551724preprepared
prepurchased22171864prepurchased
presaged1238804pre___saged
propagated1644634propa_gated
redamaged1443344_reda_maged
rejacketed2442274_rejacketed
repacified1844894_repacified
repackaging2142144_repackaging
reparked15208924_repark__ed
repassage1243124_repassage_
repassages1343054_repassages
repechage1743434_repechage_
repechages1843274_repechages
reracked15169124_rerack__ed
retacked15169274_retack__ed
retackled1644074_retack_led
trackage1545654tr__ackage_
trackages1645344tr__ackages
wreckage1842764wre__ckage_
wreckages1942774wre__ckages

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit148819628.78016949.8
3Display Results62620.0163875.0
 (SQL Overall)178691629.23219355.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.