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

77 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
misframe154697(None) 
misframed1745621misframed
misframes1646631misframes
airframe1344292airframe
mainframe1642062mainframe
misgrade1247502misgrade
misname11119482mis_name
misrate91319142mis_rate
mistrace12312642mistrace
airframes1443663airframes
bedframe1643023bedframe
disgrace1248283disgrace
disrate81418523dis_rate
enframe1247363_enframe
frame105821803___frame
gisarme1044173gisar_me
inflame1256963_inflame
macrame1338713m_acrame
mainframes1752333mainframes
migrate101314173mi_grate
millrace1245433millrace
mirage92313653mi__rage
misate81222693mis__ate
misbecame1762723misbecame
misbrand1346413misbrand
miscreate1348893miscreate
misdate101413963mis_date
misdraw1345623misdra_w
misdrawn1444343misdrawn
misdraws1445753misdraws
misdrive1446683misdrive
misdrove1445433misdrove
misease92713043mis_ease
miserable1349653miserable
miserere1049273miserere
misfile122611553misf_ile
misfire12229893misf_ire
misform1437513misform_
misformed1745243misformed
misforms1545893misforms
misframing1846233misframing
misgave13298283mis_gave
misgraded1446233misgraded
misgrades1347363misgrades
misgraft1447203misgraft
mismade12129353mis_made
mismake15139373mis_make
mismate111415353mis_mate
misnamed13127593mis_named
misnames12119883mis_names
misogamy1644083misogamy
mispage12310523mis_page
misparse1237733misparse
misphrase1644573misphrase
misplace1437553misplace
misprice1448133misprice
misprize2147543misprize
misraise10410523mis_raise
misrated111315383mis_rated
misrates101318243mis_rates
misrule939353mis_rule
misshape1545983misshape
misspace1446523misspace
misstamp1443803misstamp
misstate10711343misstate
mistake131312623mis_take
mistime11312613mis_time
mistraced1439453mistraced
mistraces13312293mistraces
mistrain10311943mistrain
mistral91013643mistra_l
mistrals101212623mistrals
misusage1145173misusage
miswrite1348923miswrite
miswrote1346183miswrote
reframe1239393_reframe
subframe1546333subframe

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 Filter1786911461620.406440125.6
2DLD Change Limit146162777.33019940.2
3Display Results77770.0302566.7
 (SQL Overall)178691777.76623009.4
 
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.