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

149 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
japingly213576(None) 
gapingly1536181gapingly
carpingly1736682carpingly
daringly1348572daringly
gaspingly1644812gaspingly
hopingly1735652hopingly
jangly174310602ja__ngly
japing165013572japing__
jarringly2045192jarringly
jibingly2144432jibingly
jingly174111932j__ingly
jokingly2334772jokingly
jumpingly2473862jumpingly
mopingly1636012mopingly
pipingly1635702pipingly
ragingly1337862ragingly
raspingly1535812raspingly
ravingly1537292ravingly
savingly1537312savingly
takingly1635912takingly
taxingly1935482taxingly
yappingly2043792yappingly
achingly1736623achingly
alpinely1344343alpinely
amazingly2444143amazingly
aping87327233_aping__
apishly1535663_apishly
atingle848253_atingle
beamingly1745843beamingly
bitingly1437393bitingly
blazingly2444483blazingly
bodingly1536383bodingly
boringly1438403boringly
bowingly1735793bowingly
bracingly1745943bracingly
calmingly1745623calmingly
coaxingly2245143coaxingly
cooingly1436353cooingly
cryingly1735743cryingly
damningly1644763damningly
dangly114212263da__ngly
darlingly1436053darlingly
dartingly1436953dartingly
dashingly1745163dashingly
daubingly1644263daubingly
dotingly1337343dotingly
erringly1237773erringly
evadingly1744133evadingly
failingly1636133failingly
faintly1337083fa_intly
fawningly1944053fawningly
flamingly1845033flamingly
flaringly1646263flaringly
fumingly1735743fumingly
gainly1049323ga_in_ly
gallingly1435863gallingly
gangly113911583ga__ngly
gaping105618923gaping__
gibingly1534793gibingly
glaringly1445833glaringly
gnawingly1763933gnawingly
graspingly1743363graspingly
gratingly1437403gratingly
grazingly2344943grazingly
gropingly1644853gropingly
gulpingly1644163gulpingly
haltingly1645703haltingly
jading154214023jading__
jadishly2243653jadishly
jangle144416293ja__ngle
jauping17307193jauping__
jawing174414963jawing__
jeeringly2045143jeeringly
jerkingly2444273jerkingly
jestingly2045953jestingly
jiggly18378713j__iggly
jingle143815223j__ingle
jointly1735483j_ointly
joltingly2044733joltingly
joshingly2343853joshingly
jungly17407693j__ungly
juttingly2044583juttingly
kingly143511303__kingly
lastingly1337243lastingly
limpingly1794573limpingly
lispingly1584813lispingly
livingly1535633livingly
losingly1236393losingly
lovingly1535703lovingly
lumpingly1784663lumpingly
luringly1237323luringly
lyingly14115263_lyingly
mainly11411493ma_in_ly
malignly1444683malignly
meaningly1546413meaningly
moaningly1535783moaningly
movingly1735913movingly
musingly1436433musingly
naggingly1544273naggingly
nippingly1743983nippingly
pantingly1537863pantingly
passingly1545783passingly
pinkly155012243__pinkly
plyingly1734503plyingly
posingly1436933posingly
pratingly1538373pratingly
pryingly1735543pryingly
pulingly1436803pulingly
quakingly2644223quakingly
rackingly1945123rackingly
rainily10310433ra_inily
rantingly1337933rantingly
rapidly1336523rapi_dly
raping94829853raping__
rippingly1744233rippingly
roaringly1336453roaringly
rompingly1745033rompingly
rovingly1536923rovingly
saintly1039343sa_intly
sapiently1444863sapiently
searingly1338273searingly
shingly143210813_shingly
singly104015853__singly
slopingly1544593slopingly
soaringly1337273soaringly
spangly1336473_spangly
sparingly1537283sparingly
spindly13257383_spindly
staringly1337973staringly
supinely1376293supinely
tangly104413913ta__ngly
taping94222393taping__
teasingly1346053teasingly
tingly103815973__tingly
tryingly1535883tryingly
unkingly1637253unkingly
urgingly1336733urgingly
vainly1258503va_in_ly
vapidly1635063vapi_dly
varyingly1944693varyingly
vexingly2244663vexingly
vyingly1794153_vyingly
wailingly1635523wailingly
warningly1635513warningly
wastingly1636373wastingly
wearingly1636413wearingly
weepingly1844263weepingly
wooingly1534903wooingly
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 Filter1786911461620.406440125.6
2DLD Change Limit1461621497.36019859.0
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.82922824.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.