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

63 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
disgraces134845(None) 
disgrace1248281disgrace_
disgraced1446741disgraced
disgracer1346181disgracer
disgracers1444731disgracers
displaces1448592displaces
disrates91118152dis_rates
distracts1249292distracts
misgrades1347362misgrades
mistraces13312292mistraces
degrades11269923d_egrades
diagramed1454453diagramed
diagrams1246133diagra_ms
diagraphs1644543diagraphs
diffracts1843233diffracts
digraphs15105753di_graphs
disagrees1146403disagr_ees
disbranches1953523disbranches
discases112014503dis_cases
diseases92415813dis_eases
disfrocks1942973disfrocks
disgorges1245853disgorges
disgraceful1861683disgraceful
disgracing1586743disgracing
disguises1146873disguises
dishrags1346203dishra_gs
dishwares1645863dishwares
disparages1446043disparages
displace1348653displace_
displaced1546793displaced
displacer1446433displacer
displacers1545013displacers
dispraise1248343dispraise
dispraises1347393dispraises
disprizes2148113disprizes
disproves15158513disproves
disrate81418523dis_rate_
disrated10915573dis_rated
disrobes1139743dis_robes
dissaves1239413dis_saves
dissuades1166243dissuades
distances12311653distances
distaves12311403dis_taves
distract11313023distrac_t
distracted1448873distracted
distrains10411343distrains
districts1248943districts
divorces1445673divor_ces
dogfaces1554143d_ogfaces
graces94523493___graces
ingrates9514173_ingrates
migrates111112853mi_grates
millraces1345753millraces
misframes1646633misframes
misgrade1247503misgrade_
misgraded1446233misgraded
misgrafts1544293misgrafts
misplaces1537953misplaces
misprices1547913misprices
misrates101318243mis_rates
misspaces1546513misspaces
mistrace12312643mistrace_
mistraced1439453mistraced

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 Filter1786911486410.420425454.8
2DLD Change Limit148641636.64322375.6
3Display Results63630.0302100.0
 (SQL Overall)178691637.09325192.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.