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

118 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
pratingly153837(None) 
gratingly1437401gratingly
bracingly1745942bracingly
dartingly1436952dartingly
grazingly2344942grazingly
pantingly1537862pantingly
poutingly1536482poutingly
prating103424452prating__
prattlingly1752242prattlingly
probingly1746012probingly
pryingly1735542pr_yingly
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
dotingly1337343_dotingly
draggingly1743003draggingly
drawlingly1843293drawlingly
driftingly1843673driftingly
drivingly1745163drivingly
droningly1445763droningly
erringly1237773er_ringly
evadingly1744133evadingly
exactingly2343483exactingly
fittingly1645273fittingly
flamingly1845033flamingly
flaringly1646263flaringly
gapingly1536183_gapingly
glaringly1445833glaringly
gloatingly1543563gloatingly
gnawingly1763933gnawingly
graspingly1743363graspingly
grating93923183grating__
gratings103910763grating_s
gropingly1644853gropingly
growingly1744523growingly
haltingly1645703haltingly
japingly2135763_japingly
jarringly2045193jarringly
jestingly2045953jestingly
joltingly2044733joltingly
juttingly2044583juttingly
lastingly1337243lastingly
liltingly1345443liltingly
meaningly1546413meaningly
meltingly1546303meltingly
moaningly1535783moaningly
orating83520323orating__
partially1449033partially
parting103527383parting__
partings113513743parting_s
passingly1545783passingly
patently1347113p_atently
patiently1445633p_atiently
pipingly1635703p_ipingly
pirating11314513pirating__
pityingly1843953pityingly
placatingly1952333placatingly
plainly1236473pla_in_ly
plating103823073plating__
platings113611363plating_s
pleadingly1793393pleadingly
pleasingly1644173pleasingly
plyingly1734503p_lyingly
posingly1436933p_osingly
pouringly1545953pouringly
pratincole1452513pratincole
praying133717323praying__
preachingly2242903preachingly
pressingly1646003pressingly
pristinely1544793pristinely
pulingly1436803p_ulingly
punningly1545153punningly
purringly1545743purringly
pushingly1844733pushingly
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
sportingly1645543sportingly
staringly1337973staringly
takingly1635913_takingly
taxingly1935483_taxingly
teasingly1346053teasingly
tingly103815983___tingly
trustingly1444373trustingly
tryingly1535883tr_yingly
uprating11311113uprating__
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.420425454.8
2DLD Change Limit1486411186.95321378.0
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.41924085.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.