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

50 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
misstarting1412520(None) 
misstating13129311missta_ting
misparting1538082mi_sparting
misseating131310942missea_ting
missorting1347122miss_orting
misstamping1842992misstamping
disparting1438933di_sparting
disseating121111783dissea_ting
disserting121310853diss_erting
distasting1248023di_stasting
distorting1239583di_storting
instarring1144063_instarring
instating10812213_insta_ting
kickstarting1851153kickstarting
militating1348823milita_ting
misacting1439083mi_s_acting
misadapting1743063misadapting
misawarding1842993misawarding
miscasting1557073mi_scasting
mischarging2043713mischarging
misdating131010663mi_sda_ting
miseating121215433mi_sea_ting
misgrafting1844083misgrafting
mishearing1647883mishear_ing
mislearning1443723mislearning
mismarking1955863mi_smarking
mismating141211823mi_sma_ting
misparsing1546613mi_sparsing
misplanting1645633misplanting
misrating121014853mi_sra_ting
missaying1537633miss_a_ying
missetting13107903miss_etting
misshaping1844393missha_ping
misspacing1784983misspa_cing
misstart10410043misstart___
misstarted1344873misstart_ed
misstarts1145833misstart__s
missteering1444453missteering
misstepping1862753misstepping
misstopping1852433misstopping
misstriking1843933misstriking
misstyling1643833misst_yling
missuiting1356743miss_uiting
mistaking1699693mi_sta_king
misterming1538603mi_sterming
mistracing1569603mi_stracing
outstarting1245013outstarting
restarting11310663_restarting
starting93116173___starting
upstarting1343883_upstarting

Search took 6 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 Filter1786911216330.390458182.1
2DLD Change Limit121633505.08023943.5
3Display Results50500.0301666.7
 (SQL Overall)178691505.50032489.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.