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

130 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
gratingly143740(None) 
grazingly2344941grazingly
pratingly1538371pratingly
bracingly1745942bracingly
dartingly1436952dartingly
gapingly1536182g_apingly
glaringly1445832glaringly
gloatingly1543562gloatingly
gnawingly1763932gnawingly
graspingly1743362graspingly
grating93923182grating__
gratings103910762grating_s
gropingly1644852gropingly
growingly1744522growingly
ragingly1337862_ragingly
rantingly1337932_rantingly
ravingly1537292_ravingly
amazingly2444143amazingly
atingle848253__atingle
beamingly1745843beamingly
bitingly1437393_bitingly
blazingly2444483blazingly
brainily1337313bra_inily
carpingly1736683carpingly
coaxingly2245143coaxingly
crashingly1964083crashingly
crating103725203crating__
cryingly1735743cr_yingly
cuttingly1545373cuttingly
daringly1348573_daringly
darlingly1436053darlingly
degradingly1852523degradingly
dotingly1337343_dotingly
draggingly1743003draggingly
drawlingly1843293drawlingly
driftingly1843673driftingly
drivingly1745163drivingly
droningly1445763droningly
erringly1237773er_ringly
evadingly1744133evadingly
exactingly2343483exactingly
fittingly1645273fittingly
flamingly1845033flamingly
flaringly1646263flaringly
gainly1049323g_a_in_ly
gallingly1435863gallingly
gangly113911583g_a__ngly
gaspingly1644813gaspingly
gating84826953g_ating__
gatings95212823g_ating_s
gibingly1534793g_ibingly
girdingly1544403girdingly
glancingly1742873glancingly
glowingly1743613glowingly
goatishly1643383goatishly
gracing113216443gracing__
grading103918713grading__
grafting13319623grafting__
grainy103914213gra_in__y
grandly1238743gra__ndly
granting103514523granting__
graticule1254573graticule
gratify1436113grati__fy
gratifyingly2381013gratifyingly
gratin74520583gratin___
gratine84719193gratin__e
gratinee93710783gratin_ee
gratineed11334473gratineed
gratinees10307323gratinees
gratins84119183gratin__s
gravidly1653743gravi_dly
graving123114563graving__
graying124115883graying__
grazing183514553grazing__
grazings19337263grazing_s
grindingly1643753grindingly
grinningly1543373grinningly
grippingly1942623grippingly
growlingly1842843growlingly
grudgingly1742423grudgingly
gruelingly1543503gruelingly
gulpingly1644163gulpingly
gushingly1744253gushingly
gyrating1337453gyrating__
haltingly1645703haltingly
japingly2135763_japingly
jarringly2045193jarringly
jestingly2045953jestingly
joltingly2044733joltingly
juttingly2044583juttingly
lastingly1337243lastingly
liltingly1345443liltingly
meaningly1546413meaningly
meltingly1546303meltingly
moaningly1535783moaningly
orating83520323orating__
pantingly1537863pantingly
poutingly1536483poutingly
prating103424453prating__
prattlingly1752243prattlingly
probingly1746013probingly
pryingly1735543pr_yingly
quakingly2644223quakingly
rackingly1945123_rackingly
rainily10310433_ra_inily
raspingly1535813_raspingly
rating74938703_rating__
ratings84217413_rating_s
rattlingly1443653_rattlingly
roaringly1336453roaringly
rovingly1536923_rovingly
savingly1537313_savingly
scathingly1943313scathingly
searingly1338273searingly
slantingly1445153slantingly
soaringly1337273soaringly
sparingly1537283sparingly
staringly1337973staringly
takingly1635913_takingly
taxingly1935483_taxingly
teasingly1346053teasingly
tingly103815973___tingly
trustingly1444373trustingly
tryingly1535883tr_yingly
urgingly1336733ur_gingly
varyingly1944693varyingly
warningly1635513warningly
wastingly1636373wastingly
wearingly1636413wearingly
wittingly1644803wittingly

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.423422437.4
2DLD Change Limit1486411306.93621430.4
3Display Results1301300.0632063.5
 (SQL Overall)1786911307.42224075.9
 
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.