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

92 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
prestressing158397(None) 
restressing1266041_restressing
distressing1385973_distressing
overstressing1753713overstressing
preblessing1643733pre_blessing
precessing1598743pre__cessing
precreasing1645703pre_creasing
prescreening1752873prescreening
prestress1138133prestress___
prestressed1444703prestress_ed
prestresses1346723prestress_es
pretesting131810683pre_t_esting
pretreating1448893pre_treating
progressing1545773pr_ogressing
redressing1247823_re_dressing
regressing1248143_re_gressing
repressing13310393_re_pressing
stressing1038333___stressing
bestrewing1643774_bestre_wing
buttressing1453054_buttressing
depressing1448094_de_pressing
derepressing1653574derepressing
egressing1146854__e_gressing
estreating11710364__estreating
expressing2046624__expressing
fortressing1543964_fortressing
hostessing1444574_host_essing
overdressing1745734overdressing
pestering122315664p_est_e_ring
possessing1344674p_os_sessing
predeceasing18103064predeceasing
predigesting1753684predigesting
preerecting1646144pre_erecting
prefocussing2052344prefocussing
prefreezing2642874pre_freezing
prepossessing1862284prepossessing
preprocessing2053554preprocessing
prereleasing1552904prereleasing
prerinsing1347644pre__rinsing
prescribing1844554prescr_ibing
preselecting1744294preselecting
preselling1338694pres__elling
presenting131013024pres__enting
preserving1637364pres__erving
presetting131010834pres__etting
preshrinking2252444preshrinking
presorting1339984presor__ting
pressing112516444p____ressing
pressurising1573384pressurising
prestamping1863654prest_amping
prestissimo1551904prest_issimo
prestoring13310304prest__oring
presupposing1651884presupposing
presurveying2151354presurveying
pretasting13239284pre_t_asting
pretelling1338134pre_t_elling
pretending1438614pre_t_ending
pretexting20206974pre_t_exting
pretraining1446504pre_training
pretrimming1843034pre_trimming
processing15108184pr__ocessing
professing16106624pr__ofessing
prostrating1449394prostr_ating
protesting131910254pr_ot_esting
readdressing1552794_readdressing
rearresting1245964_rearresting
reassessing1243994_reassessing
recessing12611014_re__cessing
recrossing1386974_re_crossing
redigressing1552924_redigressing
reexpressing2263084reexpressing
reforesting1546194_reforesting
refreshing1746064_re_freshing
rescreening1444084_rescreening
respreading1545174_respreading
restraining1247534_restraining
restress82511774_restress___
restressed1146644_restress_ed
restresses1049314_restress_es
restretching1852894_restretching
restricting1449304_restricting
restriking1548044_restr_iking
restring91518784_restr___ing
restringing1345714_restringing
restriving1448134_restr_iving
retesting102614604_re_t_esting
retreading12128484_re_treading
retreating111414774_re_treating
testcrossing1551324_testcrossing
transgressing1562694transgressing
trespassing1442314tres_passing
waitressing1552494_waitressing

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 Filter1786911247900.390458182.1
2DLD Change Limit124790927.14017477.6
3Display Results92920.0631460.3
 (SQL Overall)178691927.59323533.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.