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

119 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
distorted113937(None) 
disported13310301disported
distorter1048401distorter
discorded1438132discorded
disgorged1345262disgorged
disparted1338852disparted
disrooted1147622disrooted
disserted11109812disserted
distasted1137962distasted
distort81120332distort__
distorters1147162distorters
distorts91112352distort_s
disturbed13195582disturbed
historied1347772historied
intorted9310122_intorted
missorted1247032missorted
undistorted1353062undistorted
assorted956603_assorted
bistered112913323bister_ed
bistort91216523bistort__
bistorts10118813bistort_s
bistred103311853bist_r_ed
contorted1239473contorted
dehorted1357303d_ehorted
deported1249703d_eported
deserted101012203des_erted
desorbed1236443des_orbed
destroyed1445083destroyed
dictated1239203dict_ated
disagreed1245463disagreed
disarmed1238643dis_armed
disbarred1345273disbarred
disbursed1365763disbursed
discanted1339333discanted
discarded1437083discarded
discepted1547523discepted
discerned1347863discerned
discoed11312483disco__ed
discord1139993discor__d
discounted1447843discounted
discoursed1445793discoursed
disgorge1145733disgorge_
disgorges1245853disgorges
disgusted1246123disgusted
disherited1546703disherited
disjected2086353disjected
disjoined1845833disjoined
disjointed1944833disjointed
dislocated1497523dislocated
dislodged1344573dislodged
dismasted1346833dismasted
dismounted1445413dismounted
disorder1038133dis_order
disowned1336433dis_owned
dispersed13119783dispersed
dispirited1445933dispirited
disport101015953disport__
disports111111113disport_s
disposed12310943dispo_sed
disproved16147343disproved
disputed1238353dis_puted
disrated10915573dis_rated
disrobed1238093disro_bed
disrupted1345973disrupted
disseated11711083disseated
dissected13108663dissected
dissented1199723dissented
disserved14107003disserved
dissolved1445593dissolved
distained1139603distained
distanced1348573distanced
distaste939943distaste_
distastes1039633distastes
distended12157923distended
distilled1147173distilled
distome10313233disto_me_
distomes11314163disto_mes
distorting1239583distorting
distortion1146693distortion
distracted1448873distracted
districted1448223districted
distrusted1246293distrusted
disturber12165123disturber
disunited1177273disunited
disyoked1745463disyo_ked
dittoed936733ditto__ed
diverted13199583di_verted
divorced1544313di_vorced
doctored1245613doctor_ed
escorted1136703_escorted
extorted1636233_extorted
histories12412473histories
imported13308693_imported
misformed1745243misformed
misparted1437263misparted
misrouted1247303misrouted
misstarted1344873misstarted
mistermed1438363mistermed
misworded1644233misworded
pastored1139963pastor_ed
pistoled11259593pisto_led
pistolled1255163pistolled
resorted9313493res_orted
restarted10410053restarted
restored96417193restor_ed
retorted9312333_retorted
shorted113614403__shorted
sistered92612803sister_ed
snorted83813493__snorted
sorted74523713__s_orted
sported104015433__sported
started84217323__started
stored75524213__stor_ed
storied8515163__storied
stormed1039043__stormed
stotted83511423__stotted
unsorted9312513uns_orted
upstarted1244213upstarted
visored1138143vis_or_ed

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 Filter1786911486410.410435831.7
2DLD Change Limit1486411196.35623385.9
3Display Results1191190.0631888.9
 (SQL Overall)1786911196.82926166.5
 
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.