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

105 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
distorting123958(None) 
disporting1439821disporting
discording1547662discording
disgorging1455012disgorging
disparting1438932disparting
disrooting1247742disrooting
disserting121310852disserting
distasting1248022distasting
distortion1146692distortion
distortions1246612distortions
disturbing1445652disturbing
intorting10311412_intorting
missorting1347122missorting
assorting1037303_assorting
contorting13410103contorting
dehorting1447213d_ehorting
deporting1369593d_eporting
deserting11713143des_erting
desorbing1346363des_orbing
destroying1564903destroying
dictating1338883dict_ating
disarming1338803dis_arming
disbarring1445283disbarring
disbursing1445373disbursing
discanting1449453discanting
discarding1547343discarding
discepting1658473discepting
discerning1447863discerning
discoing12511453disco__ing
discounting1547443discounting
discoursing1544853discoursing
disgusting1345963disgusting
disheriting1646453disheriting
disjecting2177243disjecting
disjoining1965723disjoining
disjointing2045293disjointing
dislocating1546733dislocating
dislodging1444403dislodging
dismasting1446383dismasting
dismounting1545083dismounting
disowning1446113dis_owning
dispersing1449303dispersing
dispiriting1545943dispiriting
disposing1339933dispo_sing
disproving1746293disproving
disputing1337763dis_puting
disrating11714553dis_rating
disrobing1347703disro_bing
disrupting1446343disrupting
disseating121111783disseating
dissecting14139473dissecting
dissenting121310293dissenting
disserving15117013disserving
dissolving1545113dissolving
distaining1248903distaining
distancing1447083distancing
distending1348333distending
distilling1247793distilling
distort81120333distort___
distorted1139373distort_ed
distorter1048403distort_er
distorters1147163distorters
distortional1353483distortional
distorts91112353distort__s
distracting1569253distracting
distrain9412243dist_rain_
distrains10411333dist_rains
distraint101112903dist_raint
districting1559003districting
distrusting1386493distrusting
disuniting1247403disuniting
disyoking1844993disyo_king
dittoing1036263ditto__ing
diverting142410333di_verting
divorcing1644323di_vorcing
doctoring1346183doctor_ing
escorting1237713_escorting
extorting1746763_extorting
importing1438193_importing
misforming1845403misforming
misparting1538083misparting
misrouting1347223misrouting
misstarting14125203misstarting
misterming1538603misterming
miswording1744863miswording
pastoring12310853pastor_ing
pistoling1268493pisto_ling
pistolling1345353pistolling
resorting10614613res_orting
restarting11310663restarting
restoring10314613restor_ing
retorting10613273_retorting
ripsnorting1451533ripsnorting
shorting122514803__shorting
sistering101213753sister_ing
snorting92613373__snorting
sorting83221813__s_orting
sporting112415463__sporting
starting93116173__starting
storing83921123__stor_ing
storming11209423__storming
storying12249673__storying
stotting92811163__stotting
upstarting1343883upstarting
visoring1238373vis_or_ing

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.1561145455.1
2DLD Change Limit1406031056.06323190.3
3Display Results1051050.0462282.6
 (SQL Overall)1786911056.26528522.1
 
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.