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

98 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
misgrade124750(None) 
misgraded1446231misgraded
misgrades1347361misgrades
disgrace1248282disgrace
migrate101314172mi_grate
misframe1546972misframe
misgave13298282misg_ave
misgraft1447192misgraft
misguide12145702misguide
mismade12129352mis_made
misrate91319142mis_rate
mistrace12312642mistrace
aggrade1035643_aggrade
bigarade1244763bigarade
degrade10229903_degrade
disgraced1446743disgraced
disgracer1346183disgracer
disgraces1348453disgraces
disrate81418523dis_rate
dissuade1065933dissuade
emigrate1149603emi_grate
grade75126093___grade
ingrate8715123_ingrate
irade65618153_i__rade
margrave1444793margrave
migraine1157863mi_graine
migrant10314313mi_grant
migrated121110513mi_grated
migrates111112853mi_grates
millrace1245433millrace
mirage92313653mi__rage
misadd1037163mis__add
misate81222693mis__ate
misbrand1346413misbrand
misbranded1644143misbranded
misbrands1445153misbrands
miscode12310413mis_code
miscreate1348893miscreate
misdate101413963mis_date
misdraw1345623misdra_w
misdrawn1444343misdrawn
misdraws1445753misdraws
misdrive1446683misdrive
misdrove1445433misdrove
misease92713043mis_ease
miserable1349653miserable
miserere1049273miserere
misframed1745623misframed
misframes1646633misframes
misgauge1244253misgauge
misgive13339033misg_ive
misgrading1546823misgrading
misgrafted1743793misgrafted
misgrafts1544283misgrafts
misgrew1335523misgr_ew
misgrow1344433misgr_ow
misgrown1443983misgrown
misgrows1444963misgrows
misguided14144653misguided
misguider13174343misguider
misguides13165333misguides
mislead10419973mislead_
misleader1246503misleader
misleads11358543misleads
mismake15139373mis_make
mismate111415353mis_mate
misname11119483mis_name
misorder1147283misor_der
mispage12310523mis_page
misparse1237733misparse
misphrase1644573misphrase
misplace1437553misplace
misprice1448133misprice
misprize2147543misprize
misraise10410523mis_raise
misrated111315383mis_rated
misrates101318243mis_rates
misread10339723misread_
misreads11268923misreads
misrule939353mis_rule
misshape1545973misshape
misspace1446523misspace
misstate10711343misstate
mistake131312623mis_take
mistraced1439453mistraced
mistraces13312293mistraces
mistrain10311943mistrain
mistral91013643mistra_l
mistrals101212623mistrals
misusage1145173misusage
miswrite1348923miswrite
miswrote1346183miswrote
paygrade1543593paygrade
prograde1247183prograde
regrade92612033_regrade
subgrade1246053subgrade
tirade7311693ti__rade
upgrade11215823_upgrade

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.423422437.4
2DLD Change Limit146162987.09320606.5
3Display Results98980.0462130.4
 (SQL Overall)178691987.56223630.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.