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

117 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
pantingly153786(None) 
rantingly1337931rantingly
dartingly1436952dartingly
dauntingly1544232dauntingly
haltingly1645702haltingly
hauntingly1743812hauntingly
lastingly1337242lastingly
panting104025422panting__
passingly1545782passingly
poutingly1536482poutingly
pratingly1538372pratingly
punningly1545152punningly
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
calmingly1745623calmingly
canting104725903canting__
carpingly1736683carpingly
clankingly2043313clankingly
cunningly1545533cunningly
cuttingly1545373cuttingly
damningly1644763damningly
daringly1348573da_ringly
darlingly1436053darlingly
dashingly1745163dashingly
daubingly1644263daubingly
denyingly1744643denyingly
dotingly1337343_dotingly
exactingly2343483exactingly
failingly1636133failingly
fawningly1944053fawningly
fittingly1645273fittingly
flauntingly1842183flauntingly
gallingly1435863gallingly
gapingly1536183ga_pingly
gaspingly1644813gaspingly
glancingly1742873glancingly
gnawingly1763933gnawingly
gratingly1437403gratingly
hanting114124483hanting__
japingly2135763ja_pingly
jarringly2045193jarringly
jestingly2045953jestingly
joltingly2044733joltingly
juttingly2044583juttingly
liltingly1345443liltingly
longingly1445333longingly
meaningly1546413mean_ingly
meltingly1546303meltingly
mincingly1745193mincingly
moaningly1535783moan_ingly
naggingly1544273naggingly
painting113614423painting__
paintings12327103painting_s
panging113319113panging__
panning104019393panning__
pantile93918483panti__le
partially1449033partially
parting103527383parting__
partings113513743parting_s
pasting103826553pasting__
patently1347113pa_tently
patiently1445633pa_tiently
patting103722343patting__
pentangle1245003pentangle
pipingly1635703p_ipingly
pityingly1843953pityingly
placatingly1952333placatingly
planting113515383planting__
plantings12348403planting_s
plyingly1734503p_lyingly
posingly1436933p_osingly
pouringly1545953pouringly
prattlingly1752243prattlingly
probingly1746013probingly
pryingly1735543p_ryingly
pulingly1436803p_ulingly
punting103318443punting__
purringly1545743purringly
pushingly1844733pushingly
rackingly1945123rackingly
ragingly1337863ra_gingly
ranting84025413ranting__
raspingly1535813raspingly
rattlingly1443653rattlingly
ravingly1537293ra_vingly
ringingly1445783ringingly
savingly1537313sa_vingly
sparingly1537283spa_ringly
sportingly1645543sportingly
takingly1635913ta_kingly
taxingly1935483ta_xingly
tingly103815983___tingly
unkingly1637253_unkingly
varyingly1944693varyingly
vaultingly1743413vaultingly
wailingly1635523wailingly
wanting114220173wanting__
wantonly1443063wanton_ly
warningly1635513warningly
windingly1745323windingly
winkingly2044343winkingly
winningly1644413winningly
wittingly1644803wittingly
yappingly2043793yappingly
yawningly1943483yawningly

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.440406115.9
2DLD Change Limit1486411177.46619909.1
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.95222471.2
 
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.