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

136 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
achingly173661(None) 
aching126521972aching__
dashingly1745162dashingly
rackingly1945112rackingly
shingly143210812_shingly
aahing1019015763aahing__
abidingly1644543abidingly
accusingly1852633accusingly
achiness1339703achiness
achiral12109183achiral_
acidly125211793ac_i_dly
acing87429153ac_ing__
acridly13396533acri_dly
actinal9312293actinal_
actinally1448233actinally
acting95920983acting__
actings104512463acting_s
actively1647063actively
adoringly1445423adoringly
affinely1743863affinely
ahing98928353a_hing__
alpinely1344343alpinely
amazingly2444133amazingly
amusingly1544423amusingly
anhinga11104823anhing_a
anhingas12104333anhingas
arching136216693arching__
archings14499863arching_s
ashing107824093ashing__
atingle848253a_tingle
atoningly1365373atoningly
baching156017753baching__
bitingly1437383bitingly
bodingly1536383bodingly
boringly1438403boringly
bowingly1735793bowingly
bracingly1745943brac_ingly
caching156317503caching__
calmingly1745613calmingly
carpingly1736673carpingly
chicly16429203_chi_cly
chidingly1944243_chidingly
chiefly1834103_chiefly
childly1644803_childly
chilly144113223_chi_lly
chimbly1974593_chimbly
chinchy20335513_chinchy
chinky185610543_chin_ky
chintzy24364223_chintzy
chokingly2243983_chokingly
clingy12659063_cling_y
cooingly1436353cooingly
crashingly1964083crashingly
cringle103010353_cringle
crinkly16387523_crinkly
cryingly1735743cryingly
damningly1644763damningly
daringly1348573daringly
darlingly1436043darlingly
dartingly1436943dartingly
daubingly1644263daubingly
dotingly1337343dotingly
eching126315563eching__
erringly1237773erringly
exactingly2343473exactingly
failingly1636123failingly
fawningly1944053fawningly
fetchingly2242723fetchingly
fumingly1735743fumingly
gallingly1435853gallingly
gapingly1536183gapingly
gaspingly1644813gaspingly
gibingly1534793gibingly
gushingly1744253gushingly
haltingly1645693haltingly
hopingly1735653hopingly
japingly2135763japingly
jarringly2045193jarringly
jibingly2144433jibingly
jingly174111933__jingly
jokingly2334773jokingly
joshingly2343853joshingly
kingly143511303__kingly
lastingly1337233lastingly
laughingly1842703laughingly
livingly1535633livingly
losingly1236393losingly
lovingly1535703lovingly
luringly1237323luringly
lyingly14115263_lyingly
machinery1943093machinery
mockingly2143993mockingly
mopingly1636013mopingly
movingly1735913movingly
musingly1436433musingly
naggingly1544273naggingly
pantingly1537853pantingly
passingly1545783passingly
pipingly1635703pipingly
plyingly1734503plyingly
posingly1436933posingly
preachingly2242903preachingly
pryingly1735543pryingly
pulingly1436803pulingly
pushingly1844733pushingly
ragingly1337863ragingly
rantingly1337923rantingly
raspingly1535813raspingly
ravingly1537293ravingly
rockingly1944773rockingly
rovingly1536923rovingly
savingly1537313savingly
scathingly1943303scathingly
searchingly2042843searchingly
shingle117711283_shingle
shinily13268933_shinily
singly104015853__singly
slashingly1743863slashingly
smashingly1943193smashingly
takingly1635913takingly
taxingly1935483taxingly
thinly1238673_thin_ly
tingly103815973__tingly
touchingly1943063touchingly
tryingly1535883tryingly
unkingly1637253unkingly
urgingly1336733urgingly
varyingly1944683varyingly
vexingly2244663vexingly
vyingly1794153_vyingly
wailingly1635513wailingly
warningly1635513warningly
wastingly1636363wastingly
wooingly1534903wooingly
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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621367.01620832.7
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.23524698.1
 
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.