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

121 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
rantingly133793(None) 
pantingly1537861pantingly
dartingly1436952dartingly
dauntingly1544232dauntingly
gratingly1437402gra_tingly
haltingly1645702haltingly
hauntingly1743812hauntingly
lastingly1337242lastingly
pratingly1538372pra_tingly
rackingly1945122rackingly
ragingly1337862ra_gingly
ranting84025412ranting__
raspingly1535812raspingly
rattlingly1443652rattlingly
ravingly1537292ra_vingly
ringingly1445782ringingly
slantingly1445152slantingly
tauntingly1443912tauntingly
vauntingly1743622vauntingly
wastingly1636372wastingly
achingly1736623_achingly
anticly12410053_anti_cly
antigay1148223_anti_gay
anting75827023_anting__
antings85015583_anting_s
antinomy1367373_antinomy
atingle848253_a_tingle
banteringly1743883banteringly
bindingly1645403bindingly
bitingly1437393_bitingly
bracingly1745943bra_cingly
calmingly1745623calmingly
canting104725903canting__
carpingly1736683carpingly
clankingly2043313clankingly
crashingly1964083crashingly
cunningly1545533cunningly
cuttingly1545373cuttingly
damningly1644763damningly
daringly1348573da_ringly
darlingly1436053darlingly
dashingly1745163dashingly
daubingly1644263daubingly
denyingly1744643denyingly
dotingly1337343_dotingly
draggingly1743003draggingly
drawlingly1843293drawlingly
driftingly1843673driftingly
droningly1445763dron_ingly
exactingly2343483exactingly
failingly1636133failingly
fawningly1944053fawningly
fittingly1645273fittingly
flauntingly1842183flauntingly
franticly1744013franti_cly
gallingly1435863gallingly
gapingly1536183ga_pingly
gaspingly1644813gaspingly
glancingly1742873glancingly
gnawingly1763933gnawingly
granting103514523granting__
graspingly1743363graspingly
grazingly2344943gra_zingly
grindingly1643753grindingly
grinningly1543373grinningly
hanting114124483hanting__
japingly2135763ja_pingly
jarringly2045193jarringly
jestingly2045953jestingly
joltingly2044733joltingly
juttingly2044583juttingly
liltingly1345443liltingly
longingly1445333longingly
meaningly1546413mean_ingly
meltingly1546303meltingly
mincingly1745193mincingly
moaningly1535783moan_ingly
naggingly1544273naggingly
panting104025423panting__
passingly1545783passingly
poutingly1536483poutingly
prattlingly1752243prattlingly
punningly1545153punningly
rafting113815753rafting__
rainily10310433ra__inily
ramblingly1842973ramblingly
rancidly1444433ranci_dly
ranging94120263ranging__
ranking124320883ranking__
rankings13389173ranking_s
rating74938703ra_ting__
ratings84217413ra_ting_s
ratting83822363ratting__
renting84026853renting__
rippingly1744233rippingly
rivetingly1743553rivetingly
roaringly1336453roaringly
rockingly1944773rockingly
rompingly1745033rompingly
rousingly1335773rousingly
routinely1245133routinely
rovingly1536923r_ovingly
runtishly1543463runtishly
savingly1537313sa_vingly
takingly1635913ta_kingly
taxingly1935483ta_xingly
tingly103815983___tingly
trustingly1444373trustingly
unkingly1637253_unkingly
varyingly1944693varyingly
vaultingly1743413vaultingly
wailingly1635523wailingly
wanting114220173wanting__
wantonly1443063wanton_ly
warningly1635513warningly
windingly1745323windingly
winkingly2044343winkingly
winningly1644413winningly
wittingly1644803wittingly
yappingly2043793yappingly
yawningly1943483yawningly

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.423422437.4
2DLD Change Limit1486411217.58019609.6
3Display Results1211210.0602016.7
 (SQL Overall)1786911218.06322161.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.