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

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

58 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
reshipping184379(None) 
preshipping1852891preshipping
redipping1555592re_dipping
reshaping1557742resh_aping
reshining13310742reshi_ning
shipping163611252__shipping
unshipping1843202unshipping
chipping18389793__chipping
equipping2342843_equipping
estopping1434793_estopping
gossipping1641903gossipping
hipping153915103___hipping
preshaping1845423presh_aping
recapping1636453re_capping
receipting1546753receipting
redshirting1643263redshirting
reequipping2551393reequipping
rehinging1437453re_hinging
rehiring122911883re_hi_ring
remapping1635023re_mapping
repping123314983re___pping
resailing103314253resai_ling
resampling1544333resampling
rescinding1436723rescinding
reseizing19311233resei_zing
reshaving1657273resh_aving
reshingling1642393reshingling
reshipped1753893reshipp_ed
reshipper1643623reshipp_er
reshippers1742853reshippers
reshoeing1336593resh_oeing
reshooting1436223reshooting
reshowing1646633resh_owing
residing103015473res_i_ding
resifting133512093res_ifting
resigning1139463res_igning
resiling93520173res_i_ling
resining92919553res_i_ning
resisting103215313res_isting
resiting93521123res_i_ting
resitting103414873res_itting
resizing182714163res_i_zing
respiring12159903respi_ring
respiting121912863respi_ting
respring111614063res__pring
restamping1565213restamping
rethinking1845183rethinking
rewrapping1843343rewrapping
ripping123315743r___ipping
shippings17275683__shippings
shopping163611293__shopping
sipping123117433__s_ipping
skipping17297603__skipping
slipping133510663__slipping
snipping13308853__snipping
transhipping2073223transhipping
whipping19328173__whipping
worshipping2251553worshipping

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 Filter1786911406030.530337152.8
2DLD Change Limit140603586.23322557.8
3Display Results58580.0331757.6
 (SQL Overall)178691586.79626293.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.