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

91 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
missorting134712(None) 
assorting1037302_assorting
disporting1439822disporting
disserting121310852disserting
distorting1239582distorting
misforming1845402misforming
misparting1538082misparting
misrouting1347222misrouting
misseating131310942misseating
missetting13107902missetting
misstarting14125202misstarting
misstating13129312misstating
missuiting1356742missuiting
miswording1744862miswording
asserting1038663_asserting
consorting13410743consorting
discording1547663discording
disgorging1455013disgorging
disparting1438933disparting
disrooting1247743disrooting
disseating121111783disseating
dissecting14139473dissecting
dissenting121310293dissenting
disserving15117013disserving
dissolving1545113dissolving
escorting1237713_escorting
fissuring1344813fissur_ing
importing1438193_importing
inserting10914243_inserting
intorting10311413_intorting
minoring11311473mi_nor_ing
mirroring1246193mirror_ing
misacting1439083mi_sacting
miscasting1557073miscasting
misciting1439673mi_sciting
miscoding1538183misco_ding
miscoining1597763miscoining
miscooking1945003miscooking
miscopying2044973miscopying
miscounting1646053miscounting
miscutting1576053miscutting
misdating131010663mi_sdating
misdoing1238803misdo__ing
misdoubting1742793misdoubting
miseating121215433mi_seating
misediting1446573misediting
misfiring1536973misfir_ing
misfitting1645533misfitting
misfortune15112423misfortune
misgrowing1744633misgrowing
mishitting1645993mishitting
misjoining2085293misjoining
mislocating1645893mislocating
mislodging1543973mislodging
mismarking1955863mismarking
mismating141211823mi_smating
mismeeting1546243mismeeting
mismoving1745783mismo_ving
misparsing1546613misparsing
mispointing1645793mispointing
mispoising1546583mispoising
misquoting2244363misquoting
misrating121014853mi_srating
misreporting1753233misreporting
missaying1537633miss_aying
missending1446493missending
misshaping1844393misshaping
missing103619073miss___ing
missioning1347403missioning
missort9314653missort___
missorted1247033missort_ed
missorts1038323missort__s
missounding1543443missounding
misspacing1784983misspacing
misstopping1852433misstopping
misstriking1843933misstriking
misstyling1643833misstyling
misterming1538603misterming
misting103623383mi_s__ting
miswriting1646843miswriting
misyoking1944923misyo_king
presorting1339983presorting
reassorting1245023reassorting
resorting10614613_resorting
ripsnorting1451533ripsnorting
scissoring1343303scissor_ing
shorting122514803__shorting
snorting92613373__snorting
sorting83221813___sorting
sporting112415463__sporting
visoring1238373vi_sor_ing

Search took 9 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.420425454.8
2DLD Change Limit140603917.92317746.2
3Display Results91910.093978.5
 (SQL Overall)178691918.43621182.0
 
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.