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

134 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
gradating123731(None) 
graduating1345001graduating
eradiating1248732eradiating
gradation11107712gradation
gradations1286862gradations
grading103918712grad__ing
grafting13319622gra_fting
granting103514522gra_nting
grating93923182gr__ating
predating13514652predating
radiating111112122_radiating
redating102620172_redating
abating10413973__abating
adapting1236643__adapting
aggravating1752413aggravating
bradding13268933brad_ding
bromating1439173bromating
craaling112711353cra_aling
cradling122411453crad_ling
crafting143710173cra_fting
crating103725203cr__ating
creating113921953cr_eating
crediting1338843crediting
cremating14312193cremating
dating85326483___dating
drafting13339403dra_fting
dratting10389653dra_tting
emanating1239003emanating
eradicating1556633eradicating
foredating1577123foredating
gadding113411453g_ad_ding
gaiting93716583g_a_iting
garaging1139043g_araging
gardening1236513gardening
garoting10510703g_aroting
garotting1136103garotting
garroting1136953garroting
gasting95022763g_a_sting
gating84826953g___ating
gelating103015733g_elating
gemmating1576443gemmating
gestating11229983gestating
glaciating1445593glaciating
gladding1236303glad_ding
gloating102611463g_loating
goading103112853goad__ing
grabbing14267313gra_bbing
grabbling1564583grabbling
gracing113216443gr__acing
gradate9511233gradat__e
gradated1157433gradat_ed
gradates10510783gradat_es
gradational1354473gradational
gradin83517483grad__in_
gradine93317033grad__ine
gradins93416233grad__ins
graduation1285793graduation
graduations1385233graduations
graffiting1842923graffiting
graining102813183gra_ining
granulating1345293granulating
graphing1538533gra_phing
grappling1544993grappling
grasping12348833gra_sping
grassing103311973gra_ssing
gratin74520583gr__atin_
gratine84719193gr__atine
gratings103910763gr__atings
gratins84119183gr__atins
gratulating1344723gratulating
gravamina1542793gravamina
graveling1457383graveling
graving123114563gr__aving
gravitating1644003gravitating
gravitino1343703gravitino
graying124115883gr__aying
grayling1338003gra_yling
grazing183514553gr__azing
greasing102811393gr_easing
greeting103112353gr_eeting
griddling1333933griddling
griding103014973grid__ing
grifting13299263gr_ifting
grimacing1544033grimacing
gritting10309983gr_itting
groaning102410283gr_oaning
grouting103410793gr_outing
grudging12255993grud_ging
grunting10269583gr_unting
gyrating1337453g_yrating
iodating1038823_iodating
irradiating1353773irradiating
kraaling13186663kra_aling
lariating10311783lariating
mandating1339773mandating
misdating131010663misdating
narrating10310353narrating
nidating1039783_nidating
orating83520323or__ating
outdating11810863outdating
oxalating1745803oxalating
oxidating1845053oxidating
placating1438513placating
prating103424453pr__ating
preadapting1743653preadapting
probating14311193probating
pronating12313763pronating
prorating12314283prorating
quadrating2145653quadrating
radding103715003_rad_ding
raddling11229773_raddling
radicating1459063_radicating
radioing1039383_radioing
rafting113815753_ra_fting
ranting84025413_ra_nting
rating74938703_r__ating
ratting83822363_ra_tting
ravaging1346323_ravaging
readapting1445153readapting
rebating112418343_rebating
redacting13612303_redacting
relating92725443_relating
remating112322413_remating
reradiating1347263reradiating
rotating92614553_rotating
sedating103014113_sedating
trading93517973trad__ing
traducing1374013traducing
treating92519613tr_eating
unabating1246753unabating
updating1236593_updating
urinating10310653urinating
vacating14310353_vacating
variating13310943variating

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.406440125.6
2DLD Change Limit1486411348.28317945.3
3Display Results1341340.0602233.3
 (SQL Overall)1786911348.74920424.2
 
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.