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

82 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
preshaped174552(None) 
preshape1537531preshape_
preshapes1667091preshapes
reshaped1437201_reshaped
presaged1238802pres_aged
preshipped1742962preshipped
preshowed1875182preshowed
presoaked1635652presoaked
prestamped1742962prestamped
pretaped13339132pre_taped
reshape1249042_reshape_
reshaper1336912_reshaper
reshapes1338802_reshapes
reshaved1536872_reshaved
beshamed1635733_beshamed
escaped12388853__escaped
freshed143312593fresh__ed
freshened1645253freshened
misshaped1744753misshaped
persuaded1344373persuaded
preadapted1643733preadapted
preaged11612333pre__aged
prebaked1737173pre_baked
precharged1944553precharged
predated12513273pre_dated
prefaced1638423pre_faced
prefaded1537823pre_faded
preheated1539813preheated
preloaded1335923preloaded
prepared132210873pre_pared
prepaved16177233pre_paved
preplaced1676483preplaced
prepped11329903pre__pped
presage10312293pres_age_
presager1138443pres_ager
presages11312203pres_ages
presale9416353pres_ale_
presales10315263pres_ales
prescored14409403prescored
presented12311633presented
preserved15107563preserved
preshaping1845423preshaping
preship1439793preship__
preships1539313preship_s
presided12410553pres_ided
presifted1536873presifted
presliced1435983presliced
presolved1545273presolved
presorted1239453presorted
pressed103317313pres__sed
pressured1237333pressured
prestored125111673prestored
presumed1337973pres_umed
pretape113511623pre_tape_
pretapes122811533pre_tapes
pretyped16306123pre_typed
prewrapped1762163prewrapped
pshawed16103033p__shawed
reaped94122453_re__aped
resawed113111183_res_awed
rescaled113311303_rescaled
resealed92713963_resealed
reseated93220263_reseated
reshapers1435493_reshapers
resharpen1443423_resharpen
reshave1338603_reshave_
reshaven1435193_reshaven
reshaves1438733_reshaves
reshined123011123_reshined
reshipped1753893_reshipped
reshoed112212153_resh_oed
reshowed15117063_reshowed
reslated93517523_reslated
resoaked1337943_resoaked
respaced1338503_respaced
respaded1238133_respaded
restaged103011863_restaged
restamped1444433_restamped
restated93120183_restated
retaped103814283_re_taped
shaped125020103___shaped
unshaped14148443_unshaped

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 Filter1786911486410.436409841.7
2DLD Change Limit148641826.71622132.4
3Display Results82820.0501640.0
 (SQL Overall)178691827.20224811.3
 
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.