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

148 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
reapply143432(None) 
preapply1443301preapply
apply125111392__apply
raptly11338912r_aptly
readily11711402readily
really93315612rea_lly
reply104015852re__ply
resupply1552522resupply
ripply13348002r_ipply
amply125012913__amply
apple94517673__apple
aptly105111813__aptly
areally10411243area_lly
beadily1378843beadily
beamily1477393beamily
beastly1277563beastly
cheaply1735023chea_ply
crappy15446803crapp_y
creakily1735393creakily
creamily1536363creamily
creepily1574953creepily
damply14337893_damply
dapple1138853_dapple
deadly113811473dea_dly
deafly13389123dea_fly
dearly104615323dea_rly
deathly14336863deathly
deeply1257013de_eply
dreamily1435143dreamily
drearily1236083drearily
early85324123_ea_rly
easily9313023_easily
featly123711753fea_tly
flappy1654483flapp_y
freakily1835003freakily
gappy136212033_gapp_y
grapple12378003grapple
greasily1236233greasily
greatly1137613grea_tly
haply135915063_ha_ply
happily1745763_happily
happy155813533_happ_y
headily1478623headily
heapy135914983hea_p_y
heavily1665903heavily
inaptly1244413inaptly
leakily1436473leakily
leally94012613lea_lly
leanly93811503lea_nly
mealy104422183mea__ly
meanly115412043mea_nly
measly113610443mea_sly
meatily12311093meatily
misapply1742883misapply
nappy126312333_napp_y
nearly94813733nea_rly
neatly93812483nea_tly
pappy114713803_papp_y
pearly116414843pea_rly
peartly1267453peartly
peppily1335133peppily
peppy114310363pe_pp_y
preppily1444593preppily
preppy1235523pre_pp_y
racily11715173r_acily
rally84725903r_a_lly
rankly133910453r_ankly
rapidly1336523r_apidly
rapped114122683r_apped
rappee103618673r_appee
rappel104211953r_appel
rappels11448803r_appels
rappen103512713r_appen
rapper104621573r_apper
rarely93513653r_arely
rashly123410213r_ashly
raspy106511703r_asp_y
rattly94111543r_attly
rawly115115833r_a_wly
readably1438383readably
readerly1245083readerly
ready94821503rea__dy
real45750293rea__l_
reality10313573reality
realm75621623rea__lm
reals55038653rea__ls
realty92713693rea_lty
reap65934743rea_p__
reapable12311393reapable
reaped94122453rea_ped
reaper84223143rea_per
reapers93520453reapers
reaping103621213reaping
reappear1242623reappear
reapplied1443673reapplied
reapplies1344923reapplies
reapplying1843023reapplying
reaps75626193rea_p_s
recapped1535943recapped
recopy1339043recop_y
redeploy1453173redeploy
redly94217203re__dly
redpoll1045043redpoll
reedily1179613reedily
reemploy1543343reemploy
refly113914563re__fly
regally1159873regally
rely75428953re___ly
remapped1534913remapped
repandly1445023repandly
repaper11310023repaper
repay104818453re__pay
repel74921403re_pel_
repels84318763re_pels
replay113412923re_play
repoll8410793re_poll
repp85418743re_pp__
repped114616723re_pped
repps95114343re_pp_s
resample1244673resample
respell947023respell
respelt9312143respelt
respray1236503respray
retally10413683retally
riantly1037613riantly
ripely112511153r_ipely
ripple103413913r_ipple
ropily113312443r_opily
roupily1246653roupily
rumply13348573r_umply
sappily1437163_sappily
sappy125413473_sapp_y
shapely1536893shapely
sharply15406833sharply
snappily1544323snappily
snappy1366103snapp_y
soapily1237963soapily
supply1346893_supply
teapoy1138113tea_poy
tearily10311153tearily
treacly1237093trea_cly
unaptly1244793unaptly
vealy115817773vea__ly
weakly1636483wea_kly
wearily1338783wearily
weasely13317853weasely
yearly125210273yea_rly
zappy21548943_zapp_y

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.406440125.6
2DLD Change Limit1340271487.03019065.0
3Display Results1481480.0463217.4
 (SQL Overall)1786911487.48223882.8
 
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.