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

123 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
mistraces1331229(None) 
mistrace12312641mistrace_
mistraced1439451mistraced
disgraces1348452disgraces
distracts1249282distracts
millraces1345752millraces
misframes1646632misframes
misgrades1347362misgrades
misplaces1537952misplaces
misprices1547912misprices
misrates101318242mis_rates
misspaces1546512misspaces
mistakes141213412mist_akes
misteaches1744992misteaches
mistrains11511352mistrains
mistrals101212622mistra_ls
abstracts1346593abstracts
australes9317763australes
bistres94017213bistr__es
castrates11312673castrates
citrates102315093ci_trates
disgrace1248283disgrace_
disgraced1446743disgraced
disgracer1346183disgracer
disgracers1444733disgracers
displaces1448593displaces
disrates91118153dis_rates
distances12311653distances
distaves12311403dist_aves
distract11313023distrac_t
distracted1448873distracted
distrains10411333distrains
districts1248933districts
filtrates1247733filtrates
footraces1446713footraces
lustrates939463lustrates
magistracies1752233magistracies
magistrates1453733magistrates
matrices12312083m_atrices
micturates1456093micturates
midspaces1643993midspaces
migrates111112853mi_grates
millrace1245433millrace_
minitracks1892643minitracks
mintages111110513mint_ages
miracles1238333mi__racles
mirages102213533mi__rages
misacts1139353mis__acts
misbiases1346253misbiases
misbrands1445153misbrands
mischances1946373mischances
miscreates1448103miscreates
misdates111113633mis_dates
misdraws1445753misdra_ws
misdrives1546213misdrives
miseases102614343mis_eases
miserables1445613miserables
misereres1148183misereres
miseries10320403miser_ies
misframe1546973misframe_
misframed1745623misframed
misgrade1247503misgrade_
misgraded1446233misgraded
misgrafts1544293misgrafts
mismakes16129883mis_makes
mismates121114563mis_mates
misnames12119883mis_names
mispages13311183mis_pages
misparses1347653misparses
misphrases1745083misphrases
misplace1437553misplace_
misplaced1646253misplaced
misprice1448133misprice_
mispriced1646423mispriced
misprizes2247223misprizes
misraise10410523mis_raise
misraises1149933mis_raises
misrate91319143mis_rate_
misrated111315383mis_rated
misrules1039383mis_rules
misshapes1645913misshapes
misspace1446523misspace_
misspaced1645353misspaced
misstates11710633misstates
misstrikes1644363misstrikes
mistake131312623mist_ake_
mistaken14147833mist_aken
mistaker14109333mist_aker
mistakers15117083mist_akers
misteach1545443misteac_h
mistimes12612613mist_imes
mistitles1147953mistitles
mistouches1743393mistouches
mistracing1569603mistracing
mistrain10311943mistra_in
mistrained1347583mistrained
mistral91013643mistra__l
mistreated1348423mistreated
mistreats1148633mistreats
mistress10310703mistr_ess
mistresses1247993mistresses
mistrials1148133mistrials
mistrusts1146013mistrusts
mistruths1443683mistruths
mistrysts1443863mistrysts
mistunes10311133mist_unes
mistypes15116713mist_ypes
misusages1244973misusages
miswrites1447983miswrites
mitres83922073mi_tr__es
monstrances1545013monstrances
mustaches16166053must_aches
nitrates82516223ni_trates
outraces102217863_outraces
pistaches1646673pist_aches
postfaces1656273postfaces
postrace12310543postrace_
retraces101417273_retraces
ristras7311563ristra__s
strafes104516003__strafes
strakes114218073__strakes
titrates82314663ti_trates
traces85329933___traces

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.500357382.0
2DLD Change Limit1486411236.37623312.6
3Display Results1231230.0631952.4
 (SQL Overall)1786911236.93925751.7
 
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.