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

54 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
graduated124589(None) 
gradated1157431grad_ated
graduate1058081graduate_
graduates1147681graduates
eradiated11178812eradiated
gradate9511232grad_ate_
gradates10510782grad_ates
graduand1143892gradua_nd
graduator1144572graduator
granulated1256942granulated
gratulated1255732gratulated
radiated102512592_radiated
adulated1039753__adulated
arcuated1138803ar_cuated
caudated1238063_caudated
eradiate91911753eradiate_
eradiates102010783eradiates
eradicated1446873eradicated
evacuated15196263evacuated
evaluated13276653evaluated
galeated104111583g_aleated
glaciated1365763glaciated
gladiate1057053gladiate_
graded94919553grad___ed
gradual936943gradua__l
gradually1444073gradually
graduals1046203gradua_ls
graduands1243583graduands
graduating1345003graduating
graduation1285793graduation
graduators1244233graduators
graduses1046453gradu_ses
grafted124110223gra__fted
granted94715103gra__nted
granulate1059183granulate_
granulates1148463granulates
grated84523923gr___ated
gratulate1047683gratulate_
gratulates1157133gratulates
gravitated1544133gravitated
graywater1643283graywater
grouted94111503gr_ou_ted
grunted9339283gr__unted
irradiated1243823irradiated
predated12513273pred_ated
quadrated2055923quadrated
radiate83416313_radiate_
radiates92415293_radiates
radicated13410123_radicated
redated93120923_red_ated
reradiated12177533reradiated
trabeated1246843trabeated
traduced1244673tradu_ced
valuated12239203_valuated

Search took 9 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.453394461.4
2DLD Change Limit148641547.61019532.3
3Display Results54540.0301800.0
 (SQL Overall)178691548.09322079.7
 
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.