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

188 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
privily1520762(None) 
pricily142710281pricily
privity15268311privity
grimily1336522grimily
prickly18367892prickly
primely1457722primely
primly13439622pri_mly
priorly12335762priorly
prissily1346692prissily
privacy1744232privacy
privier122910452privier
privies122414262privies
privy13439832priv__y
prosily12611632prosily
airily93014823_airily
aridity11510113aridity
aridly105513703ari_dly
artily92814713ar_tily
brainily1337313brainily
bravely15428233bravely
brevity1534783brevity
briefly1534573briefly
briskly16165403briskly
bristly12178063bristly
brittly12165973brittly
civil103411933_civil_
civilly1535483_civilly
crazily2136923crazily
criminy14268453criminy
crinkly16387523crinkly
crispily1574693crispily
crisply14426523crisply
crusily12199093crusily
dirtily1138583dirtily
dribbly15274953dribbly
drily95816523dr__ily
drippily1643033drippily
drivel105110383drivel_
drivels11397923drivels
driving123910713driving
drivingly1745163drivingly
drizzly19364553drizzly
ervil8310303er_vil_
ervils948773er_vils
friarly13316213friarly
frigidly1643123frigidly
frilly124111443fri_lly
friskily1834503friskily
frivol1235113frivol_
frivols1334743frivols
frizzily2253143frizzily
frizzly21455793frizzly
fruitily1445143fruitily
gravely14469063gravely
gravidly1653743gravidly
gravity1437183gravity
grimly12459933gri_mly
grisly104310583gri_sly
gristly11187333gristly
grittily1244183grittily
grizzly19354473grizzly
heavily1665903heavily
icily101211693__icily
juicily1935493juicily
lively123310813_lively
lividly1434783_lividly
mirkily16266403mirkily
naively1335903naively
nervily1336863nervily
noisily1038403noisily
oilily93111723_oilily
pawkily1934203pawkily
peppily1335133peppily
perkily1637813perkily
peskily1635083peskily
pettily1238173pettily
phonily1537103phonily
piddly13319143p_iddly
pily96132733p___ily
pimply15329213p_imply
pinkly155012243p_inkly
pithily1567033pithily
pliably14147383pliably
pockily1846233pockily
podgily1435213podgily
pokily15309063p_okily
prebill1138803prebill
prefile123413183prefile
prepill1147583prepill
preppily1444593preppily
prettily1337283prettily
prevail1238243prevail_
prevails1337663prevails
preview1536473preview
previse123713793previse
pricey134412633pri_cey
pricier113313113pricier
pricing123417343pricing
prickle153611013prickle
pricky174210343pri_cky
pricy124814563pr__icy
priding113317543priding
priestly1345843priestly
prill74117943pr__ill
prills84015613pri_lls
primacy1635603primacy
primal104014623primal_
primarily1644673primarily
primary1437703primary
primi95017403primi__
primine113214823primine
priming123417373priming
primula1145713primula
princely1545153princely
priority1347443priority
priory114110263pri_ory
prising103321453prising
prissy11347853pri_ssy
private121513263private
privately1744893privately
privet113821343priv_et
privets122910053privets
priviest132310313priviest
privilege1552543privilege
prizing193514683prizing
probity14299683probity
prodigy1435573prodigy
profile123211153profile
prolixly2043113prolixly
pronely12310253pronely
proudly1336333proudly
provably1846213provably
provenly1646203provenly
provide1339853provide
proving134214073proving
proviso1237313proviso
pryingly1735543pryingly
pudgily1434903pudgily
puffily1834843puffily
pulpily1436103pulpily
punily11311773p_unily
pursily1238213pursily
pushily15247983pushily
racily11715173_racily
rainily10310433rainily
revile94921613_revile
richly1438003_richly
rifely123710033_rifely
rigidly1235533_rigidly
ripely112511153_ripely
ripply13348003_ripply
risibly1235643_risibly
riskily1436413_riskily
ritzily1945143_ritzily
rival85216503_rival_
rivalry1354033_rivalry
rivals94213183_rivals
riving104521423_riving
roily86121113_r_oily
ropily113312443_ropily
rosily93914713_rosily
savvily1634323savvily
shinily13268933shinily
slimily1247713slimily
spicily1438653spicily
spikily1635873spikily
springily1545583springily
tidily102811393_tidily
tinily94014433_tinily
trickily1736233trickily
trickly16369893trickly
trigly103810943tri_gly
trimly114410893tri_mly
trinity10310843trinity
triply114211023tri_ply
tritely1039003tritely
trivia938503trivi_a
trivial1038713trivial
trivially1545143trivially
trivium1256143trivium
vividly1744233_vividly
vivify1834703_vivify
wavily15219483_wavily
weevily1694643weevily
wilily123310763_wilily
wirily123310783_wirily
wriggly15324893wriggly
wrinkly17295753wrinkly

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.390458182.1
2DLD Change Limit1340271887.09618887.7
3Display Results1881880.0762473.7
 (SQL Overall)1786911887.56223630.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.