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

131 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
apically153983(None) 
epically15310581epically
amicably1746332amicably
animally1368642animally
antically14315682antically
apical10913902apica_l_
apicals1159922apica_ls
atypically2045742atypically
axially1737232axi_ally
basically1648032basically
capitally1646662capitally
laically1338982laically
magically1748962magically
manically16311702manically
optically1649902optically
panically16310432panically
radically15310422radically
spinally1338022spinally
spirally1348022spirally
topically1649532topically
typically1946082typically
aborally1347063aborally
actinally1448233actinally
actually1366853actually
aerially11911913aerially
alogically1648793alogically
amiably1438303ami_ably
amicable1438433amicable
amorally1348093amorally
anally9513503a__nally
anemically1748903anemically
annually1145833annually
anodally1246293anodally
anodically1648263anodically
apetaly1237253apeta_ly
aphetically2159253aphetically
aphylly1843353ap_hylly
apiary113910383api_a_ry
apiculi1145113apic_uli
apiculus1245413apiculus
apishly1535663api_shly
apocarpy1743013apocarpy
appall10379743ap_pall_
appalls11337743ap_palls
arctically17410373arctically
areally10411243a_really
aseptically1847413aseptically
astrally1148883astrally
atomically1749873atomically
atonally1148633atonally
aurally10310543a_urally
axenically2246803axenically
bridally1446453bridally
buccally1744623buccally
caecally1547703caecally
cecally1459393_cecally
civically1946563civically
clinally1347233clinally
coitally1339483coitally
comically18310523comically
conically16312813conically
cubically1846143cubically
cynically1947253cynically
domically1749103domically
ducally13257413_ducally
dyadically2055313dyadically
edaphically2254933edaphically
edictally1545473edictally
epical10413393epica_l_
epicalyx2242303epicalyx
epochally1943413epochally
ethically1748713ethically
facially1637643faci_ally
farcically2046323farcically
finally13310103_finally
finically1747953finically
fiscally1646073fiscally
focally15188553_focally
genically151110173genically
graphically2256223graphically
helically1749433helically
labially1336983labi_ally
lexically2146773lexically
locally12179723_locally
logically1548973logically
lyrically1746773lyrically
lytically1757383lytically
maniacally1744263maniacally
maritally1448233maritally
maximally2344393maximally
medically17310113medically
mesically16310093mesically
misally121111063_misally
musically1647853musically
myopically2246173myopically
nautically1548833nautically
ohmically1946903ohmically
ontically14311843ontically
optimally1644563optimally
orphically2047633orphically
osmically1647323osmically
pally105727123_p__ally
papally1437973_papally
penally121111763_penally
phatically20411313phatically
pical95524373_pica_l_
racially1339623raci_ally
radially1239783radi_ally
rascally1347733rascally
socially1338543socially
sonically14310953sonically
spacially1645653spacially
specially1647343specially
spicily1438653spic_ily
statically15411573statically
stoically1449673stoically
tactically1749753tactically
telically1449853telically
tidally1137933_tidally
tonically14311143tonically
toxically2147573toxically
tragically1648873tragically
tribally1347323tribally
tropically1749843tropically
uncially1339073uncially
vaginally1645233vaginally
vicarly1536463_vicarly
virally1339653_virally
vitally1339673_vitally
vocally15188343_vocally
xerically2149533xerically

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.1531167915.0
2DLD Change Limit1461621317.16020413.7
3Display Results1311310.0462847.8
 (SQL Overall)1786911317.35924282.0
 
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.