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 “apishly” 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
apishly153566(None) 
aguishly1543612aguishly
apish105116632apish__
garishly1545692garishly
impishly1844092impishly
jadishly2243652jadishly
lavishly1744412lavishly
mopishly1864052mopishly
oafishly1754092oafishly
popishly1844192popishly
poshly1437722_poshly
rakishly1844292rakishly
uppishly1843012uppishly
vampishly2243112vampishly
waspishly2042612waspishly
acidly125211793aci_dly
agilely1135123agilely
airily93014823a_irily
aisle55223193a_is_le
alienly1037503alienly
alpinely1344343alpinely
amiably1438303amiably
anisole71010833anisole
apathy1437033apath_y
apetaly1237253apetaly
aphylly1843353aphylly
apiary113910383api_ary
apical10913903apical_
apically1539833apically
apicals1159923apicals
apiculi1145113apiculi
apostle937853apostle
apply125111393ap__ply
aptly105111813ap__tly
archly1437353a_rchly
aridly105513703ari_dly
ashy107717353a__sh_y
aspish114810333aspish__
avidly13548783avi_dly
axially1737233axially
babyishly2242513babyishly
beamishly1973343beamishly
bearishly1774293bearishly
boyishly1943663boyishly
brashly15427613brashly
briskly16165403briskly
bristly12178063bristly
caddishly1943333caddishly
cattishly1743473cattishly
cheapishly2361973cheapishly
crisply14426523crisply
dishy125712353_dish_y
dudishly1673233dudishly
elfishly1743503elfishly
elvishly1743313elvishly
epiboly1454353epiboly
epistle957893epistle
faddishly2042923faddishly
fairishly1843573fairishly
fishily1637643_fishily
fishy146011663_fish_y
fleshly16346093fleshly
foppishly2242673foppishly
freshly16286833freshly
gapingly1536183gapingly
gawkishly2342473gawkishly
goatishly1643383goatishly
grisly104310583gris_ly
gristly11187333gristly
haggishly2042913haggishly
harshly1636273harshly
hawkishly2542753hawkishly
highly1636823_highly
japingly2135763japingly
knavishly2242313knavishly
laithly1335653laithly
lumpishly1943053lumpishly
lushly12247343_lushly
mannishly1744113mannishly
mawkishly2442883mawkishly
modishly1744583modishly
moistly1236613moistly
mulishly1644893mulishly
noisily1038403noisily
offishly2063613offishly
ogrishly1544033ogrishly
owlishly1743593owlishly
paisley1235553paisley
papistry1543723papistry
piddly13319143_piddly
pily96132733_pi__ly
pimply15329213_pimply
pinkly155012243_pinkly
pish96127913_pish__
pished124817063_pished
pisher114317753_pisher
pishes114722103_pishes
pithily1567033_pithily
pithy135614463_pith_y
plushly15385383plushly
pushily15247983_pushily
pushy134614353_push_y
pussly11407373_pussly
raffishly2143303raffishly
rapidly1336523rapi_dly
rashly123410213_rashly
richly1438003_richly
slavishly1843243slavishly
snappishly2052193snappishly
spicily1438653spicily
spikily1635873spikily
spindly13257383spindly
swishy15365843swish_y
swithly1634443swithly
thistly1395963thistly
tipsily1236043tipsily
tonishly1445523tonishly
vapidly1635063vapi_dly
waggishly2042563waggishly
weakishly2243043weakishly
wisely122711713_wisely

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271217.22018563.3
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.68623248.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.